Package com.spotfire.ws.im.ds.sql

Interface SQLRuntime

All Known Implementing Classes:
BasicSQLRuntime
public interface SQLRuntime
This interface should be implemented when full control over the SQL execution is required. An implementation of this class can be specified in a data source template.

By using wrapper classes for the returned Statement, PreparedStatement and ResultSet objects it is possible to customize the driver's implementation.

The following methods are called directly by Information Services:

 
ResultSet: setFetchSize, getFetchSize, next, getDate, getTime, getTimestamp, getInt, getLong, getFloat, getDouble, getBoolean, getCharacterStream, getBinaryStream, getString, wasNull, getStatement, getMetaData, close
Statement: cancel, close, executeUpdate, executeQuery
PreparedStatement: close, addBatch, executeUpdate, executeBatch, setNull, setDate, setTime, setTimestamp, setCharacterStream, setBinaryStream, setObject
Since:
3.0
See Also:

  • Method Details Link icon

    • setConnection Link icon

      void setConnection(Connection conn)
      Sets the JDBC database connection.
      Parameters:
      conn - connection
      Since:
      3.0

    • getConnection Link icon

      Connection getConnection()
      Returns:
      Returns the JDBC database connection.
      Since:
      3.0

    • setContext Link icon

      void setContext(JDBCContext c)
      Sets the JDBC context.
      Parameters:
      c - JDBCContext
      Since:
      3.0

    • getContext Link icon

      JDBCContext getContext()
      Returns:
      Returns the JDBC context.
      Since:
      3.0

    • executeUpdate Link icon

      void executeUpdate(String sql) throws SQLException
      Executes a SQL statement.
      Parameters:
      sql - SQL
      Throws:
      SQLException - SQLException
      Since:
      3.0

    • prepareUpdate Link icon

      PreparedStatement prepareUpdate(String sql) throws SQLException
      Parameters:
      sql - SQL
      Returns:
      Creates a precompiled SQL statement.
      Throws:
      SQLException - SQLException
      Since:
      3.0

    • prepareQuery Link icon

      PreparedStatement prepareQuery(String sql) throws SQLException
      Parameters:
      sql - SQL
      Returns:
      Creates a precompiled SQL statement for a parameterized query.
      Throws:
      SQLException - SQLException
      Since:
      3.0

    • executeQuery Link icon

      ResultSet executeQuery(String sql) throws SQLException
      Executes a SQL query.
      Parameters:
      sql - SQL
      Returns:
      ResultSet
      Throws:
      SQLException - SQLException
      Since:
      3.0

    • prepareCall Link icon

      CallableStatement prepareCall(String sql) throws SQLException
      Creates a CallableStatement object for calling database stored procedures.
      Parameters:
      sql - SQL
      Returns:
      CallableStatement
      Throws:
      SQLException - SQLException
      Since:
      3.0