Cannot connect to access database from jar file

Question

I cannot connect to my access database using jdbc:ucanaccess driver. Here the code:

public void open_conn()
{
    try
    {
        Class.forName("net.ucanaccess.jdbc.UcanaccessDriver"); 
        String url = "jdbc:ucanaccess://C:\\AnalysisLab\\dbanal.accdb";
        conn = DriverManager.getConnection(url, "username", "password");
        stmt = conn.createStatement();
    }
    catch (Exception e)
    {
        JOptionPane.showMessageDialog(null,"Error: "+e.getLocalizedMessage()); e.printStackTrace();
    }
}

The error reported : "Error: net.ucanaccess.jdbc.UcanaccessDriver" I tried including org-netbeans-modules-db-mysql.jar file in the jar directory, but it doesn't work.

Answer 1

This documentation says that your URL should be in the following format:

Connection conn=DriverManager.getConnection("jdbc:ucanaccess://",user, password);

// for example: Connection conn=DriverManager.getConnection("jdbc:ucanaccess://c:/pippo.mdb");

So your URL is going to change to:

String url = "jdbc:ucanaccess://C:\\AnalysisLab\\dbanal.accdb";

And add the following jar files to your CLASSPATH as all of these are needed by the actual JDBC driver itself:

• ucanaccess-3.0.3.jar
• commons-lang-2.6.jar
• commons-logging-1.1.1.jar
• hsqldb.jar
• jackcess-2.1.3.jar

As per your question, I assume that you are on Netbeans and hence you need to all these 5 jars there in the following manner:

Expand the tree view for your project, right-click the "Libraries" folder and choose "Add JAR/Folder...", then browse to the JAR file.

A very detailed explanation of a similar question can be found here.