com.timesten.jdbc

Interface TimesTenStatement

All Superinterfaces:

java.lang.AutoCloseable, java.sql.Statement, java.sql.Wrapper

All Known Subinterfaces:

TimesTenCallableStatement, TimesTenPreparedStatement

public interface TimesTenStatement
extends java.sql.Statement

Contains Oracle TimesTen extension to Statement.

Field Summary

Fields inherited from interface java.sql.Statement

CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO

Method Summary

Modifier and Type	Method and Description
int	getLobPrefetchSize() Returns the LOB prefetch size.
int	getQueryTimeThreshold() Returns value of query time threshold in effect.
void	setLobPrefetchSize(int value) Overrides the existing prefetch size for LOBs.
void	setQueryTimeThreshold(int seconds) Sets query time threshold for the Statement.

Methods inherited from interface java.sql.Statement

addBatch, cancel, clearBatch, clearWarnings, close, closeOnCompletion, execute, execute, execute, execute, executeBatch, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getLargeMaxRows, getLargeUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout

Methods inherited from interface java.sql.Wrapper

isWrapperFor, unwrap

Method Detail

setQueryTimeThreshold

void setQueryTimeThreshold(int seconds)
                    throws java.sql.SQLException

Sets query time threshold for the Statement. By default, Statement inherits query time threshold of the Connection. If query time thresold is exceeded, TimesTen will log a warning message and raise an SNMP trap.

Parameters:

seconds - equals or greater than 0. 0 Implies no query time threshold. You can use zero to annul the current query time thresold.

Throws:

java.sql.SQLException - if a database error occurs or seconds less than 0

getQueryTimeThreshold

int getQueryTimeThreshold()
                   throws java.sql.SQLException

Returns value of query time threshold in effect.

Returns:

Current value of query time threshold in seconds.

Throws:

java.sql.SQLException - if a database error occurs.

setLobPrefetchSize

void setLobPrefetchSize(int value)
                 throws java.sql.SQLException

Overrides the existing prefetch size for LOBs. With LOB prefetch, meta-data such as the lob length and the chunk size as well as the beginning of the LOB data are sent along with the locator during the regular fetch operation. This has a significant performance impact especially for small LOBs which can potentially be entirely prefetched. The data is then available to the user without having to go through the LOB protocol.

Parameters:

value - must be equals or greater than -1. -1 disables the feature. 0 enables LOB prefetch of meta data only (lob length and chunk size). Any value equals or greater than 0 represents the number of bytes to be prefetched for BLOB and the number of chars for CLOB.

Throws:

java.sql.SQLException - if value is less than -1.

See Also:

TimesTenConnection

getLobPrefetchSize

int getLobPrefetchSize()
                throws java.sql.SQLException

Returns the LOB prefetch size. This value can be set at the connection level or at the statement level through the setLobPrefetchSize(int) method.

Returns:

Current prefetch size for LOBs.

Throws:

java.sql.SQLException - if a database error occurs.