Skip navigation links

Oracle® TimesTen In-Memory Database JDBC Extensions Java API Reference
11g Release 2 (11.2.2)

E21647-03


com.timesten.jdbc
Interface TimesTenStatement

All Superinterfaces:
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
 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, execute, execute, execute, execute, executeBatch, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isPoolable, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, 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 - >= 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 < 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 >= -1. -1 disables the feature. 0 enables LOB prefetch of meta data only (lob length and chunk size). Any value >=0 represents the number of bytes to be prefetched for BLOB and the number of chars for CLOB.
Throws:
java.sql.SQLException - if value < -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.

Skip navigation links

Oracle® TimesTen In-Memory Database JDBC Extensions Java API Reference
11g Release 2 (11.2.2)

E21647-03


Copyright © 1999, 2013, Oracle and/or its affiliates. All rights reserved.