Unable to load JdbcOdbc library

From: SteveE (steveedw_at_yahoo.com)
Date: 10/11/04 

Date: 11 Oct 2004 08:55:40 -0700

I am trying to connect to an Informix database on a stand-alone
Solaris server. The database only exposes ODBC for external
connections, not JDBC.

On a PC I set up a system DSN for the database under ODBC, then using
JdbcOdbc bridge am able to successfully access the database
successfully.

On the Solaris side (where our code has to run from), we have the
Solaris OpenLink ODBC driver loaded. Using the odbctest program, we
are able to connect to the database successfully. However, when I try
to run our JAVA application and access via the JdbcOdbc bridge, a
NullPointerException is thrown, and I get the message "Unable to load
JdbcOdbc library".

My JDK version is j2se1.4.1.01.

--- code snip ---
        // Note that in real code, server, uid and pwd were provided
        String url =
"jdbc:odbc:cms;SERVER=<server>;UID=<userid>;PWD=<password>;";
        
        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            
            ((sun.jdbc.odbc.JdbcOdbcDriver)
DriverManager.getDriver("jdbc:odbc:cms")).setWriter(new
java.io.PrintWriter(System.err));
            //Class.forName("com.informix.jdbc.IfxDriver");
            Connection conn = DriverManager.getConnection(url);
            
--- end code snip ---

--- output ---
*Driver.connect (jdbc:odbc:cms;SERVER=<server>;UID=<userid>;PWD=<password>;)
JDBC to ODBC Bridge: Checking security
No SecurityManager present, assuming trusted application/applet
JDBC to ODBC Bridge 2.0001
Current Date/Time: Mon Oct 11 11:40:53 EDT 2004
Loading JdbcOdbc library
Unable to load JdbcOdbc library
Exception occurred
java.lang.NullPointerException
        at sun.jdbc.odbc.JdbcOdbcDriver.initialize(JdbcOdbcDriver.java:435)
        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 com.yd.test.TestOdbc.runTest(TestOdbc.java:37)
        at com.yd.test.TestOdbc.main(TestOdbc.java:23)
--- end output ---

Relevant Pages