Error connecting Java 8 with Access: No suitable driver found

Question

I want to connect Java 8 with Access but the following error occurs and I don't know how to fix it. I always get this error:

java.sql.SQLException: No suitable driver found for jdbc:ucanaccess://C:/Users/Ghazi/workspace/java w access/login.accdb

I added 4 libraries:

• hsqldb.jar
• jackcess-2.0.7.jar
• org.apache.commons.lang-2.6-source.jar
• org.apache.commons.loggin-1.1.1-source.jar

This is my code

import java.sql.*;
public class DbConnection {
    Connection con;
    Statement st;
    DbConnection(){
        dbconnect();
        }
    //-----------------------
    public void dbconnect(){
        try
        {
     Connection conn=DriverManager.getConnection("jdbc:ucanaccess://C:/Users/Ghazi/workspace/java w access/login.accdb");
      Statement stment = conn.createStatement();
        }
        catch(Exception err)
        {
            System.out.println(err);
        }
    }
    //--------------------------
        public static void main(String[]args){
            DbConnection ob=new DbConnection();
            }//end main
    }

Answer 1

Try adding "Class.forName():

   public void dbconnect(){
     try  {
        Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");
        Connection conn=DriverManager.getConnection("jdbc:ucanaccess://C:/Users/Ghazi/workspace/java w access/login.accdb");
        Statement stment = conn.createStatement();
     }
     catch(Exception err) {
       System.out.println(err);
     }
   }

The basic problem is that earlier versions of Java/JDBC used ODBC to connect to MS-Access ... and the ODBC driver has been removed from Java 8.

Two alternatives are to use:

1) UCanAccess: http://ucanaccess.sourceforge.net/site.html

... or ...

2) Jackcess (Jackcess 2.0: New crunchy outside, same yummy filling!): http://jackcess.sourceforge.net/

If that doesn't work:

3) Please specify what what IDE you're using (Eclipse, etc - if applicable)

4) Make sure your jackcess-2.0.7.jar is explicitly included in the CLASSPATH (how to do this depends on your IDE)

5) Consider using a directory without spaces in the name

Answer 2

I added 4 libraries

You need five (5) libraries. You forgot to add the "ucanaccess-x.y.z.jar" file itself.

For detailed instructions, see

Manipulating an Access database from Java without ODBC