Author: dirkv Date: Fri Feb 25 10:20:49 2005 New Revision: 155354 URL: http://svn.apache.org/viewcvs?view=rev&rev=155354 Log: Extra testcase for prepared statement pooling using manually constructed pool
Added: jakarta/commons/proper/dbcp/trunk/src/test/org/apache/commons/dbcp/TestPStmtPooling.java (with props) Added: jakarta/commons/proper/dbcp/trunk/src/test/org/apache/commons/dbcp/TestPStmtPooling.java URL: http://svn.apache.org/viewcvs/jakarta/commons/proper/dbcp/trunk/src/test/org/apache/commons/dbcp/TestPStmtPooling.java?view=auto&rev=155354 ============================================================================== --- jakarta/commons/proper/dbcp/trunk/src/test/org/apache/commons/dbcp/TestPStmtPooling.java (added) +++ jakarta/commons/proper/dbcp/trunk/src/test/org/apache/commons/dbcp/TestPStmtPooling.java Fri Feb 25 10:20:49 2005 @@ -0,0 +1,71 @@ +/* + * Copyright 1999-2004 The Apache Software Foundation. + * + * Licensed under the Apache License, Version 2.0 (the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + */ + +package org.apache.commons.dbcp; + +import java.sql.Connection; +import java.sql.Statement; + +import javax.sql.DataSource; + +import junit.framework.Test; +import junit.framework.TestCase; +import junit.framework.TestSuite; + +import org.apache.commons.pool.KeyedObjectPoolFactory; +import org.apache.commons.pool.ObjectPool; +import org.apache.commons.pool.impl.GenericKeyedObjectPoolFactory; +import org.apache.commons.pool.impl.GenericObjectPool; + +/** + * TestSuite for BasicDataSource with prepared statement pooling enabled + * + * @author Dirk Verbeeck + * @version $Revision$ $Date$ + */ +public class TestPStmtPooling extends TestCase { + public TestPStmtPooling(String testName) { + super(testName); + } + + public static Test suite() { + return new TestSuite(TestPStmtPooling.class); + } + + public void testStmtPool() throws Exception { + new TesterDriver(); + ConnectionFactory connFactory = new DriverManagerConnectionFactory( + "jdbc:apache:commons:testdriver","u1","p1"); + + ObjectPool connPool = new GenericObjectPool(); + KeyedObjectPoolFactory stmtPoolFactory = new GenericKeyedObjectPoolFactory(null); + + PoolableConnectionFactory x = new PoolableConnectionFactory( + connFactory, connPool, stmtPoolFactory, + null, false, true); + + DataSource ds = new PoolingDataSource(connPool); + + Connection conn = ds.getConnection(); + Statement stmt1 = conn.prepareStatement("select 1 from dual"); + Statement ustmt1 = ((DelegatingStatement) stmt1).getInnermostDelegate(); + stmt1.close(); + Statement stmt2 = conn.prepareStatement("select 1 from dual"); + Statement ustmt2 = ((DelegatingStatement) stmt2).getInnermostDelegate(); + stmt2.close(); + assertSame(ustmt1, ustmt2); + } +} Propchange: jakarta/commons/proper/dbcp/trunk/src/test/org/apache/commons/dbcp/TestPStmtPooling.java ------------------------------------------------------------------------------ svn:eol-style = native Propchange: jakarta/commons/proper/dbcp/trunk/src/test/org/apache/commons/dbcp/TestPStmtPooling.java ------------------------------------------------------------------------------ --- svn:keywords (added) +++ svn:keywords Fri Feb 25 10:20:49 2005 @@ -0,0 +1 @@ +LastChangedDate Date LastChangedRevision Revision Rev LastChangedBy Author HeadURL URL Id Propchange: jakarta/commons/proper/dbcp/trunk/src/test/org/apache/commons/dbcp/TestPStmtPooling.java ------------------------------------------------------------------------------ svn:mime-type = text/plain --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]