/**
*
* Licensed to the Apache Software Foundation (ASF) under one or more
* contributor license agreements. See the NOTICE file distributed with
* this work for additional information regarding copyright ownership.
* The ASF licenses this file to You 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.dbcp2.managed;
import junit.framework.Test;
import junit.framework.TestSuite;
import org.apache.commons.dbcp2.ConnectionFactory;
import org.apache.commons.dbcp2.DelegatingConnection;
import org.apache.commons.dbcp2.DriverConnectionFactory;
import org.apache.commons.dbcp2.PoolableConnection;
import org.apache.commons.dbcp2.PoolableConnectionFactory;
import org.apache.commons.dbcp2.PoolingDataSource;
import org.apache.commons.dbcp2.TestConnectionPool;
import org.apache.commons.dbcp2.TesterDriver;
import org.apache.commons.pool2.impl.GenericObjectPool;
import org.apache.geronimo.transaction.manager.TransactionManagerImpl;
import org.junit.Assert;
import javax.transaction.TransactionManager;
import java.sql.Connection;
import java.util.Properties;
/**
* TestSuite for ManagedDataSource without a transaction in progress.
*
* @author Dain Sundstrom
* @version $Revision$
*/
public class TestManagedDataSource extends TestConnectionPool {
public TestManagedDataSource(String testName) {
super(testName);
}
public static Test suite() {
return new TestSuite(TestManagedDataSource.class);
}
@Override
protected Connection getConnection() throws Exception {
return ds.getConnection();
}
protected PoolingDataSource<PoolableConnection> ds = null;
private GenericObjectPool<PoolableConnection> pool = null;
protected TransactionManager transactionManager;
@Override
public void setUp() throws Exception {
super.setUp();
// create a GeronimoTransactionManager for testing
transactionManager = new TransactionManagerImpl();
// create a driver connection factory
Properties properties = new Properties();
properties.setProperty("user", "username");
properties.setProperty("password", "password");
ConnectionFactory connectionFactory = new DriverConnectionFactory(new TesterDriver(), "jdbc:apache:commons:testdriver", properties);
// wrap it with a LocalXAConnectionFactory
XAConnectionFactory xaConnectionFactory = new LocalXAConnectionFactory(transactionManager, connectionFactory);
// create the pool object factory
PoolableConnectionFactory factory =
new PoolableConnectionFactory(xaConnectionFactory, null);
factory.setValidationQuery("SELECT DUMMY FROM DUAL");
factory.setDefaultReadOnly(Boolean.TRUE);
factory.setDefaultAutoCommit(Boolean.TRUE);
// create the pool
pool = new GenericObjectPool<>(factory);
factory.setPool(pool);
pool.setMaxTotal(getMaxTotal());
pool.setMaxWaitMillis(getMaxWaitMillis());
// finally create the datasource
ds = new ManagedDataSource<>(pool, xaConnectionFactory.getTransactionRegistry());
ds.setAccessToUnderlyingConnectionAllowed(true);
}
@Override
public void tearDown() throws Exception {
pool.close();
super.tearDown();
}
/**
* Verify the accessToUnderlyingConnectionAllowed propertly limits access to the physical connection.
*/
public void testAccessToUnderlyingConnectionAllowed() throws Exception {
ds.setAccessToUnderlyingConnectionAllowed(true);
ManagedConnection<?> connection = (ManagedConnection<?>) newConnection();
assertTrue(connection.isAccessToUnderlyingConnectionAllowed());
assertNotNull(connection.getDelegate());
assertNotNull(connection.getInnermostDelegate());
connection.close();
ds.setAccessToUnderlyingConnectionAllowed(false);
connection = (ManagedConnection<?>) newConnection();
assertFalse(connection.isAccessToUnderlyingConnectionAllowed());
assertNull(connection.getDelegate());
assertNull(connection.getInnermostDelegate());
connection.close();
}
/**
* Verify that conection sharing is working (or not working) as expected.
*/
public void testSharedConnection() throws Exception {
DelegatingConnection<?> connectionA = (DelegatingConnection<?>) newConnection();
DelegatingConnection<?> connectionB = (DelegatingConnection<?>) newConnection();
assertFalse(connectionA.equals(connectionB));
assertFalse(connectionB.equals(connectionA));
assertFalse(connectionA.innermostDelegateEquals(connectionB.getInnermostDelegate()));
assertFalse(connectionB.innermostDelegateEquals(connectionA.getInnermostDelegate()));
connectionA.close();
connectionB.close();
}
public void testManagedConnectionEqualsSameDelegateNoUnderlyingAccess() throws Exception {
// Get a maximal set of connections from the pool
Connection[] c = new Connection[getMaxTotal()];
for (int i = 0; i < c.length; i++) {
c[i] = newConnection();
}
// Close the delegate of one wrapper in the pool
((DelegatingConnection<?>) c[0]).getDelegate().close();
// Disable access for the new connection
ds.setAccessToUnderlyingConnectionAllowed(false);
// Grab a new connection - should get c[0]'s closed connection
// so should be delegate-equivalent
Connection con = newConnection();
Assert.assertNotEquals(c[0], con);
Assert.assertEquals(
((DelegatingConnection<?>) c[0]).getInnermostDelegateInternal(),
((DelegatingConnection<?>) con).getInnermostDelegateInternal());
for (Connection element : c) {
element.close();
}
ds.setAccessToUnderlyingConnectionAllowed(true);
}
public void testManagedConnectionEqualsSameDelegate() throws Exception {
// Get a maximal set of connections from the pool
Connection[] c = new Connection[getMaxTotal()];
for (int i = 0; i < c.length; i++) {
c[i] = newConnection();
}
// Close the delegate of one wrapper in the pool
((DelegatingConnection<?>) c[0]).getDelegate().close();
// Grab a new connection - should get c[0]'s closed connection
// so should be delegate-equivalent
Connection con = newConnection();
Assert.assertNotEquals(c[0], con);
Assert.assertEquals(
((DelegatingConnection<?>) c[0]).getInnermostDelegateInternal(),
((DelegatingConnection<?>) con).getInnermostDelegateInternal());
for (Connection element : c) {
element.close();
}
}
/*
* JIRA: DBCP-198
*/
public void testManagedConnectionEqualsReflexive() throws Exception {
Connection con = ds.getConnection();
Connection con2 = con;
assertTrue(con2.equals(con));
assertTrue(con.equals(con2));
con.close();
}
public void testManagedConnectionEqualsFail() throws Exception {
Connection con1 = ds.getConnection();
Connection con2 = ds.getConnection();
assertFalse(con1.equals(con2));
con1.close();
con2.close();
}
public void testManagedConnectionEqualsNull() throws Exception {
Connection con1 = ds.getConnection();
Connection con2 = null;
assertFalse(con1.equals(con2));
con1.close();
}
public void testManagedConnectionEqualsType() throws Exception {
Connection con1 = ds.getConnection();
Integer con2 = Integer.valueOf(0);
assertFalse(con1.equals(con2));
con1.close();
}
public void testManagedConnectionEqualInnermost() throws Exception {
ds.setAccessToUnderlyingConnectionAllowed(true);
DelegatingConnection<?> con = (DelegatingConnection<?>) ds.getConnection();
Connection inner = con.getInnermostDelegate();
ds.setAccessToUnderlyingConnectionAllowed(false);
DelegatingConnection<Connection> con2 = new DelegatingConnection<>(inner);
assertFalse(con2.equals(con));
assertTrue(con.innermostDelegateEquals(con2.getInnermostDelegate()));
assertTrue(con2.innermostDelegateEquals(inner));
assertFalse(con.equals(con2));
}
}