Is is possible you try a nightly build of DBCP and pool. The latest versions have more error logging.
DBCP 1.1 is more strict about setAutoCommit and setReadOnly. There was one report about a database driver not supporting those methods.
It would be very helpfull if you could do a test and send in the error details.
-- Dirk
[EMAIL PROTECTED] wrote:
Hi All,
I have been trying to get the ManualPoolingDataSourceExample.java working with an Informix database. Initially I was using DBCP 1.1 and Pool 1.1 from the commons section and the source compiles fine. However, when I try run the example, I get the following exception:
Creating connection.
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted, cause:
java.util.NoSuchElementException: Could not create a validated object
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:851)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:140)
at ManualPoolingDataSourceExample.main(ManualPoolingDataSourceExample.java:169)
I know that my connect URL is correct as I have been using it to establish connections to my database for some time now and have had no problems. I tried changing the datasource default settings, hoping to get rid of this exception, but nothing works. In the end, I downloaded DBCP 1.0 and that fixed everything....! Why, I don't know...
My question is two fold... Firstly, is there any way of getting DBCP 1.1 to talk nicely to Informix or do I have to use the older version and secondly, if I have to use the older version, what issues do I have to watch out for that have been improved or fixed in version 1.1, that may cause problems in using DBCP 1.0?
Thanks for your help and suggestions,
Andrew Peirson.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
