Eclipse Community Forums: Newcomers » Help regarding JDBC Driver

Home » Newcomers » Newcomers » Help regarding JDBC Driver(Using the mysql-connector-java-5.1.22 with Juno giving Class Not Found error.)

Show: Today's Messages :: Show Polls :: Message Navigator

Help regarding JDBC Driver [message #986014]

Sat, 17 November 2012 13:47

Praveen Raj

Messages: 2
Registered: November 2012

Junior Member

I use windows 7 x64.

I downloaded and installed these latest version softwares and installed them using environment variables and other proceedures:
jdk7u9(64 bit)
MySQL Server 5.5(64 bit)
Apache 7.0.32
Eclipse 4.2 Juno(64 bit)
and mysql-connector-java-5.1.22.zip

The jdk, eclipse and apache had been integrated. I had them tested. MySQL also works fine on itself. I accessed it using the command prompt.
But could'nt use the 'com.mysql.jdbc.Driver' within, neither my java application program nor my jsp program. These programs were tested successfully on another machine. So the codes are correct.
I'm affraid it is some version incompatibility between these...

The java application was just to insert a value into the database:

import java.sql.*;
public class dbtest
{
public static void main(String[] args)
{
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/student201","student201","tester201");
Statement st=con.createStatement();
st.executeUpdate("Insert into LoginRegister values('jhgjh','gfhj','jhf',2)");
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
}

The error report and the complete stack at the time of error was...

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at dbtest.main(dbtest.java:7)

Please Help!! Sad

Report message to a moderator

Re: Help regarding JDBC Driver [message #986026 is a reply to message #986014]

Sat, 17 November 2012 17:32

Praveen Raj

Messages: 2
Registered: November 2012

Junior Member

There had been an improvement... the jdbc driver just worked for the application I mentioned above, by explicitly describing the location of the 'docs' and 'src' folder in the driver defenition. But is still not in terms with the jsp project. I get the same error.

Report message to a moderator

Re: Help regarding JDBC Driver [message #986039 is a reply to message #986026]

Sat, 17 November 2012 19:41

Russell Bateman

Messages: 3798
Registered: July 2009
Location: Provo, Utah, USA

Senior Member

On 11/17/2012 10:32 AM, Praveen Raj wrote:
> There had been an improvement... the jdbc driver just worked for the
> application I mentioned above, by explicitly describing the location of
> the 'docs' and 'src' folder in the driver defenition. But is still
> not in terms with the jsp project. I get the same error.
>

The JDBC connector (JAR) must be in on the classpath (use Build Path).

Report message to a moderator

Re: Help regarding JDBC Driver [message #1180330 is a reply to message #986026]

Sun, 10 November 2013 23:18

raji m

Messages: 1
Registered: November 2013

Junior Member

hi praveen,

please could you explain me in detail what you did to fix this error as i did add the jar file to the buildpath and the simplest standalone java application to connect to mysql database still doesnt work , whereas it does work in comandprompt when i write the same code in a notepad and run it ...

Report message to a moderator

Previous Topic:	How to change my user name?
Next Topic:	Compute SWT widget size according to Windows DPI

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 04:35:21 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter