Skip navigation links

com.timesten.jdbc
Interface TimesTenCallableStatement

All Superinterfaces:

java.sql.CallableStatement, java.sql.PreparedStatement, java.sql.Statement, TimesTenPreparedStatement, java.sql.Wrapper

public interface TimesTenCallableStatement

extends java.sql.CallableStatement, TimesTenPreparedStatement

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	getCursor(int parameterIndex) Get PL/SQL REF CURSOR as ResultSet
java.sql.ResultSet	getCursor(java.lang.String parameterName) Get PL/SQL REF CURSOR as ResultSet
java.lang.Object	getPlsqlIndexTable(int paramIndex) Get the value of a PLSQL index table parameter as a Java array.
java.lang.Object	getPlsqlIndexTable(int paramIndex, java.lang.Class<?> primitiveType) Get the value of a PLSQL index table parameter as a primitive array.
void	registerIndexTableOutParameter(int paramIndex, int maxLen, int elemSqlType, int elemMaxLen) Register a PL/SQL index-by table as an OUT parameter
void	registerOutParameter(int paramIndex, int sqlType, int ignore, int maxLength) Register out parameter.

Methods inherited from interface java.sql.CallableStatement

getArray, getArray, getBigDecimal, getBigDecimal, getBigDecimal, getBlob, getBlob, getBoolean, getBoolean, getByte, getByte, getBytes, getBytes, getCharacterStream, getCharacterStream, getClob, getClob, getDate, getDate, getDate, getDate, getDouble, getDouble, getFloat, getFloat, getInt, getInt, getLong, getLong, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getObject, getObject, getObject, getObject, getRef, getRef, getRowId, getRowId, getShort, getShort, getSQLXML, getSQLXML, getString, getString, getTime, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getTimestamp, getURL, getURL, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, 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, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp, setURL, wasNull

Methods inherited from interface com.timesten.jdbc.TimesTenPreparedStatement

getReturnResultSet, registerReturnParameter, registerReturnParameter, setPlsqlIndexTable

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

getCursor

java.sql.ResultSet getCursor(int parameterIndex)
                             throws java.sql.SQLException

Get PL/SQL REF CURSOR as ResultSet

Parameters:

parameterIndex - the first parameter is 1, the second is 2, and so on

Returns:

ResultSet

Throws:

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

See Also:

ResultSet

getCursor

java.sql.ResultSet getCursor(java.lang.String parameterName)
                             throws java.sql.SQLException

Get PL/SQL REF CURSOR as ResultSet

Parameters:

parameterName - the name of the parameter

Returns:

ResultSet

Throws:

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

See Also:

ResultSet

registerOutParameter

void registerOutParameter(int paramIndex,
                          int sqlType,
                          int ignore,
                          int maxLength)
                          throws java.sql.SQLException

Register out parameter. This extension lets you specify maximum length for variable length fields such as CHAR, VARCHAR.

Parameters:

paramIndex - the first parameter is 1, the second is 2, and so on

sqlType - the SQL type code defined by java.sql.Types.

ignore - Not used.

maxLength - maximum length of the column, specified in bytes for BINARY/VARBINARY fields and in characters for CHAR/VARCHAR fields.

Throws:

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

registerIndexTableOutParameter

void registerIndexTableOutParameter(int paramIndex,
                                    int maxLen,
                                    int elemSqlType,
                                    int elemMaxLen)
                                    throws java.sql.SQLException

Register a PL/SQL index-by table as an OUT parameter

Parameters:

paramIndex - the first parameter is 1, the second is 2, and so on

maxLen - the maximum possible number of elements.

elemSqlType - index table element SQL type (as defined in java.sql.Types or TimesTenTypes).

elemMaxLen - maximum length of the element. If not specified, maximum length allowed for that type is used.

Throws:

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

getPlsqlIndexTable

java.lang.Object getPlsqlIndexTable(int paramIndex)
                                    throws java.sql.SQLException

Get the value of a PLSQL index table parameter as a Java array. The type of the Java array will be the default Java object type corresponding to the element's SQL type, following the mapping for built-in types specified in the JDBC specification

Parameters:

paramIndex - the first parameter is 1, the second is 2, and so on

Returns:

Object holding the parameter value.

Throws:

java.sql.SQLException - if a database access or conversion error occurs

getPlsqlIndexTable

java.lang.Object getPlsqlIndexTable(int paramIndex,
                                    java.lang.Class<?> primitiveType)
                                    throws java.sql.SQLException

Get the value of a PLSQL index table parameter as a primitive array. 'primitiveType' specifies the return array type.

Parameters:

paramIndex - the first parameter is 1, the second is 2, and so on

primitiveType - is a primitive type class. For example, Double.TYPE

Returns:

An Object holding the parameter value.

Throws:

java.sql.SQLException - if a database access or conversion error occurs

Skip navigation links