Re: trouble connecting to mysql

On Apr 7, 12:07=A0am, Arne Vajh=F8j <a...@[EMAIL PROTECTED]
> wrote:
> naveen wrote:
> > hello friends
> > i have just touched jsp programming and i m having trouble connecting
> > to mysql database.
> > I m using tomcat 6
>
> > the connection part of the code of my jsp (HelloMySql.jsp) is-->
> > String dbURL=3D"jdbc:mysql:localhost\\neo";
> > String username=3D"root";
> > String passwd=3D"abc";
> > try{
> > =A0 =A0Class.forName("com.mysql.jdbc.Driver");
> > =A0 =A0Connection
conn=3DDriverManager.getConnection(dbURL,username,pass=
wd);
> > i m using this driver -->
> > mysql-connector-java-5.1.6-bin.jar
> > and have put it in this location
> > C:\Program Files\Apache Software Foundation\Tomcat 6.0\lib
>
> > further i have appended this to the Classpath environment variable -->
> > C:\Program Files\Apache Software Foundation\Tomcat 6.0\lib\mysql-
> > connector-java-5.1.6-bin.jar
>
> > but the sever returns error that
> > No suitable driver found
>
> Unless you want to use container managed connection pool you
> should put the jar file in your web apps WEB-INF/lib.
>

well i have put it the jar file there too.

> The connection URL looks wrong as well. It should be
> something like:
>
> "jdbc:mysql://localhost/neo"

well i thought that you have to provide the location of the database
in this place "jdbc:mysql://localhost/neo"
though i have tried putting database as //localhostneo also
 but this didnt work too

please suggest something
or if you could give me a working example it would be very kind of
you
thanks