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!

Null Pointer Exception using JDBC-ODBC bridge on Linux

843854Aug 31 2004 — edited Sep 1 2004
Wonder if anyone can help me with this one?

I am attempting to use the JDBC-ODBC bridge on Fedora with J2SDK 1.4.2_04, however I am getting a NullPointerException whenever I get the connection. I can get the JDBC connection to work but it is a requirement that ODBC be used.

The code is as simple as it can get.
import java.sql.*;

public class TestClass
{
   public static void doConnection()
   {
      try
      {
           Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
           Connection cn = DriverManager.getConnection("jdbc:odbc:DB");
      }
      catch (Exception e)
      {
           e.printStackTrace();
      }
   }

   public static void main(String[] args)
   {
      doConnection();
   }
}
Running this program using java -verbose TestClass I get the following output.
....
[Loaded sun.jdbc.odbc.JdbcOdbc from /usr/java/j2sdk1.4.2_04/jre/lib/rt.jar]
[Loaded java.lang.UnsatisfiedLinkError from /usr/java/j2sdk1.4.2_04/jre/lib/rt.jar]
[Loaded java.sql.SQLException from /usr/java/j2sdk1.4.2_04/jre/lib/rt.jar]
[Loaded java.sql.SQLWarning from /usr/java/j2sdk1.4.2_04/jre/lib/rt.jar]
java.lang.NullPointerException
[Loaded java.lang.StackTraceElement from /usr/java/j2sdk1.4.2_04/jre/lib/rt.jar]
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)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at TestClass.doConnection(TestClass.java:13)
at TestClass.main(TestClass.java:96)
[Loaded java.lang.Shutdown from /usr/java/j2sdk1.4.2_04/jre/lib/rt.jar]
[Loaded java.lang.Shutdown$Lock from /usr/java/j2sdk1.4.2_04/jre/lib/rt.jar]

The UnsatisfiedLinkError suggests to me that a library cannot be found, but I don't know what library.

As far as I know I have configured ODBC correctly. I can achieve connectivity to my database using other tools and I still get this same error irrespective of whether the DSN is valid or not.

I have installed the unixODBC rpm.

Any help/insite would be greatly appreciated.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 29 2004
Added on Aug 31 2004
6 comments
2,903 views