ClassNotFound Exception for jdbc "uncanaccess" path setting for MS Access

Asked Nov 27 '14 at 20:51

Active Nov 27 '14 at 22:36

Viewed 30 times

I am writing a very simple code to connect MS Access database to my java program using netBeans. The driver ucanaccess and MS access file is placed in the very same folder. Kindly guide me through it.

 public static void main(String[] args) {
    // TODO code application logic here
    Connection c = null;
    Statement s = null;
    ResultSet rs = null;
    try{
         Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");
    c = DriverManager.getConnection("jdbc:ucanaccess://First1.accdb");
    s = c.createStatement();
    s.executeUpdate("insert into std values(5, 'junaid')");
    //set classpath=.c:./*;
    }catch(Exception e)
    {
        System.out.println(e);
    }

}

edited Nov 27 '14 at 22:36

Gord Thompson

98,607
26
164
342

asked Nov 27 '14 at 20:51

Saim Mehmood

The name of the driver, according to the documentation, is `net.ucanaccess.jdbc.UcanaccessDriver`. With a capital U. – RealSkeptic Nov 27 '14 at 20:57
Yes I have corrected it to capital 'U', still facing the same error. @RealSkeptic – Saim Mehmood Nov 27 '14 at 20:58
The documentation also says you have to give full path of the file, including drive letter. – RealSkeptic Nov 27 '14 at 21:02
Okay now I have given the full path, still the same error. – Saim Mehmood Nov 27 '14 at 21:06
Edit your question and show your updated code. – RealSkeptic Nov 27 '14 at 21:16
1

Have you added the JAR files for UCanAccess *and its dependencies* (HSQLDB, Jackcess, etc.) as "Libraries" in your NetBeans project? For details, look [here](http://stackoverflow.com/a/21955257/2144390). – Gord Thompson Nov 27 '14 at 21:32
Bundle of thanks @Gord Thompson. I have found the answer I was looking for. :) – Saim Mehmood Nov 28 '14 at 17:21

ClassNotFound Exception for jdbc "uncanaccess" path setting for MS Access

0 Answers0