Re: trouble connecting to mysql

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="jdbc:mysql:localhost\\neo";
> String username="root";
> String passwd="abc";
> try{
> 	Class.forName("com.mysql.jdbc.Driver");
> 	Connection conn=DriverManager.getConnection(dbURL,username,passwd);

> 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.

The connection URL looks wrong as well. It should be
something like:

"jdbc:mysql://localhost/neo"

Arne