JDBC for MySQL

Hi,
I get an error message "Exception in thread main java.lang.NoClassDefFoundErr:". I downloaded mysql connector/j for Java and extracted to a directory. I think something wrong with class path settings. Can you please provide more info. to rectify this error. I am using windows 2000.

Thanks in advance.

Indika

Can u make it more clear......

Class not found exception is trying to find which class

write the whole lines of exceptions that u r getting in

ur program......It will help us to understand what actually

the problem is

Yes, be more specific.
Show us your classpath and to which directory you extracted the connector.

Here is my source code.
========================
import java.sql.*;

public class Connect
{
public static void main(String[] args)
{
Connection con = null;
try
{
String userNm = "test";
String password = "test";
String DB = "jdbc:mysql://localhost/test";
Class.forName ("com.mysql.jdbc.Driver").newInstance();
con = DriverManager.getConnection (DB, userNm, password);
}
catch (Exception e)
{
System.out.println ("Cannot connect to database server");
}
finally
{
if (con != null)
{
try
{
con.close ();
System.out.println ("terminated");
}
catch (Exception e) {}
}
}
}
}
================
In environment Variables (under User variables)
I setup Variable name = CLASSPATH and
variable value = "E:\JavaApp\mysql-connector-java-3.1.10-bin.jar"
(This is where I keep the jar file)

Still not clear .....U should write the exception u r getting

ClassNotFoundException comes when ur application is

not able to get the required class ....

tell the name of class ur program is trying to find

write here all the lines of Exception

Hi Sunil,
That is the full source code of my program. According to you I have missed out something. Sorry I have no idea about the missing part. My only requirement is to connect to MySql database through java (JDBC).

I would appreciate if you can correct this program.

Thanks.

Indika

Program looks good, we only want to now which class it cannot find.

Indika

Let me clear my point, when u r running this program,

u r getting a ClassNotFoundException. Is it ok ???

Now i just want all the lines of Exception , u r getting

when u run ur program...

In the begining , u mentioned that u r getting one exception.....

but we will come to know the reason of exception, when we will

see the whole exception...

Again run ur program, and whatever exception it generates .....

simply copy from there and paste here.....

Note again::::::::: The complete exception, below the line

ClassNotFoundException

Am i clear now ???

Here is the full error message.
Exception in thread "main" java.lang.NoClassDefFoundError : Connect.

Just a single line.....It should be more than one lines

Exception should display the name of the class, which ur

application is not able to find....

ur program is ok......

We can help only when we can see the complete list of

exception

I see

How you are starting the program?
java Connect ???

try use -classpath with full path to Connect class.

David is saying right....

Ur program is not finding the class u r running

try using command java -classpath "path to ur class file" fileName

the problem is only of classpath

I didn't write any exception. That is the full source code I wrote. No compilation errors but when I try to run that program (ie. "java Connect" command)I get the above error.

Of course, how can the JVM knows where to find your class? Use the -classpath as we mentioned above.

It is working now . Thank you very much for your (both of you) help.

Hello again,
With reference to the above source code application fail (runtime) at
"Class.forName ("com.mysql.jdbc.Driver").newInstance();" line.
What is the posible failure?

Thanks in advance.

Indika

Possibly it is unable to find the class com.mysql.jdbc.Driver
Include your JAR to classpath.

I added class path as follows into system variable.
Variable name :CLASSPATH and
Variable value : "C:\Program Files\Java\jdk1.5.0\bin;E:\JavaApp\mysql-connector-java-3.1.10-bin.jar"

Please let me know whether this is correct.

Thanks.

Regards,
Indika

Your CLASSPATH settings looks good...

It should work, if driver jar is in your CLASSPATH...

May be one option , that u can unjar the driver jar

into ur current directory , from where u r running the

application.....

Originally posted by Indika Hewage:
[QB]I added class path as follows into system variable.
Variable name :CLASSPATH and
Variable value : "C:\Program Files\Java\jdk1.5.0\bin;E:\JavaApp\mysql-connector-java-3.1.10-bin.jar"

You need to add this jar files into the setDomainEnv.cmd( bea_home\weblogic\activerdomaindirecotory\setDomainEnv.cmd) to know the weblogic server, not sure your weblogic server is pickingup the env classpath

this should work if you put this jar file into the weblogic classpath

Thanks,
Santosh
[ September 19, 2005: Message edited by: Santosh Maskar ]