Skip to main content

How to reliably connect to DB2 UDB 8.x using IBM's Type 4 Driver?

No replies
byteme
Offline
Joined: 2005-07-09

Does / will GlassFish support IBM's Type 4 driver? I have only seen Type 2 in the docs:

http://docs.sun.com/app/docs/doc/819-3658/6n5s5nklk?a=view#beamy

I am trying to setup a connection pool using any of the Type 4 drivers that ship with DB2 8.2: com.ibm.db2.jcc.XXXX. I have only been able to get something working (no matter what vaules for the other configuration parameters) when I force Connection Validation to use a table in the configuration. This will not work in environments where the user id only accesses stored procedures for instance. Has anyone come across this or found a working configuration? I have filed a bug at:

https://glassfish.dev.java.net/issues/show_bug.cgi?id=1377

The only other solution is to purchase a DB2 driver from DataDirect.