Msaccess connectivity with java

Question

Iam trying to connect java with ms-access i get following errors

java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver
    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 msaccesssample.sample.main(sample.java:11)

Here is my java code

package msaccesssample;
import java.sql.*;
public class sample {


    public static void main(String[] args)
    {
        try
        {

              Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
              Connection con = DriverManager.getConnection("jdbc:odbc:satish");
              Statement st = con.createStatement();
              ResultSet rs=st.executeQuery("select * from sample");

        }
        catch(Exception e)
        {
            e.printStackTrace();


        }

    }

}

Actually i created satish as DSN and added database name as test.accdb.the problem is already asked many times in forum but i dont know whelther its a driver problem or programming problem.my system is 64 bit with windows 8 and my odbc is 32 bit.I couldn't get the ms access drivers in 64 bit.Is there any way to load ms access drivers in 64 bit??????

possible duplicate of [JDBC ODBC Driver Connection](http://stackoverflow.com/questions/19709843/jdbc-odbc-driver-connection) — AlexGreg, Aug 12 '14 at 10:22
I have not tried recently, but in the past you could not connect to MsAccess in 64 bit java using the JDBC-ODBC bridge. See http://stackoverflow.com/questions/10289655/how-to-connect-to-a-32-bit-access-database-from-64-bit-jvm/10290227#10290227. This would not cause this error, but even if you solve this issue it still probably will not work — Bruce Martin, Sep 09 '14 at 02:03

Sairam Krish · Accepted Answer · 2014-08-12T10:34:03.333

0

You are using a JDBC ODBC Bridge driver which is part of the Java Runtime. Can you try this simple test, to do a sanity, taken from reference:

import java.sql.*;
public class LoadJdbcOdbcDriver {
  public static void main(String [] args) {
    Connection con = null;
    try {

// Load the JDBC-ODBC bridge driver
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;
      System.out.println("JDBC-ODBC driver loaded ok.");

    } catch (Exception e) {
      System.err.println("Exception: "+e.getMessage());
    }
  }
}

This should give you output:

C:\>javac LoadJdbcOdbcDriver.java

C:\>java LoadJdbcOdbcDriver
JDBC-ODBC driver loaded ok.

If you again get ClassNotFound, that means, rt.jar is not present in your path. Check your JAVA_HOME and PATH, check rt.jar is available.

edited Aug 12 '14 at 10:34

answered Aug 12 '14 at 10:28

Sairam Krish

10,158
3
55
67

rt.jar is present in my path – user3808015 Aug 12 '14 at 10:38
did you get the above output ? If you didn't, can you tell us your JAVA_HOME and PATH content – Sairam Krish Aug 12 '14 at 10:39
No i didnt get the output but my system is 64 bit with windows 8 and my odbc is 32 bit.I couldn't get the ms access drivers in 64 bit.Is there any way to load ms access drivers in 64 bit?????? – user3808015 Aug 12 '14 at 10:52

Msaccess connectivity with java

1 Answers1