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