@Test
 public void testGetThrowsSQLException() {
   SQLException exc = new BatchUpdateException();
   statementHandler.prepareThrowsSQLException("[abc] statement", exc);
   statementHandler.prepareThrowsSQLException("[abc] statementxyz");
   assertFalse(statementHandler.getThrowsSQLException("a stAtement"));
   assertNull(statementHandler.getSQLException("a stAtement"));
   statementHandler.setUseRegularExpressions(true);
   assertTrue(statementHandler.getThrowsSQLException("a stAtement"));
   assertSame(exc, statementHandler.getSQLException("a stAtement"));
   statementHandler.setCaseSensitive(true);
   assertFalse(statementHandler.getThrowsSQLException("a stAtement"));
   assertNull(statementHandler.getSQLException("a stAtement"));
   assertTrue(statementHandler.getThrowsSQLException("b statement"));
   assertSame(exc, statementHandler.getSQLException("b statement"));
   assertTrue(statementHandler.getThrowsSQLException("b statementxyz"));
   assertNotSame(exc, statementHandler.getSQLException("b statementxyz"));
   String message = statementHandler.getSQLException("b statementxyz").getMessage();
   assertTrue(message.indexOf("[abc] statementxyz") != -1);
 }
 @Test
 public void testClearMethods() {
   statementHandler.prepareResultSet("select", new MockResultSet("id"));
   statementHandler.prepareUpdateCount("select", 3);
   statementHandler.prepareThrowsSQLException("select");
   statementHandler.prepareReturnsResultSet("select", true);
   statementHandler.prepareGeneratedKeys("select", new MockResultSet("id"));
   statementHandler.clearResultSets();
   statementHandler.clearUpdateCounts();
   statementHandler.clearThrowsSQLException();
   statementHandler.clearReturnsResultSet();
   statementHandler.clearGeneratedKeys();
   assertNull(statementHandler.getResultSet("select"));
   assertNull(statementHandler.getUpdateCount("select"));
   assertFalse(statementHandler.getThrowsSQLException("select"));
   assertNull(statementHandler.getReturnsResultSet("select"));
   assertNull(statementHandler.getGeneratedKeys("select"));
 }