Mailing-List: contact commons-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Jakarta Commons Users List" <commons-user@jakarta.apache.org>
Received-SPF: neutral (asf.osuosl.org: 66.150.58.18 is neither permitted nor
 denied by domain of thomas.fischer@movielink.com)
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01C57E8A.E8F4F0D4"
Subject: [dbcp] ValidationQuery doesn't seem to be executed
Date: Fri, 1 Jul 2005 15:19:11 -0700
Message-ID: <EFCCA10CCC1FD3409707638DB9974DDC43F8CD@mimas.digitaldist.net>
Thread-Topic: [dbcp] ValidationQuery doesn't seem to be executed
Thread-Index: AcV+iuhAqgL5JpwTSva033S/mk9i7w==
From: "Thomas Fischer" <Thomas.Fischer@movielink.com>
To: <commons-user@jakarta.apache.org>

------_=_NextPart_001_01C57E8A.E8F4F0D4
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi,
I had some suspicions, if dbcp is executing the validation query. So, I
created an Oracle sequence, and had the validation query increment it.
The sequence is not getting incremented. It's probably a configuration
mistake on my part. Please, take a look at my code:

	// set up dbcp
            BasicDataSource ds =3D new BasicDataSource();
            ds.setDriverClassName("oracle.jdbc.driver.OracleDriver");
            ds.setUsername("bla");
            ds.setPassword("bla");
            ds.setUrl("jdbc:oracle:thin:@bla:1521:bla");
            ds.setMaxActive(20);
            ds.setMaxIdle(20);
            ds.setTestOnBorrow(true);
            ds.setTestOnReturn(true);
            ds.setTestWhileIdle(true);
            ds.setValidationQuery("select tf_dbcp_test.nextval from
dual");

	// get connection and return it to simulate some usage
            PreparedStatement stmt =3D conn.prepareStatement("select *
from bla");
            ResultSet result =3D stmt.executeQuery();
            result.next();
            System.out.println("fly product is " + result.getString(1));
            conn.commit();
            result.close();
            stmt.close();
            conn.close();

	// get another connection
            conn =3D ds.getConnection();
            conn.close();


I'd expect that dbcp would execute the validation query four times (2 *
on borrow and 2 * on return). Though, the sequence has not been
incremented.

Any tips?


Thanks,
Thomas

------_=_NextPart_001_01C57E8A.E8F4F0D4--