@Test public void testSingleQuotePresentInValueOneTimeEscaped() throws SQLException { try { final PreparedStatement prep = connection.prepareStatement("select * from valid_sql_logged where col_varchar = ?"); prep.setString(1, "foo'value"); prep.executeQuery(); prep.close(); } catch (Exception e) { fail(e.getMessage() + " due to error: " + getStackTrace(e)); } reRunStatement(false); }
@Test public void testSingleQuotePresentInValueMultipleTimesEscaped() throws SQLException { try { final PreparedStatement prep = connection.prepareStatement("select * from valid_sql_logged where col_varchar = ?"); prep.setString(1, "foo''value'"); prep.executeQuery(); prep.close(); } catch (Exception e) { fail(e.getMessage() + " due to error: " + getStackTrace(e)); } reRunStatement(false); }
private void testPreparedStatementWithNulls(boolean isUpdate) throws SQLException { final PreparedStatement prep = getPreparedStatement(isUpdate); int i = 0; prep.setNull(++i, java.sql.Types.VARCHAR); prep.setNull(++i, java.sql.Types.INTEGER); prep.setNull(++i, java.sql.Types.INTEGER); if (isDateTimeSupported()) { prep.setNull(++i, java.sql.Types.DATE); prep.setNull(++i, java.sql.Types.TIMESTAMP); } prep.setNull(++i, java.sql.Types.INTEGER); if (isBooleanSupported()) { prep.setNull(++i, java.sql.Types.BOOLEAN); } if (isUpdate) { prep.executeUpdate(); } else { prep.executeQuery(); } prep.close(); reRunStatement(isUpdate); }
private void testPreparedStatement(boolean isUpdate) throws SQLException { try { final PreparedStatement prep = getPreparedStatement(isUpdate); int i = 0; prep.setString(++i, "prepstmt_test_col1"); prep.setInt(++i, 1); prep.setInt(++i, 1); if (isDateTimeSupported()) { prep.setDate(++i, new Date(System.currentTimeMillis())); prep.setTimestamp(++i, new Timestamp(System.currentTimeMillis())); } prep.setInt(++i, 1); if (isBooleanSupported()) { prep.setBoolean(++i, true); } if (isUpdate) { prep.executeUpdate(); } else { prep.executeQuery(); } prep.close(); } catch (Exception e) { fail(e.getMessage() + " due to error: " + getStackTrace(e)); } reRunStatement(isUpdate); }