public interface TimesTenPreparedStatement extends TimesTenStatement, java.sql.PreparedStatement
Modifier and Type | Interface and Description |
---|---|
static class |
TimesTenPreparedStatement.PassThroughType
Various passthrough types
|
Modifier and Type | Method and Description |
---|---|
TimesTenPreparedStatement.PassThroughType |
getPassThroughType()
Returns PassThrough type
|
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.
|
void |
setPlsqlIndexTable(int paramIndex, java.lang.Object arrayData, int maxLen, int curLen, int elemSqlType, int elemMaxLen)
Binds a PL/SQL index-by table parameter in the IN parameter mode.
|
getLobPrefetchSize, getQueryTimeThreshold, setLobPrefetchSize, setQueryTimeThreshold
addBatch, clearParameters, execute, executeLargeUpdate, 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, setObject, setObject, setRef, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL
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
void registerReturnParameter(int paramIndex, int sqlType) throws java.sql.SQLException
paramIndex
- the first parameter is 1, the second is 2,...sqlType
- a value from java.sql.Types supported by TimesTenjava.sql.SQLException
- if a database access error occursvoid registerReturnParameter(int paramIndex, int sqlType, int maxSize) throws java.sql.SQLException
paramIndex
- the first parameter is 1, the second is 2,...sqlType
- a value from java.sql.Types supported by TimesTenmaxSize
- Maximum size of the parameter specified in bytes for BINARY/VARBINARY fields and in characters for CHAR/VARCHAR fields.java.sql.SQLException
- if a database access error or truncation error occursjava.sql.ResultSet getReturnResultSet() throws java.sql.SQLException
java.sql.SQLException
- if a database access error occursvoid setPlsqlIndexTable(int paramIndex, java.lang.Object arrayData, int maxLen, int curLen, int elemSqlType, int elemMaxLen) throws java.sql.SQLException
paramIndex
- This argument indicates the parameter position within the statement. The first parameter is 1, the second is 2, ...arrayData
- This argument is an array of values to be bound to the PL/SQL index-by table parameter. The value is of type java.lang.Object, and the value can be a Java primitive type array such as int[] or a Java object array such as BigDecimal[].maxLen
- This argument specifies the maximum table length of the index-by table bind value which defines the maximum possible curLen for batch updates. For standalone binds, maxLen should use the same value as curLen. This argument is required.curLen
- This argument specifies the actual size of the index-by table bind value in arrayData. If the curLen value is smaller than the size of arrayData, only the curLen number of table elements is passed to the database. If the curLen value is larger than the size of arrayData, the entire arrayData is sent to the database.elemSqlType
- This argument specifies the index-by table element type based on the values defined in the TimesTenTypes class.elemMaxLen
- This argument specifies the index-table element maximum length in case the element type is CHAR, VARCHAR, or RAW. This value is ignored for other types. A value of 0 for elemMaxLen would inidicate the driver to calculate the elemMaxLen based on the actual length of data bound. For a non zero value if the data bound is greater than elemMaxLen it is truncated.java.sql.SQLException
- if a database access error occursTimesTenPreparedStatement.PassThroughType getPassThroughType() throws java.sql.SQLException
java.sql.SQLException
- If a database error occurs