Re: trouble connecting to mysql

Arne Vajhøj 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="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"

Also, it's pretty pointless to keep calling
  Class.forName("com.mysql.jdbc.Driver");
after the first time in a program run.  Once the driver is loaded, it's 
loaded, and loading it again is redundant.

Also, move your Java source code ("scriptlet") out of the JSP and into a
Java 
servlet source file.  Research the "Model-View-Controller" (MVC) pattern
and 
what Sun calls the "Model 2" web-app architecture.  Among other things, it

will refactor your database connection code back two layers where it
belongs.

-- 
Lew