Wednesday, September 20, 2006

DB2 UDB 7.1, JDBC, and NULLID.SYSSH200

This is an obscure problem which took a lot of digging. It was finally Roger Bjärevall's post here that lead to the answer. Roger is the developer of Minq Software's DB-Visualizer which is a great utility for connecting to a variety of databases as I often do.

The bottom line is you can't use Type 4 drivers to connect to DB2 7.1 so this one won't work. You have to configure the connection using the one installed with DB2 (\SQLLIB\java\db2java.zip). I got that far pretty easily. However, you need to specify the 'com.ibm.db2.jdbc.net.DB2driver' for the connection which isn't the first in the list of drivers. It was Roger's casual post that made it come together and finally work! Thanks for the tip and the great little product that's reasonably priced (remember when TOAD was cheap before Quest jacked the price up through the roof??).

Original post

No comments:

Post a Comment