Return-Path: Delivered-To: apmail-jakarta-commons-user-archive@www.apache.org Received: (qmail 91758 invoked from network); 24 Feb 2004 13:23:30 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 24 Feb 2004 13:23:30 -0000 Received: (qmail 13039 invoked by uid 500); 24 Feb 2004 13:23:23 -0000 Delivered-To: apmail-jakarta-commons-user-archive@jakarta.apache.org Received: (qmail 12812 invoked by uid 500); 24 Feb 2004 13:23:21 -0000 Mailing-List: contact commons-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Jakarta Commons Users List" Reply-To: "Jakarta Commons Users List" Delivered-To: mailing list commons-user@jakarta.apache.org Received: (qmail 12732 invoked from network); 24 Feb 2004 13:23:13 -0000 Received: from unknown (HELO mail.cabsonline.co.zw) (217.15.122.5) by daedalus.apache.org with SMTP; 24 Feb 2004 13:23:13 -0000 Received: from cabs.co.zw ([196.44.188.5] helo=notes.cabs.co.zw) by mail.cabsonline.co.zw with esmtp (Exim 4.30) id 1AvcWL-0006cW-Fl for commons-user@jakarta.apache.org; Tue, 24 Feb 2004 15:22:45 +0200 To: commons-user@jakarta.apache.org Subject: [DBCP] - Informix and DBCP 1.1 compatibility... MIME-Version: 1.0 X-Mailer: Lotus Notes Release 6.5 September 26, 2003 Message-ID: From: AndrewPeirson@cabs.co.zw Date: Tue, 24 Feb 2004 15:18:49 +0200 X-MIMETrack: Serialize by Router on Notes/CABS(Release 6.5|September 26, 2003) at 24/02/2004 03:18:50 PM, Serialize complete at 24/02/2004 03:18:50 PM Content-Type: multipart/alternative; boundary="=_alternative 0049226542256E44_=" X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N --=_alternative 0049226542256E44_= Content-Type: text/plain; charset="US-ASCII" 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. --=_alternative 0049226542256E44_=--