[DBCP-207] DBCP 1.2.1 incompatible with Informix (driver doesn't support setReadOnly(...))

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.2.1
• Fix Version/s: 1.3

Environment

using the pooling driver component with an informix driver

• Assignee: Dain Sundstrom
• Reporter: Kimberly Baer
• Created: 03/Jan/07 20:04
• Updated: 10/Feb/10 19:16
• Resolved: 23/Jul/07 20:03

Description

I recieved an error using commons-dbcp-1.2.1.jar and ifxjdbc.jar for my informix driver:

org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted
at org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:183)
at java.sql.DriverManager.getConnection(DriverManager.java:539)
at java.sql.DriverManager.getConnection(DriverManager.java:211)
at ConnectionPoolingTest.main(ConnectionPoolingTest.java:105)
Caused by: java.util.NoSuchElementException: Could not create a validated object, cause: Read only mode not supported
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:806)
at org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:175)

I will look into the comment provided by Dirk in bug ID DBCP-127 (version 1.1), but it appears this bug still has an impact in the 1.2.1 version. If anyone has any other suggestions, they would be greatly appreciated.