Affects Version/s: 2.0.2, 2.1.3, 2.1.4
Fix Version/s: None
Security Level: public (Regular issues)
Red Hat Enterprise Linux Server v5.2
WAS-CE v220.127.116.11, based on Geronimo v2.0.2
I have frequent trouble with my database pool to an AS/400. The database is taken down every night for backup, and at least once a week the connection pool is unusable after the database comes back up. Restarting the connection pool makes everything work again.
We are new to Geronimo/WAS-CE – just this one app on one server – so I don't have anything to compare to. However, we have had this same issue with a couple 1.x/1.1.x versions before we upgraded to v2. Also, there are several WebSphere (full WAS, not WAS-CE) apps that do not have this trouble.
Driver: JTOpen v6.1 (com.ibm.as400.access.AS400JDBCDriver)
Pool Min Size: 0
Pool Max Size: 100
Blocking Timeout: 5000
Idle Timeout: 15