Problem of accesing MS Acess database on Linux using Java
843854Jan 13 2004 — edited Jan 15 2004Below 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)