Skip navigation links

Oracle® TimesTen In-Memory Database JDBC Extensions Java API Reference
Release 11.2.1

E13083-02


com.timesten.jdbc
Interface TimesTenPreparedStatement

All Superinterfaces:
java.sql.PreparedStatement, java.sql.Statement, java.sql.Wrapper

public interface TimesTenPreparedStatement
extends java.sql.PreparedStatement

Contains TimesTen extension to java.sql.PreparedStatement

Since:
11.2.1
Version:
$Header: timesten/jdbc/src/jdbc/TimesTenPreparedStatement.java /main/4 2010/01/22 10:54:42 mardhana Exp $

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
 java.sql.ResultSet getReturnResultSet()
          Returns the DML returned parameters in the form of a ResultSet.
 void registerReturnParameter(int paramIndex, int sqlType)
          Use this method to register DML returning parameters.
 void registerReturnParameter(int paramIndex, int sqlType, int maxSize)
          Use this method to register DML returning parameters.

 

Methods inherited from interface java.sql.PreparedStatement
addBatch, clearParameters, execute, executeQuery, executeUpdate, getMetaData, getParameterMetaData, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setNull, setNull, setObject, setObject, setObject, setRef, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL

 

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

registerReturnParameter

void registerReturnParameter(int paramIndex,
                             int sqlType)
                             throws java.sql.SQLException
Use this method to register DML returning parameters. This method is used for fixed data types such as INTEGER and CHAR.
Parameters:
paramIndex - the first parameter is 1, the second is 2,...
sqlType - a value from java.sql.Types supported by TimesTen
Throws:
java.sql.SQLException - if a database access error occurs

registerReturnParameter

void registerReturnParameter(int paramIndex,
                             int sqlType,
                             int maxSize)
                             throws java.sql.SQLException
Use this method to register DML returning parameters. This method is used for variable size data types such as VARCHAR.
Parameters:
paramIndex - the first parameter is 1, the second is 2,...
sqlType - a value from java.sql.Types supported by TimesTen
maxSize - Maximum size of the parameter specified in bytes for BINARY/VARBINARY fields and in characters for CHAR/VARCHAR fields.
Throws:
java.sql.SQLException - if a database access error or truncation error occurs

getReturnResultSet

java.sql.ResultSet getReturnResultSet()
                                      throws java.sql.SQLException
Returns the DML returned parameters in the form of a ResultSet.
Returns:
ResultSet
Throws:
java.sql.SQLException - if a database access error occurs

Skip navigation links

Oracle® TimesTen In-Memory Database JDBC Extensions Java API Reference
Release 11.2.1

E13083-02


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