@Test public void testAddToDate() throws SQLException { if (db.equals("PostgreSQL")) { String select = "select * from prepstmt_test3 where (date(col1) + ?) < now() "; PreparedStatement prep = getPreparedStatement(select); prep.setInt(1, 10); prep.executeQuery(); prep.close(); } }
PreparedStatement prep = getPreparedStatement(update); prep.setString(1, "execQueryTest"); prep.setInt(2, 1); prep = getPreparedStatement(query); prep.setString(1, "execQueryTest"); ResultSet rs = prep.executeQuery();
@Test public void binaryExcludedFalse() throws SQLException { // given P6LogOptions.getActiveInstance().setExcludebinary(false); // when String update = "insert into img values (?, ?, ?)"; PreparedStatement prep = getPreparedStatement(update); prep.setInt(1, 1); prep.setBytes(2, "foo".getBytes(StandardCharsets.UTF_8)); if( // java.sql.SQLFeatureNotSupportedException: Method org.postgresql.jdbc4.Jdbc4Connection.createBlob() is not yet implemented. "PostgreSQL".equals(db) // // org.firebirdsql.jdbc.FBDriverNotCapableException: Not yet implemented. // at org.firebirdsql.jdbc.FBBlob.setBytes(FBBlob.java:472) || "Firebird".equals(db) // // java.lang.AbstractMethodError // at com.p6spy.engine.wrapper.ConnectionWrapper.createBlob(ConnectionWrapper.java:315) || "SQLite".equals(db)) { prep.setBytes(3, "foo".getBytes(StandardCharsets.UTF_8)); } else { Blob data = connection.createBlob(); data.setBytes(1, "foo".getBytes(StandardCharsets.UTF_8)); prep.setBlob(3, data); } prep.execute(); // then assertTrue(super.getLastLogEntry().contains("insert into img values (1, '666F6F',")); }
@Test public void binaryExcludedTrue() throws SQLException { // given P6LogOptions.getActiveInstance().setExcludebinary(true); // when String update = "insert into img values (?, ?, ?)"; PreparedStatement prep = getPreparedStatement(update); prep.setInt(1, 1); prep.setBytes(2, "foo".getBytes(StandardCharsets.UTF_8)); if( // java.sql.SQLFeatureNotSupportedException: Method org.postgresql.jdbc4.Jdbc4Connection.createBlob() is not yet implemented. "PostgreSQL".equals(db) // // org.firebirdsql.jdbc.FBDriverNotCapableException: Not yet implemented. // at org.firebirdsql.jdbc.FBBlob.setBytes(FBBlob.java:472) || "Firebird".equals(db) // // java.lang.AbstractMethodError // at com.p6spy.engine.wrapper.ConnectionWrapper.createBlob(ConnectionWrapper.java:315) || "SQLite".equals(db)) { prep.setBytes(3, "foo".getBytes(StandardCharsets.UTF_8)); } else { Blob data = connection.createBlob(); data.setBytes(1, "foo".getBytes(StandardCharsets.UTF_8)); prep.setBlob(3, data); } prep.execute(); // then assertTrue(super.getLastLogEntry().contains("insert into img values (1, '[binary]', ")); }
PreparedStatement prep = getPreparedStatement(update); prep.setString(1, "miller"); prep.setInt(2, 1); prep = getPreparedStatement(bigSelect.toString()); for (int i = 1; i <= MaxFields; i++) { prep.setInt(i, i); prep = getPreparedStatement(update); prep.setString(1, "danny"); prep.setInt(2, 2); prep = getPreparedStatement(query); ResultSet rs = prep.executeQuery(); rs.next();
@Test public void testCallingSetMethodsOnStatementInterface() throws SQLException { String sql = "select * from prepstmt_test where col1 = ?"; PreparedStatement prep = getPreparedStatement(sql); prep.setMaxRows(1); assertEquals(1, prep.getMaxRows()); prep.setQueryTimeout(12); // The SQLLite driver returns the value in ms assertEquals(("SQLite".equals(db) ? 3000 : 12), prep.getQueryTimeout()); prep.close(); }
final PreparedStatement prep = getPreparedStatement(update); prep.setString(1, "prepstmt_test_col1"); prep.setInt(2, 1); final PreparedStatement prep = getPreparedStatement(update); prep.setString(1, "prepstmt_test_col2"); prep.setInt(2, 1); final PreparedStatement prep = getPreparedStatement(query); prep.setString(1, "prepstmt_test_col1"); prep.setString(2, "prepstmt_test_col2");