CODEWITHSUNDEEP
javajdbc
Andrew
Andrew

Reputation: 6394

JDBC Driver Issue

I'm trying to get the JDBC to work on my Windows 7. I added it to the CLASSPATH ("G:/workspace/mysql-connector-java-5.1.18-bin.jar"). Restarted, because I thought this might be the problem. But the Class.forName("com.mysql.jdbc.Driver").newInstance() still is not working. It throws the following exception:

Exception in thread "main" 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 JDBCTest.main(JDBCTest.java:18)

And this is the code in my class: 

....  
private static Connection connect=null;
private static Statement statement=null;
private PreparedStatement preparedstament=null;
private static ResultSet resultset=null;

public static void main(String args[]) throws Exception
{

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

    connect=DriverManager.getConnection("jdbc:mysql://localhost/feedback?user=root&password=root");
    statement=connect.createStatement();

How am I supposed to solve this?

Upvotes: 1

Views: 3563

Answers (1)

Jon Skeet
Jon Skeet

Reputation: 1500525

I don't believe Eclipse will use the CLASSPATH environment variable when launching a Java application. You either need to add it to the build path for the project, or explicitly configure the launch configuration to include it. It's probably simpler to add it to the build path:

  • Right click on the project
  • Choose Build Path
  • Choose "Add External Archives"
  • Browse to the jar file

Upvotes: 2

Related Questions