facing problem in database connectivity in jsp to mysql

Reply

Join Date: Jul 2007
Posts: 11
Reputation: muskan is an unknown quantity at this point 
Solved Threads: 0
muskan muskan is offline Offline
Newbie Poster

facing problem in database connectivity in jsp to mysql

 
0
  #1
Jul 30th, 2007
i am writing code and also the error i am facing in database connectivity in jsp to mysql .plz help me .thanx

/code


import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Connection;
import java.sql.*;
import java.io.*;

public class ConnBean
{
Connection conn;
Statement st ;
public ConnBean()
{
String sqlDriver= "com.mysql.jdbc.Driver";
String hostName = "localhost:3306/";
String dbName = "mydb";
String userID = "root";
String password = "webportal";

//databse URL
String dbURL = "jdbc:mysql://" + hostName + dbName;

try {
Class.forName(sqlDriver);
}
catch (ClassNotFoundException e) {
e.printStackTrace();
}
try {
conn = DriverManager.getConnection(dbURL, userID, password);
st = conn.createStatement();
System.out.println("db connected");
}
catch (SQLException e) {

System.out.println("Exception occured during get connection" + e);
}
}

public static void main(String asdas[]) throws SQLException
{

ConnBean conn=new ConnBean();


//ResultSet rs=conn.executeQ("select * from clients");
}
}

/code
and the error that jdk 1.5 ( with mysql 5.0.41) is showing is
C:\Program Files\Java\jdk1.5.0\bin\java.exe ConnBean
Working Directory - D:\jsp code\
Class Path - .;c:\Kawapro5.0\kawaclasses.zip;c:\program files\java\jdk1.5.0\lib\tools.jar;c:\program files\java\jdk1.5.0\jre\lib\rt.jar
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

at java.net.URLClassLoader$1.run(URLClassLoader.java:200)

at java.security.AccessController.doPrivileged(Native Method)

at java.net.URLClassLoader.findClass(URLClassLoader.java:188)

at java.lang.ClassLoader.loadClass(ClassLoader.java:306)

at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268)

at java.lang.ClassLoader.loadClass(ClassLoader.java:251)

at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)

at java.lang.Class.forName0(Native Method)

at java.lang.Class.forName(Class.java:164)

at ConnBean.<init>(ConnBean.java:25)

at ConnBean.main(ConnBean.java:44)

Exception occured during get connectionjava.sql.SQLException: No suitable driver

Process Exit...
Reply With Quote Quick reply to this message  
Join Date: Mar 2007
Posts: 686
Reputation: sillyboy is on a distinguished road 
Solved Threads: 61
sillyboy's Avatar
sillyboy sillyboy is offline Offline
Practically a Master Poster

Re: facing problem in database connectivity in jsp to mysql

 
0
  #2
Jul 30th, 2007
Make sure you have "com.mysql.jdbc.Driver" in your web application. It will be contained in a .jar and it needs to go with your other java libraries you use.
Reply With Quote Quick reply to this message  
Join Date: Jul 2007
Posts: 11
Reputation: muskan is an unknown quantity at this point 
Solved Threads: 0
muskan muskan is offline Offline
Newbie Poster

Re: facing problem in database connectivity in jsp to mysql

 
0
  #3
Jul 31st, 2007
please tell me which .jar file has to saved and where in jdk or in tomcat althought i have mysql-connector-java-3.0.8-stable-bin.jar file that i have copied in tomcat in libs .please tel are u talking about this .jar file now wat i have to do?please guide me kindly
Reply With Quote Quick reply to this message  
Join Date: Mar 2007
Posts: 686
Reputation: sillyboy is on a distinguished road 
Solved Threads: 61
sillyboy's Avatar
sillyboy sillyboy is offline Offline
Practically a Master Poster

Re: facing problem in database connectivity in jsp to mysql

 
0
  #4
Jul 31st, 2007
I don't know what .jar the mysql driver is in. It shouldn't be that hard to find with a google. The .jar file goes into your web app directory under "WEB-INF\lib".
Reply With Quote Quick reply to this message  
Join Date: Feb 2006
Posts: 2,335
Reputation: masijade has much to be proud of masijade has much to be proud of masijade has much to be proud of masijade has much to be proud of masijade has much to be proud of masijade has much to be proud of masijade has much to be proud of masijade has much to be proud of masijade has much to be proud of 
Solved Threads: 250
Moderator
masijade's Avatar
masijade masijade is offline Offline
Nearly a Posting Maven

Re: facing problem in database connectivity in jsp to mysql

 
0
  #5
Jul 31st, 2007
Copy that jar file into WEB-INF/lib, not into just any generic tomcat lib directory.
Java Programmer and Sun Systems Administrator

----------------------------------------------

Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it.
--Brian Kernighan
Reply With Quote Quick reply to this message  
Join Date: Jul 2007
Posts: 11
Reputation: muskan is an unknown quantity at this point 
Solved Threads: 0
muskan muskan is offline Offline
Newbie Poster

Re: facing problem in database connectivity in jsp to mysql

 
0
  #6
Jul 31st, 2007
Originally Posted by masijade View Post
Copy that jar file into WEB-INF/lib, not into just any generic tomcat lib directory.

yes i have copied the .jar files in WEB-INF/lib but still when i have compiled database connectivity program with mysql in java it gave the same error.

D:\Program Files\Java\jdk1.5.0\bin\java.exe ConnBean
Working Directory - C:\final project\jsp code\
Class Path - .;c:\Kawapro5.0\kawaclasses.zip;d:\program files\java\jdk1.5.0\lib\tools.jar;d:\program files\java\jdk1.5.0\jre\lib\rt.jar
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

at java.net.URLClassLoader$1.run(URLClassLoader.java:200)

at java.security.AccessController.doPrivileged(Native Method)

at java.net.URLClassLoader.findClass(URLClassLoader.java:188)

at java.lang.ClassLoader.loadClass(ClassLoader.java:306)

at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268)

at java.lang.ClassLoader.loadClass(ClassLoader.java:251)

at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)

at java.lang.Class.forName0(Native Method)

at java.lang.Class.forName(Class.java:164)

at ConnBean.<init>(ConnBean.java:25)

at ConnBean.main(ConnBean.java:44)

Exception occured during get connectionjava.sql.SQLException: No suitable driver

Process Exit...
Reply With Quote Quick reply to this message  
Join Date: Jul 2007
Posts: 11
Reputation: muskan is an unknown quantity at this point 
Solved Threads: 0
muskan muskan is offline Offline
Newbie Poster

Re: facing problem in database connectivity in jsp to mysql

 
0
  #7
Jul 31st, 2007
Is there any need to copy the .jar files(that are mysql-connector-java-3.0.8-stable-bin) in jdk.If so then where these files should be copied in order to include in the class path of java.please answer it to solve my problme.thanx
Reply With Quote Quick reply to this message  
Join Date: Dec 2004
Posts: 4,178
Reputation: peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of 
Solved Threads: 481
Moderator
Featured Poster
peter_budo's Avatar
peter_budo peter_budo is online now Online
Code tags enforcer

Re: facing problem in database connectivity in jsp to mysql

 
0
  #8
Jul 31st, 2007
Here is tutorial how to set PATH and CLASSPATH for java
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)

LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group
Reply With Quote Quick reply to this message  
Join Date: Aug 2007
Posts: 3
Reputation: Xolera is an unknown quantity at this point 
Solved Threads: 0
Xolera Xolera is offline Offline
Newbie Poster

Re: facing problem in database connectivity in jsp to mysql

 
0
  #9
Aug 5th, 2007
I have the same problem. Try to copy MySQL connector jar file to
%JAVA_HOME%/jre/lib/ext/
Reply With Quote Quick reply to this message  
Join Date: Feb 2006
Posts: 2,335
Reputation: masijade has much to be proud of masijade has much to be proud of masijade has much to be proud of masijade has much to be proud of masijade has much to be proud of masijade has much to be proud of masijade has much to be proud of masijade has much to be proud of masijade has much to be proud of 
Solved Threads: 250
Moderator
masijade's Avatar
masijade masijade is offline Offline
Nearly a Posting Maven

Re: facing problem in database connectivity in jsp to mysql

 
1
  #10
Aug 6th, 2007
Originally Posted by Xolera View Post
I have the same problem. Try to copy MySQL connector jar file to
%JAVA_HOME%/jre/lib/ext/
Bad, bad, bad. Never copy anything to the lib/ext directory of the jre. Learn how to use and set classpaths properly. If he has the proper jarfile, and places it in the WEB-INF/lib directory of the web application he is trying to reach, the classes will be found. If they are not, he has done something wrong. Either copied it to the lib directory of the wrong application, not copied the right jarfile, or, maybe, somehow or another, changed the tomcat configuration so that it does not look there. Sorry to say it, but all of those things are "his problem", and copying anything to the lib/ext directory is not the answer, regardless of whether or not "it works".
Java Programmer and Sun Systems Administrator

----------------------------------------------

Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it.
--Brian Kernighan
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the JSP Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC