package com.alibaba.druid.pvt.pool; import java.lang.reflect.Field; import java.sql.Connection; import java.sql.SQLException; import java.util.concurrent.CountDownLatch; import java.util.concurrent.ExecutorService; import java.util.concurrent.Executors; import java.util.concurrent.atomic.AtomicInteger; import org.apache.log4j.Level; import org.apache.log4j.Logger; import org.junit.Assert; import com.alibaba.druid.pool.DruidDataSource; import com.alibaba.druid.support.logging.Log; import com.alibaba.druid.support.logging.Log4jImpl; import com.alibaba.druid.support.logging.NoLoggingImpl; import junit.framework.TestCase; public class AsyncCloseTest1 extends TestCase { protected DruidDataSource dataSource; private ExecutorService connExecutor; private ExecutorService closeExecutor; final AtomicInteger errorCount = new AtomicInteger(); private Logger log4jLog; private Level log4jOldLevel; private NoLoggingImpl noLoggingImpl; protected void setUp() throws Exception { Field logField = DruidDataSource.class.getDeclaredField("LOG"); logField.setAccessible(true); Log dataSourceLog = (Log) logField.get(null); if (dataSourceLog instanceof Log4jImpl) { this.log4jLog = ((Log4jImpl) dataSourceLog).getLog(); this.log4jOldLevel = this.log4jLog.getLevel(); this.log4jLog.setLevel(Level.FATAL); } else if (dataSourceLog instanceof NoLoggingImpl) { noLoggingImpl = (NoLoggingImpl) dataSourceLog; noLoggingImpl.setErrorEnabled(false); } dataSource = new DruidDataSource(); dataSource.setUrl("jdbc:mock:"); // dataSource.setAsyncCloseConnectionEnable(true); dataSource.setTestOnBorrow(false); dataSource.setMaxActive(16); connExecutor = Executors.newFixedThreadPool(128); closeExecutor = Executors.newFixedThreadPool(128); } protected void tearDown() throws Exception { dataSource.close(); if (log4jLog != null) { log4jLog.setLevel(log4jOldLevel); } else if (noLoggingImpl != null) { noLoggingImpl.setErrorEnabled(true); } } public void test_0() throws Exception { for (int i = 0; i < 16; ++i) { loop(); System.out.println("loop " + i + " done."); } } class CloseTask implements Runnable { private Connection conn; private CountDownLatch latch; public CloseTask(Connection conn, CountDownLatch latch){ this.conn = conn; this.latch = latch; } @Override public void run() { try { conn.close(); } catch (SQLException e) { errorCount.incrementAndGet(); } finally { latch.countDown(); } } } protected void loop() throws InterruptedException { dataSource.shrink(); Assert.assertEquals(0, dataSource.getActiveCount()); Assert.assertEquals(0, dataSource.getPoolingCount()); final int COUNT = 1024 * 128; final CountDownLatch closeLatch = new CountDownLatch(COUNT * 2); Runnable connTask = new Runnable() { @Override public void run() { try { Connection conn = dataSource.getConnection(); CloseTask closeTask = new CloseTask(conn, closeLatch); closeExecutor.submit(closeTask); closeExecutor.submit(closeTask); // dup close } catch (SQLException e) { errorCount.incrementAndGet(); } } }; for (int i = 0; i < COUNT; ++i) { connExecutor.submit(connTask); } closeLatch.await(); Assert.assertEquals(0, dataSource.getActiveCount()); Assert.assertEquals(16, dataSource.getPoolingCount()); } }