Need some advice on exception seen with

Exploring 搒un.jdbc.odbc.JdbcOdbcDriver?bridge to determine if would fit a special task. Implementation will be on a Nonstop Tandem OSS environment. The URL and UserID and Password function to access a stored procedure from an SQLapp to the Tandem works. I tried de-compiling code to see if I could identify the missing method, tried hunting down any reference to the allocEnv method, but either I抳e spent too much time looking at the same problem or it is something very simple and just need some direction.

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

String Tan01URL ="jdbc:odbc://tan01:port ";

java.util.Properties prop =new java.util.Properties();

prop.put("username","UserID");

prop.put("password","Password");

String stmt ="{call get_actions (?, ?, ?, ?, ?, ?, ?)}";

// Connect to the database

Connection conn = DriverManager.getConnection(Tan01URL, prop);

[b]Throwsthis exception each time.[/b]

Exception in thread"main" java.lang.UnsatisfiedLinkError: allocEnv

at sun.jdbc.odbc.JdbcOdbc.allocEnv(Native Method)

at sun.jdbc.odbc.JdbcOdbc.SQLAllocEnv(JdbcOdbc.java:142)

at sun.jdbc.odbc.JdbcOdbcDriver.initialize(JdbcOdbcDriver.java:451)

at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:153)

at java.sql.DriverManager.getConnection(DriverManager.java:512)

at java.sql.DriverManager.getConnection(DriverManager.java:140)

at blendOdbc.main(blendOdbc.java:48)

Ideas?

Thanks

[1815 byte] By [IllusionBluea] at [2007-10-2 5:52:55]
# 1
sounds like the driver's missing some DLL files.
bsampieria at 2007-7-16 2:02:29 > top of Java-index,Java Essentials,Java Programming...
# 2

The JDBC/ODBC bridge is not the best and most actively maintained piece of software in the world. Try not to use it if you have alternatives.

In Windows JDK there is JdbcOdbc.dll which contains allocEnv() and the rest of the JDBC/ODBC glue written in C. You are running the Java program on Tandem or is that the server? Does its JDK have JdbcOdbc.so or however dynamically loadable libraries are named there?

sjasjaa at 2007-7-16 2:02:29 > top of Java-index,Java Essentials,Java Programming...
# 3
Thanks, Am checking to see if the Tandem OSS environment still needs some files before jdbc:odbc bridge can be used.Ernie
IllusionBluea at 2007-7-16 2:02:29 > top of Java-index,Java Essentials,Java Programming...