0

I am using Eclipse, java8

I am trying to connect access database with eclipse but it is not working.

I first created data source in "ODBC Data Source Administrator(32-bits)" for windows
and than I added the jar file (mysql-connector-java-5.1.35-bin)

But I am getting an error:

ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver
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 ex01.main(ex01.java:34)
SQLException: No suitable driver found for jdbc:odbc:J2EE_Database







    public class ex01 {
        public static void main(String[] args) {
            String url = "jdbc:odbc:J2EE_Database";

            Connection con;

            Statement stmt;

            String query = "Select * from user";

            try {
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            } catch (java.lang.ClassNotFoundException e) {
                System.err.print("ClassNotFoundException: ");
                System.err.println(e.getMessage());
                e.printStackTrace();
            }

             try
              {
               con = DriverManager.getConnection(url, "", "");

               stmt = con.createStatement();

               // Returns a ResultSet that contains the data produced by the query; never null
               ResultSet rs = stmt.executeQuery(query);


               System.out.println("Course Data:");
               System.out.println("CoursetTitletCredits");

               while (rs.next())
               {
                String course = rs.getString("COURSE");
                String description = rs.getString("DESCRIPTION");
                int credits = rs.getInt("CREDITS");
                System.out.println(course + "t" + description + "t" + credits);
               }

               stmt.close();

               con.close();
              } 
              catch(SQLException ex) 
              {
               System.err.println("SQLException: " + ex.getMessage());
              }
        }
    }

Edited by hwoarang69

2
Contributors
2
Replies
19
Views
1 Year
Discussion Span
Last Post by hwoarang69
1

The JDBC-ODBC Bridge has been removed from Java 8, so you won't be able to directly use it any longer.

Maybe this SO Thread on the matter can help you continue your work.

0

I did downlload and added the following JAR files in my projects:
UCanAccess (ucanaccess-2.x.x.jar)
Jackcess (jackcess-2.x.x.jar)

But for some reason when I download the below 3 files. It download as a src folder:
HSQLDB (hsqldb.jar, version 2.2.5 or newer)
commons-lang (commons-lang-2.4.jar, or newer)
commons-logging (commons-logging-1.0.4.jar, or newer)

Do you how may I change it jar files?

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.