Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem of accesing MS Acess database on Linux using Java

843854Jan 13 2004 — edited Jan 15 2004
Below is my java code and errors found. Can anyone guide me tell me what is the problem and how to success access the .mdb file using Java on Linux?

import java.sql.*;

class readmdb
{ public static void main(String[] args)
{ String url;

Connection con;
Statement stmt;

try
{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}

catch(java.lang.ClassNotFoundException e)
{ System.out.print("ClassNotFoundException: ");
System.out.println(e.getMessage());
}

try
{ con = DriverManager.getConnection("jdbc:odbc:DRIVER={/usr/local/lib/libmdbodbc.o.O}};DBQ=/home/powerstation/db/Database.mdb");

stmt = con.createStatement();

stmt.close();

con.close();
}

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

}

}

}

---------------------------------------------------------------------------------------------------
Errors messages found after i executed the java code
shown above on linux platform.
---------------------------------------------------------------------------------------------------
Exception in thread "main"
java.lang.NullPointerException
at sun.jdbc.odbc.JdbcOdbcDriver.initialize(JdbcOdbcDriver.java:436)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:153)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
atjava.sql.DriverManager.getConnection(DriverManager.java:193)
at readmdb.main(readmdb.java:27)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 12 2004
Added on Jan 13 2004
8 comments
101 views