public void testCheckoutExpiredAvailableConnection() { long timeout = pool.getConnectionIdleTime(); pool.setConnectionIdleTime(0); Connection conn = pool.checkout(); pool.checkin(conn); int initCount = pool.connections; pool.checkout(); assertEquals(initCount, pool.connections); assertEquals(pool.getNumberAvailableConnections(), 0); pool.setConnectionIdleTime(timeout); }
public void testMultipleConnectionPools() { // check the number of available connections in the pool assertEquals(0, pool.getNumberAvailableConnections()); // checkout a default db connection Connection conn = pool.checkout(); pool.checkin(conn); assertEquals(1, pool.getNumberAvailableConnections()); // checkout a tigerprawn db connection ConnectionPool tp = ConnectionPool.getInstance(OTHER_APP_NAME); try { assertNotSame(pool, tp); assertEquals(0, tp.getNumberAvailableConnections()); conn = tp.checkout(); tp.checkin(conn); assertEquals(1, pool.getNumberAvailableConnections()); assertEquals(1, tp.getNumberAvailableConnections()); } finally { if (tp != null) tp.stopPool(); } }