We are trying to use GlassFish for several large projects(ranging
from 3,000 users to > 200,000) and one database we have to connect to
is DB2 8.2. The URL:
https://glassfish.dev.java.net/quality/
matrix.html says this has been tested but there is no documentation
for configuring a Type 4 JDBC driver for DB2 only a Type 2 driver
which we don't use. We are experiencing several issues with
connection pooling configuration and usage ranging from timeouts on
connections where there should be none to not being able to get a new
connection after a period of time. One killer is that we cannot
connect to a database that we only have access to stored procedures,
we cannot configure it to validate on "table" as we have no access to
tables. All the other validation methods lead to a myriad TCP/IP
disconnect errors.
We filed a bug to document some of what we are experiencing: https://
glassfish.dev.java.net/issues/show_bug.cgi?submit=Go+to&id=1377 . Is
the DB2 JDBC Type 4 driver supported for connection pooling or will
it be supported? We are hoping it is a configuration issue, but
can't get confirmation on that either. We have not had this issue on
the other application servers with the IBM DB2 driver, so we were
assuming either a bug or a miss-configuration. We'd be willing to
help in anyway needed.
Thanks,
Iran.