[unixODBC-support] SUN's JDBC-ODBC Bridge and unixODBC

[Nick Gorham]

Andy Warner wrote:

> The error I am getting from a product called JAMWiki is below. I get 
> the same error when I used OpenOfice Base. The error does not change 
> if the DSN is valid or not. No log files are being created, which 
> leads me to believe that libodbc.so is not being invoked (I have 
> logging/tracing enabled for unixODBC and the driver).
>
> 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:582)
>        at java.sql.DriverManager.getConnection(DriverManager.java:185)
>        at 
> org.jamwiki.db.DatabaseConnection.getTestConnection(DatabaseConnection.java:323) 
>
>
> You mentioned that you thought it was "just a case of making sure the 
> JVM could load libodbc.so" Is there anything that must be done to 
> allow a JVM to access a library such as this? I just assumed that 
> having the library in a well known place (/usr/lib) and having it 
> world readable/executable is enough. I am not very familiar with java, 
> are you aware of anything like an env variable that must be set?
>
> Thanks for any help,
>
I would check that the jvm and your libodbc are both the same bit length 
(32/64). Also possibly try using strace to see what libs java is trying 
to load, and from where.

-- 
Nick