How to reliably connect to DB2 UDB 8.x using IBM's Type 4 Driver?
Does / will GlassFish support IBM's Type 4 driver? I have only seen Type 2 in the docs:
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:
The only other solution is to purchase a DB2 driver from DataDirect.