Java tutorial
/** * 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.openejb.resource.jdbc; import org.apache.commons.dbcp2.PoolableConnection; import org.apache.commons.pool2.impl.GenericObjectPool; import org.apache.openejb.jee.EjbJar; import org.apache.openejb.junit.ApplicationComposer; import org.apache.openejb.resource.jdbc.pool.DefaultDataSourceCreator; import org.apache.openejb.testing.Classes; import org.apache.openejb.testing.Configuration; import org.apache.openejb.testing.Module; import org.apache.openejb.testing.SimpleLog; import org.apache.openejb.testng.PropertiesBuilder; import org.apache.openejb.util.reflection.Reflections; import org.hsqldb.jdbc.pool.JDBCXADataSource; import org.junit.Assert; import org.junit.Test; import org.junit.runner.RunWith; import javax.annotation.Resource; import javax.ejb.EJB; import javax.ejb.Singleton; import javax.sql.DataSource; import java.sql.Connection; import java.sql.SQLException; import java.util.Properties; import static org.junit.Assert.assertEquals; @SimpleLog @RunWith(ApplicationComposer.class) public class DbcpNPEXAConnectionTest { @Resource(name = "xadb") private DataSource ds; @EJB private AnEjb ejb; @Module @Classes(AnEjb.class) public EjbJar mandatory() { return new EjbJar(); } @Configuration public Properties props() { return new PropertiesBuilder() .p("openejb.jdbc.datasource-creator", DefaultDataSourceCreator.class.getName()) .p("txMgr", "new://TransactionManager?type=TransactionManager").p("txMgr.txRecovery", "true") .p("txMgr.logFileDir", "target/test/xa/DbcpNPEXAConnectionTest") // real XA datasources .p("xa", "new://Resource?class-name=" + JDBCXADataSource.class.getName()) .p("xa.url", "jdbc:hsqldb:mem:dbcpxa").p("xa.user", "sa").p("xa.password", "") .p("xa.SkipImplicitAttributes", "true").p("xa.SkipPropertiesFallback", "true") // otherwise goes to connection properties .p("xadb", "new://Resource?type=DataSource").p("xadb.xaDataSource", "xa") .p("xadb.JtaManaged", "true").p("xadb.MaxIdle", "25").p("xadb.MaxTotal", "25") .p("xadb.InitialSize", "3") .build(); } @Test public void check() throws SQLException { final Connection con = ejb.newConn(); con.close(); // no NPE Assert.assertTrue("Connection was not closed", con.isClosed()); final GenericObjectPool<PoolableConnection> pool = GenericObjectPool.class .cast(Reflections.get(ds, "connectionPool")); assertEquals(0, pool.getNumActive()); } @Singleton public static class AnEjb { @Resource(name = "xadb") private DataSource ds; public Connection newConn() throws SQLException { final Connection con = ds.getConnection(); con.close(); // first connection is not "shared" so closes correctly Assert.assertTrue("Connection was not closed", con.isClosed()); return use(ds.getConnection()); // this one is shared so delegate will be null and close outside JTA will fail } } private static Connection use(final Connection connection) { try { connection.getMetaData(); } catch (final SQLException e) { Assert.fail(e.getMessage()); } return connection; } }