List of usage examples for org.apache.commons.configuration ConfigurationException printStackTrace
public void printStackTrace()
From source file:jdbc.pool.JDBCPoolTestCase.java
/** * Test case for LIFO Algorithm with Maximum JDBC Usage parameter. *//*ww w . j a v a2 s . c o m*/ public void testLIFOAlgorithm() { System.out.println("testLIFOAlgorithm with Maximum Usage Counter Start."); try { CConnectionPoolManager manager = create(); Connection realCon = null; Connection con = manager.getConnection("LIFO"); //It has 3 iniital connections. if (con instanceof ConnectionWrapper) { ConnectionWrapper wrapper = (ConnectionWrapper) con; realCon = wrapper.realConnection(); } else { fail("Connection returned is not an instance of ConnectionWrapper"); } con.close(); con = manager.getConnection("LIFO"); con.close(); assertFalse("Connection must be active", realCon.isClosed()); con = manager.getConnection("LIFO"); con.close(); assertFalse("Connection must be active", realCon.isClosed()); con = manager.getConnection("LIFO"); con.close(); assertTrue("Connection must be active", realCon.isClosed()); manager.destroy(true); } catch (ConfigurationException e) { e.printStackTrace(); fail("Caught ConfigurationException"); } catch (ParseException e) { e.printStackTrace(); fail("Caught ParseException"); } catch (IOException e) { e.printStackTrace(); fail("Caught IOException"); } catch (SQLException e) { e.printStackTrace(); fail("Caught SQLException"); } catch (ClassNotFoundException e) { e.printStackTrace(); fail("Caught ClassNotFoundException"); } System.out.println("testLIFOAlgorithm with Maximum Usage Counter End."); }
From source file:jdbc.pool.JDBCPoolTestCase.java
public void testGetAllPoolStatistics() { try {/*from www. j av a 2 s. com*/ CConnectionPoolManager manager = null; manager = create(); Connection con = manager.getConnection("ORACLE"); CPoolStatisticsBean beanOracle = manager.getPoolStatistics("ORACLE"); assertEquals("pool name", "ORACLE", beanOracle.getPoolName()); assertEquals("Bad Connections Count", 0, beanOracle.getBadConnectionCount()); assertEquals("Connections High Count", 1, beanOracle.getConnectionsHighCount()); assertEquals("Current Free Connections", 0, beanOracle.getCurrentFreeConnectionCount()); assertEquals("Current Used Connection count", 1, beanOracle.getCurrentUsedConnectionCount()); assertEquals("Leaked Connection Count", 0, beanOracle.getLeakedConnectionCount()); assertEquals("Leaked Statement Count", 0, beanOracle.getLeakedStatementCount()); assertEquals("Leaked ResultSet Count", 0, beanOracle.getLeakedResultSetCount()); // CPoolStatisticsBean beanMySQL = manager.getPoolStatistics("MYSQL"); assertEquals("pool name", "MYSQL", beanMySQL.getPoolName()); assertEquals("Bad Connections Count", 0, beanMySQL.getBadConnectionCount()); assertEquals("Connections High Count", 0, beanMySQL.getConnectionsHighCount()); assertEquals("Current Free Connections", 3, beanMySQL.getCurrentFreeConnectionCount()); assertEquals("Current Used Connection count", 0, beanMySQL.getCurrentUsedConnectionCount()); assertEquals("Leaked Connection Count", 0, beanMySQL.getLeakedConnectionCount()); assertEquals("Leaked Statement Count", 0, beanMySQL.getLeakedStatementCount()); assertEquals("Leaked ResultSet Count", 0, beanMySQL.getLeakedResultSetCount()); con.close(); manager.destroy(true); } catch (ConfigurationException e) { e.printStackTrace(); fail("Caught ConfigurationException"); } catch (ParseException e) { e.printStackTrace(); fail("Caught ParseException"); } catch (IOException e) { e.printStackTrace(); fail("Caught IOException"); } catch (SQLException e) { e.printStackTrace(); fail("Caught SQLException"); } catch (ClassNotFoundException e) { e.printStackTrace(); fail("Caught ClassNotFoundException"); } }
From source file:jdbc.pool.JDBCPoolTestCase.java
/** * Test if JDBC connection is getting closed after crossing the maximum * usage per JDBC connection./*w w w .j av a2 s . c o m*/ * */ public void testMaxUsagePerJDBCConnection() { System.out.println("testMaxUsagePerJDBCConnection start."); try { CConnectionPoolManager manager = create(); Connection realCon = null; Connection con = manager.getConnection("ORACLE"); if (con instanceof ConnectionWrapper) { ConnectionWrapper wrapper = (ConnectionWrapper) con; realCon = wrapper.realConnection(); } else { fail("Connection returned is not an instance of ConnectionWrapper"); } con.close(); assertFalse("Connection must be active", realCon.isClosed()); // 2 con = manager.getConnection("ORACLE"); con.close(); assertFalse("Connection must be active", realCon.isClosed()); // 3 con = manager.getConnection("ORACLE"); con.close(); assertFalse("Connection must be active", realCon.isClosed()); // 4 con = manager.getConnection("ORACLE"); con.close(); assertTrue("Connection must be closed", realCon.isClosed()); manager.destroy(true); } catch (ConfigurationException e) { e.printStackTrace(); fail("Caught ConfigurationException"); } catch (ParseException e) { e.printStackTrace(); fail("Caught ParseException"); } catch (IOException e) { e.printStackTrace(); fail("Caught IOException"); } catch (SQLException e) { e.printStackTrace(); fail("Caught SQLException"); } catch (ClassNotFoundException e) { e.printStackTrace(); fail("Caught ClassNotFoundException"); } System.out.println("testMaxUsagePerJDBCConnection end."); }
From source file:jdbc.pool.JDBCPoolTestCase.java
/** * Tests Inactive time out closing of the JDBC Connection. * //from w w w .ja v a2 s. c o m * Check whether the connection returns back to the pool. */ public void testInactiveTimeout() { System.out.println("testInactiveTimeout Start."); CConnectionPoolManager manager = null; try { manager = create(); Connection conOra1 = manager.getConnection("ORACLE"); Connection realCon = null; Connection conOra2 = manager.getConnection("ORACLE"); if (conOra2 instanceof ConnectionWrapper) { ConnectionWrapper wrapper = (ConnectionWrapper) conOra2; realCon = wrapper.realConnection(); } else { fail("Connection returned is not an instance of ConnectionWrapper"); } conOra2.close(); try { // 4 = 1 + 3 + (1) As the maximum time in which the con will be // closed is 4 have an additional 1 minute extra Thread.sleep(5 * 60 * 1000); // Shrink Pool Interval 1 minute + Inactive timeout 3 mins. } catch (InterruptedException e1) { e1.printStackTrace(); } assertTrue("Real Connection is closed", realCon.isClosed()); conOra1.close(); CPoolStatisticsBean bean = manager.getPoolStatistics("ORACLE"); assertEquals("Pool Name", "ORACLE", bean.getPoolName()); System.out.println("********************************************************"); ArrayList al = manager.getPoolStatisticsHistory("ORACLE"); assertTrue("Statistics History Count", 5 >= al.size()); for (Iterator iter = al.iterator(); iter.hasNext();) { CPoolStatisticsBean element = (CPoolStatisticsBean) iter.next(); System.out.println(element.toString()); } System.out.println("********************************************************"); } catch (ConfigurationException e) { e.printStackTrace(); fail("Caught ConfigurationException"); } catch (ParseException e) { e.printStackTrace(); fail("Caught ParseException"); } catch (IOException e) { e.printStackTrace(); fail("Caught IOException"); } catch (SQLException e) { e.printStackTrace(); fail("Caught SQLException"); } catch (ClassNotFoundException e) { e.printStackTrace(); fail("Caught ClassNotFoundException"); } finally { manager.destroy(true); } System.out.println("testInactiveTimeout end."); }
From source file:jdbc.pool.JDBCPoolTestCase.java
/** * Tests the get methods of CPoolAttribute for pools ORACLE and MYSQL. * *//*from w ww . j a v a2 s .c o m*/ public void testCPoolAttributeGET() { CConnectionPoolManager manager = null; try { manager = create(); CPoolAttribute attribOraclePool = CConnectionPoolManager.getInstance().getPoolAttributes("ORACLE"); CPoolAttribute attribMySqlPool = CConnectionPoolManager.getInstance().getPoolAttributes("MYSQL"); assertEquals("Capacity Increament", 1, attribOraclePool.getCapacityIncreament()); assertEquals("Capacity Increament", 2, attribMySqlPool.getCapacityIncreament()); assertEquals("Connection Idle Timeout", 3, attribOraclePool.getConnectionIdleTimeout()); assertEquals("Connection Idle Timeout", 5, attribMySqlPool.getConnectionIdleTimeout()); assertEquals("Driver", "oracle.jdbc.driver.OracleDriver", attribOraclePool.getDriver()); assertEquals("Driver", "com.mysql.jdbc.Driver", attribMySqlPool.getDriver()); assertEquals("Initial Pool Size", 1, attribOraclePool.getInitialPoolSize()); assertEquals("Initial Pool Size", 3, attribMySqlPool.getInitialPoolSize()); assertEquals("Maximum Capacity", 5, attribOraclePool.getMaximumCapacity()); assertEquals("Maximum Capacity", 50, attribMySqlPool.getMaximumCapacity()); assertNotNull("Password not null", attribOraclePool.getPassword()); assertNotNull("Password not null", attribMySqlPool.getPassword()); assertEquals("Pool Name", "ORACLE", attribOraclePool.getPoolName()); assertEquals("Pool Name", "MYSQL", attribMySqlPool.getPoolName()); assertEquals("Shrink Pool Interval", 1, attribOraclePool.getShrinkPoolInterval()); assertEquals("Shrink Pool Interval", 1, attribMySqlPool.getShrinkPoolInterval()); assertEquals("URL", "jdbc:oracle:thin:@192.100.192.114:1521:SUN2DB1", attribOraclePool.getURL()); assertEquals("URL", "jdbc:mysql://localhost/newpre", attribMySqlPool.getURL()); assertEquals("USER", "rendev", attribOraclePool.getUser()); assertEquals("USER", "root", attribMySqlPool.getUser()); assertEquals("VENDOR", "ORACLE", attribOraclePool.getVendor()); assertEquals("VENDOR", "MySQL", attribMySqlPool.getVendor()); assertEquals("Critical Operation Time Limit", 1000, attribOraclePool.getCriticalOperationTimeLimit()); assertEquals("Critical Operation Time Limit", 10000, attribMySqlPool.getCriticalOperationTimeLimit()); assertEquals("In Use Wait Time", 7, attribOraclePool.getInUseWaitTime()); assertEquals("In Use Wait Time", 10, attribMySqlPool.getInUseWaitTime()); assertEquals("Load On Startup", false, attribOraclePool.isLoadOnStartup()); assertEquals("Load On Startup", true, attribMySqlPool.isLoadOnStartup()); assertEquals("Maximum Capacity", 4, attribOraclePool.getMaxUsagePerJDBCConnection()); assertEquals("Maximum Capacity", -1, attribMySqlPool.getMaxUsagePerJDBCConnection()); } catch (ConfigurationException e) { e.printStackTrace(); fail("Caught ConfigurationException"); } catch (ParseException e) { e.printStackTrace(); fail("Caught ParseException"); } catch (IOException e) { e.printStackTrace(); fail("Caught IOException"); } catch (SQLException e) { e.printStackTrace(); fail("Caught SQLException"); } catch (ClassNotFoundException e) { e.printStackTrace(); fail("Caught ClassNotFoundException"); } finally { manager.destroy(true); } }
From source file:jdbc.pool.JDBCPoolOracleConnectionTest.java
public void testDestroy() { testGetInstanceNull();// w ww .j ava 2s . c o m System.out.println("testDestroy Start."); try { CConnectionPoolManager manager = null; manager = create(); manager.destroy(true); testGetInstanceNull(); } catch (ConfigurationException e) { e.printStackTrace(); fail("Caught ConfigurationException"); } catch (ParseException e) { e.printStackTrace(); fail("Caught ParseException"); } catch (IOException e) { e.printStackTrace(); fail("Caught IOException"); } catch (SQLException e) { e.printStackTrace(); fail("Caught SQLException"); } catch (ClassNotFoundException e) { e.printStackTrace(); fail("Caught ClassNotFoundException"); } System.out.println("testDestroy end."); }
From source file:jdbc.pool.JDBCPoolTestCase.java
/** * Test case for Statement Caching./*from ww w .ja va2s . co m*/ */ public void testStatementCaching() { System.out.println("testStatementCaching Start."); CConnectionPoolManager manager = null; Connection con = null; //It has 3 iniital connections. PreparedStatement st; PreparedStatement st1; try { manager = create(); con = manager.getConnection("ORACLE"); st = con.prepareStatement("SELECT count(*) FROM DUAL"); PreparedStatement realPsm = null; if (st instanceof PreparedStatementWrapper) { PreparedStatementWrapper wrapper = (PreparedStatementWrapper) st; realPsm = (PreparedStatement) wrapper.realStatement(); } else { fail("Instanceof failed"); } st.execute(); st1 = con.prepareStatement("SELECT count(*) FROM DUAL"); if (st1 instanceof PreparedStatementWrapper) { PreparedStatementWrapper wrapper = (PreparedStatementWrapper) st1; realPsm = (PreparedStatement) wrapper.realStatement(); assertEquals("Statement Cache", realPsm, (PreparedStatement) wrapper.realStatement()); } else { con.close(); fail("Instanceof failed"); } } catch (ConfigurationException e) { e.printStackTrace(); fail("Caught ConfigurationException"); } catch (ParseException e) { e.printStackTrace(); fail("Caught ParseException"); } catch (IOException e) { e.printStackTrace(); fail("Caught IOException"); } catch (SQLException e) { e.printStackTrace(); fail("Caught SQLException"); } catch (ClassNotFoundException e) { e.printStackTrace(); fail("Caught ClassNotFoundException"); } finally { if (con != null) { try { con.close(); } catch (SQLException e) { e.printStackTrace(); } } if (manager != null) { manager.destroy(true); } } System.out.println("testStatementCaching End."); }
From source file:jdbc.pool.JDBCPoolOracleConnectionTest.java
public void testGetInstanceStringFile() { testGetInstanceNull();/*from ww w.j a va 2 s. c o m*/ System.out.println("testGetInstanceStringFile Start"); try { CConnectionPoolManager manager = null; manager = create(); assertNotNull("check manager for not null", manager); assertNotNull("check CConnectionPoolManager.getInstance() for not null", CConnectionPoolManager.getInstance()); assertTrue("check manager == CConnectionPoolManager.getInstance()", manager.hashCode() == CConnectionPoolManager.getInstance().hashCode()); manager.destroy(true); testGetInstanceNull(); } catch (ConfigurationException e) { e.printStackTrace(); fail("Caught ConfigurationException"); } catch (ParseException e) { e.printStackTrace(); fail("Caught ParseException"); } catch (IOException e) { e.printStackTrace(); fail("Caught IOException"); } catch (SQLException e) { e.printStackTrace(); fail("Caught SQLException"); } catch (ClassNotFoundException e) { e.printStackTrace(); fail("Caught ClassNotFoundException"); } System.out.println("testGetInstanceStringFile End"); }
From source file:jdbc.pool.JDBCPoolOracleConnectionTest.java
public void testGetInstanceStringFile2() { testGetInstanceNull();/*from w w w. j a va 2 s . c o m*/ System.out.println("testGetInstanceStringFile2 Start"); try { CConnectionPoolManager manager = CConnectionPoolManager.getInstance(null, new File( "C:/Documents and Settings/kedarr/workspace/jdbcpool/junit-source/config/pool.properties")); assertNotNull("Instance not null", manager); assertNotNull("Ascertain CConnectionPoolManager.getInstance()also returns not null", CConnectionPoolManager.getInstance()); assertTrue("ascertain CConnectionPoolManager.getInstance() == manager", manager.hashCode() == CConnectionPoolManager.getInstance().hashCode()); manager.destroy(true); testGetInstanceNull(); } catch (ConfigurationException e) { e.printStackTrace(); fail("Caught ConfigurationException"); } catch (ParseException e) { e.printStackTrace(); fail("Caught ParseException"); } catch (IOException e) { e.printStackTrace(); fail("Caught IOException"); } catch (SQLException e) { e.printStackTrace(); fail("Caught SQLException"); } catch (ClassNotFoundException e) { e.printStackTrace(); fail("Caught ClassNotFoundException"); } System.out.println("testGetInstanceStringFile2 end"); }
From source file:jdbc.pool.JDBCPoolTestCase.java
/** * Tests Inactive Timeout for -1 or 0 value. * This pool has different set of parameters as compared to MYSQL pool and this forces the behaviour changes * in the pool. The connections will not be pooled and therefore the connections will be closed upon release. *///from w ww. j a v a2 s .co m public void testTIT() { System.out.println("testTIT Start."); CConnectionPoolManager manager = null; try { manager = create(); CPoolAttribute attrib = manager.getPoolAttributes("TIT"); assertEquals("Driver", "com.mysql.jdbc.Driver", attrib.getDriver()); assertEquals("Vendor", "MySQL", attrib.getVendor()); assertEquals("URL", "jdbc:mysql://localhost/newpre", attrib.getURL()); assertEquals("User", "root", attrib.getUser()); assertEquals("Password", "=?UTF-8?B?cm9vdA==?=", attrib.getPassword()); assertEquals("Initial Pool Size", 3, attrib.getInitialPoolSize()); assertEquals("Capacity Increament", 2, attrib.getCapacityIncreament()); assertEquals("Maximum Capacity", 50, attrib.getMaximumCapacity()); assertEquals("Connection Idle Timeout", -1, attrib.getConnectionIdleTimeout()); assertEquals("Shrink Pool Interval", 1, attrib.getShrinkPoolInterval()); assertEquals("Critical Operation Timelimit", 10000, attrib.getCriticalOperationTimeLimit()); assertEquals("In Use wait time", 10, attrib.getInUseWaitTime()); assertFalse("load-on-startup", attrib.isLoadOnStartup()); Connection conOra1 = manager.getConnection("TIT"); Connection realCon = null; if (conOra1 instanceof ConnectionWrapper) { ConnectionWrapper wrapper = (ConnectionWrapper) conOra1; realCon = wrapper.realConnection(); } else { fail("Connection returned is not an instance of ConnectionWrapper"); } conOra1.close(); assertTrue("Connection must get closed as the inactive-time-out <= 0", realCon.isClosed()); attrib = manager.getPoolAttributes("TIT"); assertEquals("Driver", "com.mysql.jdbc.Driver", attrib.getDriver()); assertEquals("Vendor", "MySQL", attrib.getVendor()); assertEquals("URL", "jdbc:mysql://localhost/newpre", attrib.getURL()); assertEquals("User", "root", attrib.getUser()); assertEquals("Password", "=?UTF-8?B?cm9vdA==?=", attrib.getPassword()); assertEquals("Initial Pool Size", 0, attrib.getInitialPoolSize()); assertEquals("Capacity Increament", 1, attrib.getCapacityIncreament()); assertEquals("Maximum Capacity", 50, attrib.getMaximumCapacity()); assertEquals("Connection Idle Timeout", -1, attrib.getConnectionIdleTimeout()); assertEquals("Shrink Pool Interval", -1, attrib.getShrinkPoolInterval()); assertEquals("Critical Operation Timelimit", 10000, attrib.getCriticalOperationTimeLimit()); assertEquals("In Use wait time", 10, attrib.getInUseWaitTime()); assertFalse("load-on-startup", attrib.isLoadOnStartup()); } catch (ConfigurationException e) { e.printStackTrace(); fail("Caught ConfigurationException"); } catch (ParseException e) { e.printStackTrace(); fail("Caught ParseException"); } catch (IOException e) { e.printStackTrace(); fail("Caught IOException"); } catch (SQLException e) { e.printStackTrace(); fail("Caught SQLException"); } catch (ClassNotFoundException e) { e.printStackTrace(); fail("Caught ClassNotFoundException"); } finally { manager.destroy(true); } System.out.println("testTIT end."); }