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.

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 DecisionSite 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:

7.2

See Also:

BasicSQLRuntime, PreparedStatementWrapper, StatementWrapper, ResultSetWrapper

Method Summary

ResultSet	executeQuery(String sql) Executes a SQL query.
void	executeUpdate(String sql) Executes a SQL statement.
Connection	getConnection() Returns the JDBC database connection.
JDBCContext	getContext() Returns the JDBC context.
CallableStatement	prepareCall(String sql) Creates a CallableStatement object for calling database stored procedures.
PreparedStatement	prepareQuery(String sql) Creates a precompiled SQL statement for a parameterized query.
PreparedStatement	prepareUpdate(String sql) Creates a precompiled SQL statement.
void	setConnection(Connection conn) Sets the JDBC database connection.
void	setContext(JDBCContext c) Sets the JDBC context.

Method Detail

setConnection

void setConnection(Connection conn)

Sets the JDBC database connection.

getConnection

Connection getConnection()

Returns the JDBC database connection.

setContext

void setContext(JDBCContext c)

Sets the JDBC context.

getContext

JDBCContext getContext()

Returns the JDBC context.

executeUpdate

void executeUpdate(String sql)

Executes a SQL statement.

prepareUpdate

PreparedStatement prepareUpdate(String sql)

Creates a precompiled SQL statement.

prepareQuery

PreparedStatement prepareQuery(String sql)

Creates a precompiled SQL statement for a parameterized query.

executeQuery

ResultSet executeQuery(String sql)

Executes a SQL query.

prepareCall

CallableStatement prepareCall(String sql)

Creates a CallableStatement object for calling database stored procedures.