File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Access DB Connect Issues

 
Bill Warner
Greenhorn
Posts: 3
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The following code:

public Connection getConnection(){
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String filename = "c:/IssuanceTracker/IssuanceTracker.mdb";
String database = "jdbcdbcriver={Microsoft Access Driver (*.mdb)};DBQ=";database+= filename.trim();
System.out.println(database);
Connection con = DriverManager.getConnection( database ,"","");
return con;
}
catch (Exception e) {
System.out.println("Error: " + e);
e.printStackTrace();
return null;
}
}

Yields the following error:

java.lang.NullPointerException
at sun.jdbc.odbc.JdbcOdbcDriver.initialize(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:538)
at java.sql.DriverManager.getConnection(DriverManager.java:188)
at issuancetracker.DataAccess.getConnection(DataAccess.java:27)
at issuancetracker.testmain.main(testmain.java:21)

I've included the rt.jar file in my project. I'm using WSAD 5.1.2. Can anyone please help. Thanks, Bill
 
Muhammad Saifuddin
Ranch Hand
Posts: 1324
Android Java Windows
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

String database = "jdbcdbcriver={Microsoft Access Driver (*.mdb)};DBQ=";database+= filename.trim();


try this

String url ="jdbcdbcRIVER={Microsoft Access Driver
(*.mdb)};DBQ= c:\\IssuanceTracker\\IssuanceTracker.mdb";

[ August 31, 2006: Message edited by: Saif Uddin ]
 
Bill Warner
Greenhorn
Posts: 3
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for the replies! I get the same errors with the suggested changes.

I could really use some help. I'm new to Java and this problem doesn't seem to make sense. Co-workers can execute the same code successfully w/o error. Any help would be appreciated.
 
Ulf Dittmer
Rancher
Pie
Posts: 42966
73
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Instead of accessing the MDB file directly, have you tried setting up an ODBC data source? Some info about that can be found here.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic