@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"));
}