java mysql connection

[korkor]

hello all,

i am trying to connect a java application to a mysql database. But when i run the application, i get this error: com.mysql.jdbc.Driver. What am i doing wrong?

this is my code

Class.forName("com.mysql.jdbc.Driver").newInstance ();


con = DriverManager.getConnection("jdbc:mysql://localhost:8080//test","root", "password");
stat = con.createStatement();

korkor

[sicarie]

hello all,

i am trying to connect a java application to a mysql database. But when i run the application, i get this error: com.mysql.jdbc.Driver. What am i doing wrong?

this is my code

Class.forName("com.mysql.jdbc.Driver").newInstance ();


con = DriverManager.getConnection("jdbc:mysql://localhost:8080//test","root", "password");
stat = con.createStatement();

korkor

Did you add it to your classpath, or associate it as a library with the project?

[ak1dnar]

Hi sicarie,
If i am using a remote web server located at http://www.companyname.com, how can i use his kind of drivers.

[korkor]

Did you add it to your classpath, or associate it as a library with the project?

is this the way to add to the class path?

Class c = Class.forNames("com.mysql.jdbc.Driver");

korkor

[sicarie]

Hi sicarie,
If i am using a remote web server located at http://www.companyname.com, how can i use his kind of drivers.

ajaxrand-

It's considered bad form to "hijack" some else's thread (ask your question in their thread. Please start your own thread for this question.

[sicarie]

is this the way to add to the class path?

Class c = Class.forNames("com.mysql.jdbc.Driver");

korkor

No, classpath is dependent on computer - are you on Windows or Linux?

[korkor]

[quote=sicarie]No, classpath is dependent on computer - are you on Windows or Linux?[/QUOTE

im on windows

korkor

[ak1dnar]

what is the driver you are using in your machine to connect with MySQL ?

[sicarie]

korkor-

From the Start Menu, go to Settings and click on 'Control Panel'. Then go to the System icon (in classic view, I'm not sure if this is in category view or not), and the 'Advanced' tab from there. In the Advanced tab, click on the Environmental Variables button. This will display your path (it's in the bottom box, you might have to scroll down for it). You only want to add to this (not delete anything that is not there. Highlight the Path and click the edit button, and then add the absolute location of your driver. Make sure this location is separated from the entries before and after it with a semi-colon and no spaces.

For instance, this is mine:
%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\Sy stem32\Wbem

and I would change this to:
%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\Sy stem32\Wbem;C:\Windows\drivers\jdbc\com.mysql.jdbc .Driver.jar;

An easier option (and one that's more portable), is to (depending on your IDE) add it as a library - in NetBeans, you just right-click on Library, add jar, and find the file.