private PreparedStatement buildBatchStatement(String sql, boolean callable) { return jdbcCoordinator.getStatementPreparer().prepareStatement( sql, callable ); }
@Override public void execute(Connection connection) throws SQLException { Statement stmt = ((SessionImplementor)s).getJdbcCoordinator().getStatementPreparer().createStatement(); ((SessionImplementor)s).getJdbcCoordinator().getResultSetReturn().executeUpdate( stmt, "DROP FUNCTION spLock FROM TestInterSystemsFunctionsClass" ); } }
final ScrollMode scrollMode = getScrollMode( scroll, hasFirstRow, useLimitOffset, queryParameters ); PreparedStatement st = session.getJdbcCoordinator().getStatementPreparer().prepareQueryStatement( sql, callable,
Statement statement = jdbcCoord.getStatementPreparer().createStatement(); String dropSql = getDialect().getDropTableString( "SANDBOX_JDBC_TST" ); try { PreparedStatement ps = jdbcCoord.getStatementPreparer().prepareStatement( "insert into SANDBOX_JDBC_TST( ID, NAME ) values ( ?, ? )" ); ps.setLong( 1, 1 ); jdbcCoord.getResultSetReturn().execute( ps ); ps = jdbcCoord.getStatementPreparer().prepareStatement( "select * from SANDBOX_JDBC_TST" ); jdbcCoord.getResultSetReturn().extract( ps );
.getStatementPreparer().prepareQueryStatement( sql, callable, scrollMode );
@Override protected PreparedStatement prepare(String insertSQL, SharedSessionContractImplementor session) throws SQLException { return session .getJdbcCoordinator() .getStatementPreparer() .prepareStatement( insertSQL, keyColumns ); } }
@Override public PreparedStatement prepareQueryStatement(String sql, boolean isCallable, ScrollMode scrollMode) { return delegate.prepareQueryStatement(sql, isCallable, scrollMode); } }
public void execute(Connection connection) throws SQLException { Statement st = s.getJdbcCoordinator().getStatementPreparer().createStatement(); s.getJdbcCoordinator().getResultSetReturn().extract( st, "SELECT COUNT(*) FROM " + table ); ResultSet result = s.getJdbcCoordinator().getResultSetReturn().extract( st, "SELECT COUNT(*) FROM " + table ); result.next(); int rowCount = result.getInt( 1 ); assertEquals( "Unexpected row count", expectedRowCount, rowCount ); } }
@Override protected PreparedStatement prepare(String insertSQL, SharedSessionContractImplementor session) throws SQLException { return session .getJdbcCoordinator() .getStatementPreparer() .prepareStatement( insertSQL, PreparedStatement.RETURN_GENERATED_KEYS ); }
@Override public PreparedStatement prepareQueryStatement(String sql, boolean isCallable, ScrollMode scrollMode) { return delegate.prepareQueryStatement(sql, isCallable, scrollMode); } }
@Override public void execute(Connection connection) throws SQLException { Statement stmt = ( (SessionImplementor) s ).getJdbcCoordinator() .getStatementPreparer() .createStatement(); String create_function = "CREATE FUNCTION SQLUser.TestInterSystemsFunctionsClass_spLock\n" + " ( INOUT pHandle %SQLProcContext, \n" + " ROWID INTEGER \n" + " )\n" + " FOR User.TestInterSystemsFunctionsClass " + " PROCEDURE\n" + " RETURNS INTEGER\n" + " LANGUAGE OBJECTSCRIPT\n" + " {\n" + " q 0\n" + " }"; ( (SessionImplementor) s ).getJdbcCoordinator().getResultSetReturn().executeUpdate( stmt, create_function ); } }
@Override protected PreparedStatement prepare(String insertSQL, SharedSessionContractImplementor session) throws SQLException { return session .getJdbcCoordinator() .getStatementPreparer() .prepareStatement( insertSQL, PreparedStatement.NO_GENERATED_KEYS ); }
@Override public PreparedStatement prepareQueryStatement(String sql, boolean isCallable, ScrollMode scrollMode) { return delegate.prepareQueryStatement(sql, isCallable, scrollMode); } }
@Override public Statement createStatement() { return delegate.createStatement(); }
@Override protected PreparedStatement prepare(String insertSQL, SharedSessionContractImplementor session) throws SQLException { return session.getJdbcCoordinator().getStatementPreparer().prepareStatement( insertSQL, keyColumns ); }
@Override public PreparedStatement prepareQueryStatement(String sql, boolean isCallable, ScrollMode scrollMode) { return delegate.prepareQueryStatement(sql, isCallable, scrollMode); } }
@Override public Statement createStatement() { return delegate.createStatement(); }
@Override public void execute(Connection connection) throws SQLException { PreparedStatement statement = ((SessionImplementor)s).getJdbcCoordinator().getStatementPreparer().prepareStatement( "SELECT * FROM STRANGE_TYPED_OBJECT WHERE ID=?" ); statement.setInt(1, id.intValue()); ResultSet resultSet = ((SessionImplementor)s).getJdbcCoordinator().getResultSetReturn().extract( statement ); assertTrue("A row should have been returned", resultSet.next()); assertTrue("Default value should have been mapped to null", resultSet.getObject("VALUE_ONE") == null); assertTrue("Default value should have been mapped to null", resultSet.getObject("VALUE_TWO") == null); assertEquals("Non-Default value should not be changed", resultSet.getInt("VALUE_THREE"), 5); assertTrue("Default value should have been mapped to null", resultSet.getObject("VALUE_FOUR") == null); } }
@Override public PreparedStatement prepareQueryStatement(String sql, boolean isCallable, ScrollMode scrollMode) { return delegate.prepareQueryStatement(sql, isCallable, scrollMode); } }
@Override public Statement createStatement() { return delegate.createStatement(); }