class PgCallableStatement extends PgPreparedStatement implements java.sql.CallableStatement
PgStatement.StatementResultHandler
Modifier and Type | Field and Description |
---|---|
protected java.lang.Object[] |
callResult |
private int[] |
functionReturnType |
private boolean |
isFunction |
private int |
lastIndex |
private boolean |
returnTypeSet |
private int[] |
testReturn |
preparedParameters, preparedQuery
batchParameters, batchStatements, concurrency, connection, fetchdirection, fetchSize, firstUnclosedResult, generatedKeys, maxFieldSize, maxrows, mPrepareThreshold, replaceProcessingEnabled, result, resultsettype, timeout, wantsGeneratedKeysAlways, wantsGeneratedKeysOnce, warnings
CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO
DATE_NEGATIVE_INFINITY, DATE_NEGATIVE_SMALLER_INFINITY, DATE_POSITIVE_INFINITY, DATE_POSITIVE_SMALLER_INFINITY
Constructor and Description |
---|
PgCallableStatement(PgConnection connection,
java.lang.String sql,
int rsType,
int rsConcurrency,
int rsHoldability) |
Modifier and Type | Method and Description |
---|---|
private void |
checkIndex(int parameterIndex) |
private void |
checkIndex(int parameterIndex,
boolean fetchingData)
Helper function for the getXXX calls to check isFunction and index == 1.
|
protected void |
checkIndex(int parameterIndex,
int type1,
int type2,
java.lang.String getName)
helperfunction for the getXXX calls to check isFunction and index == 1 Compare BOTH type fields
against the return type.
|
protected void |
checkIndex(int parameterIndex,
int type,
java.lang.String getName)
Helper function for the getXXX calls to check isFunction and index == 1.
|
protected BatchResultHandler |
createBatchHandler(Query[] queries,
ParameterList[] parameterLists) |
int |
executeUpdate() |
boolean |
executeWithFlags(int flags)
Execute a prepared query, passing additional query flags.
|
java.sql.Array |
getArray(int i) |
java.sql.Array |
getArray(java.lang.String parameterName) |
java.math.BigDecimal |
getBigDecimal(int parameterIndex) |
java.math.BigDecimal |
getBigDecimal(int parameterIndex,
int scale) |
java.math.BigDecimal |
getBigDecimal(java.lang.String parameterName) |
java.sql.Blob |
getBlob(int i) |
java.sql.Blob |
getBlob(java.lang.String parameterName) |
boolean |
getBoolean(int parameterIndex) |
boolean |
getBoolean(java.lang.String parameterName) |
byte |
getByte(int parameterIndex) |
byte |
getByte(java.lang.String parameterName) |
byte[] |
getBytes(int parameterIndex) |
byte[] |
getBytes(java.lang.String parameterName) |
java.io.Reader |
getCharacterStream(int parameterIndex) |
java.io.Reader |
getCharacterStream(java.lang.String parameterName) |
java.sql.Clob |
getClob(int i) |
java.sql.Clob |
getClob(java.lang.String parameterName) |
java.sql.Date |
getDate(int parameterIndex) |
java.sql.Date |
getDate(int i,
java.util.Calendar cal) |
java.sql.Date |
getDate(java.lang.String parameterName) |
java.sql.Date |
getDate(java.lang.String parameterName,
java.util.Calendar cal) |
double |
getDouble(int parameterIndex) |
double |
getDouble(java.lang.String parameterName) |
float |
getFloat(int parameterIndex) |
float |
getFloat(java.lang.String parameterName) |
int |
getInt(int parameterIndex) |
int |
getInt(java.lang.String parameterName) |
long |
getLong(int parameterIndex) |
long |
getLong(java.lang.String parameterName) |
java.io.Reader |
getNCharacterStream(int parameterIndex) |
java.io.Reader |
getNCharacterStream(java.lang.String parameterName) |
java.sql.NClob |
getNClob(int parameterIndex) |
java.sql.NClob |
getNClob(java.lang.String parameterName) |
java.lang.String |
getNString(int parameterIndex) |
java.lang.String |
getNString(java.lang.String parameterName) |
java.lang.Object |
getObject(int parameterIndex) |
<T> T |
getObject(int parameterIndex,
java.lang.Class<T> type) |
java.lang.Object |
getObject(int i,
java.util.Map<java.lang.String,java.lang.Class<?>> map) |
java.lang.Object |
getObject(java.lang.String parameterName) |
<T> T |
getObject(java.lang.String parameterName,
java.lang.Class<T> type) |
java.lang.Object |
getObject(java.lang.String s,
java.util.Map<java.lang.String,java.lang.Class<?>> map) |
java.lang.Object |
getObjectImpl(int i,
java.util.Map<java.lang.String,java.lang.Class<?>> map) |
java.lang.Object |
getObjectImpl(java.lang.String parameterName,
java.util.Map<java.lang.String,java.lang.Class<?>> map) |
java.sql.Ref |
getRef(int i) |
java.sql.Ref |
getRef(java.lang.String parameterName) |
java.sql.RowId |
getRowId(int parameterIndex) |
java.sql.RowId |
getRowId(java.lang.String parameterName) |
short |
getShort(int parameterIndex) |
short |
getShort(java.lang.String parameterName) |
java.sql.SQLXML |
getSQLXML(int parameterIndex) |
java.sql.SQLXML |
getSQLXML(java.lang.String parameterIndex) |
java.lang.String |
getString(int parameterIndex) |
java.lang.String |
getString(java.lang.String parameterName) |
java.sql.Time |
getTime(int parameterIndex) |
java.sql.Time |
getTime(int i,
java.util.Calendar cal) |
java.sql.Time |
getTime(java.lang.String parameterName) |
java.sql.Time |
getTime(java.lang.String parameterName,
java.util.Calendar cal) |
java.sql.Timestamp |
getTimestamp(int parameterIndex) |
java.sql.Timestamp |
getTimestamp(int i,
java.util.Calendar cal) |
java.sql.Timestamp |
getTimestamp(java.lang.String parameterName) |
java.sql.Timestamp |
getTimestamp(java.lang.String parameterName,
java.util.Calendar cal) |
java.net.URL |
getURL(int parameterIndex) |
java.net.URL |
getURL(java.lang.String parameterName) |
void |
registerOutParameter(int parameterIndex,
int sqlType) |
void |
registerOutParameter(int parameterIndex,
int sqlType,
int scale) |
void |
registerOutParameter(int parameterIndex,
int sqlType,
java.lang.String typeName) |
void |
registerOutParameter(int parameterIndex,
java.sql.SQLType sqlType) |
void |
registerOutParameter(int parameterIndex,
java.sql.SQLType sqlType,
int scale) |
void |
registerOutParameter(int parameterIndex,
java.sql.SQLType sqlType,
java.lang.String typeName) |
void |
registerOutParameter(java.lang.String parameterName,
int sqlType) |
void |
registerOutParameter(java.lang.String parameterName,
int sqlType,
int scale) |
void |
registerOutParameter(java.lang.String parameterName,
int sqlType,
java.lang.String typeName) |
void |
registerOutParameter(java.lang.String parameterName,
java.sql.SQLType sqlType) |
void |
registerOutParameter(java.lang.String parameterName,
java.sql.SQLType sqlType,
int scale) |
void |
registerOutParameter(java.lang.String parameterName,
java.sql.SQLType sqlType,
java.lang.String typeName) |
void |
setAsciiStream(java.lang.String parameterName,
java.io.InputStream value) |
void |
setAsciiStream(java.lang.String parameterName,
java.io.InputStream x,
int length) |
void |
setAsciiStream(java.lang.String parameterName,
java.io.InputStream value,
long length) |
void |
setBigDecimal(java.lang.String parameterName,
java.math.BigDecimal x) |
void |
setBinaryStream(java.lang.String parameterName,
java.io.InputStream value) |
void |
setBinaryStream(java.lang.String parameterName,
java.io.InputStream x,
int length) |
void |
setBinaryStream(java.lang.String parameterName,
java.io.InputStream value,
long length) |
void |
setBlob(java.lang.String parameterName,
java.sql.Blob x) |
void |
setBlob(java.lang.String parameterName,
java.io.InputStream inputStream) |
void |
setBlob(java.lang.String parameterName,
java.io.InputStream inputStream,
long length) |
void |
setBoolean(java.lang.String parameterName,
boolean x) |
void |
setByte(java.lang.String parameterName,
byte x) |
void |
setBytes(java.lang.String parameterName,
byte[] x) |
void |
setCharacterStream(java.lang.String parameterName,
java.io.Reader value) |
void |
setCharacterStream(java.lang.String parameterName,
java.io.Reader reader,
int length) |
void |
setCharacterStream(java.lang.String parameterName,
java.io.Reader value,
long length) |
void |
setClob(java.lang.String parameterName,
java.sql.Clob x) |
void |
setClob(java.lang.String parameterName,
java.io.Reader reader) |
void |
setClob(java.lang.String parameterName,
java.io.Reader reader,
long length) |
void |
setDate(java.lang.String parameterName,
java.sql.Date x) |
void |
setDate(java.lang.String parameterName,
java.sql.Date x,
java.util.Calendar cal) |
void |
setDouble(java.lang.String parameterName,
double x) |
void |
setFloat(java.lang.String parameterName,
float x) |
void |
setInt(java.lang.String parameterName,
int x) |
void |
setLong(java.lang.String parameterName,
long x) |
void |
setNCharacterStream(java.lang.String parameterName,
java.io.Reader value) |
void |
setNCharacterStream(java.lang.String parameterName,
java.io.Reader value,
long length) |
void |
setNClob(java.lang.String parameterName,
java.sql.NClob value) |
void |
setNClob(java.lang.String parameterName,
java.io.Reader reader) |
void |
setNClob(java.lang.String parameterName,
java.io.Reader reader,
long length) |
void |
setNString(java.lang.String parameterName,
java.lang.String value) |
void |
setNull(java.lang.String parameterName,
int sqlType) |
void |
setNull(java.lang.String parameterName,
int sqlType,
java.lang.String typeName) |
void |
setObject(java.lang.String parameterName,
java.lang.Object x) |
void |
setObject(java.lang.String parameterName,
java.lang.Object x,
int targetSqlType) |
void |
setObject(java.lang.String parameterName,
java.lang.Object x,
int targetSqlType,
int scale) |
void |
setObject(java.lang.String parameterName,
java.lang.Object x,
java.sql.SQLType targetSqlType) |
void |
setObject(java.lang.String parameterName,
java.lang.Object x,
java.sql.SQLType targetSqlType,
int scaleOrLength) |
void |
setRowId(java.lang.String parameterName,
java.sql.RowId x) |
void |
setShort(java.lang.String parameterName,
short x) |
void |
setSQLXML(java.lang.String parameterName,
java.sql.SQLXML xmlObject) |
void |
setString(java.lang.String parameterName,
java.lang.String x) |
void |
setTime(java.lang.String parameterName,
java.sql.Time x) |
void |
setTime(java.lang.String parameterName,
java.sql.Time x,
java.util.Calendar cal) |
void |
setTimestamp(java.lang.String parameterName,
java.sql.Timestamp x) |
void |
setTimestamp(java.lang.String parameterName,
java.sql.Timestamp x,
java.util.Calendar cal) |
void |
setURL(java.lang.String parameterName,
java.net.URL val) |
boolean |
wasNull() |
addBatch, addBatch, bindBytes, bindLiteral, clearParameters, closeImpl, createBlob, createParameterMetaData, execute, execute, executeBatch, executeLargeUpdate, executeQuery, executeQuery, executeUpdate, getMetaData, getParameterMetaData, isOneShotQuery, isUseServerPrepare, 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, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL, toString, transformQueriesAndParameters
addWarning, cancel, checkClosed, checkCompletion, checkNoResultUpdate, clearBatch, clearWarnings, close, closeForNextExecution, closeOnCompletion, createDriverResultSet, createResultSet, execute, execute, execute, execute, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeUpdate, executeUpdate, executeUpdate, executeWithFlags, executeWithFlags, getConnection, getFetchDirection, getFetchingCursorName, getFetchSize, getForceBinaryTransfer, getGeneratedKeys, getLargeMaxRows, getLargeUpdateCount, getLastOID, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getPGConnection, getPrepareThreshold, getQueryTimeout, getQueryTimeoutMs, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getSingleResultSet, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, isWrapperFor, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setPrepareThreshold, setQueryTimeout, setQueryTimeoutMs, setUseServerPrepare, unwrap, wantsHoldableResultSet, wantsScrollableResultSet
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
addBatch, clearParameters, execute, executeLargeUpdate, executeQuery, 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
private boolean isFunction
private int[] functionReturnType
private int[] testReturn
private boolean returnTypeSet
protected java.lang.Object[] callResult
private int lastIndex
PgCallableStatement(PgConnection connection, java.lang.String sql, int rsType, int rsConcurrency, int rsHoldability) throws java.sql.SQLException
java.sql.SQLException
public int executeUpdate() throws java.sql.SQLException
executeUpdate
in interface java.sql.PreparedStatement
executeUpdate
in class PgPreparedStatement
java.sql.SQLException
public java.lang.Object getObject(int i, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws java.sql.SQLException
getObject
in interface java.sql.CallableStatement
java.sql.SQLException
public java.lang.Object getObject(java.lang.String s, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws java.sql.SQLException
getObject
in interface java.sql.CallableStatement
java.sql.SQLException
public boolean executeWithFlags(int flags) throws java.sql.SQLException
BaseStatement
executeWithFlags
in interface BaseStatement
executeWithFlags
in class PgPreparedStatement
flags
- additional QueryExecutor
flags for execution; these are bitwise-ORed into
the default flags.java.sql.SQLException
- if something goes wrong.public void registerOutParameter(int parameterIndex, int sqlType) throws java.sql.SQLException
Before executing a stored procedure call you must explicitly call registerOutParameter to register the java.sql.Type of each out parameter.
Note: When reading the value of an out parameter, you must use the getXXX method whose Java type XXX corresponds to the parameter's registered SQL type.
ONLY 1 RETURN PARAMETER if {?= call ..} syntax is used
registerOutParameter
in interface java.sql.CallableStatement
parameterIndex
- the first parameter is 1, the second is 2,...sqlType
- SQL type code defined by java.sql.Types; for parameters of type Numeric or
Decimal use the version of registerOutParameter that accepts a scale valuejava.sql.SQLException
- if a database-access error occurs.public boolean wasNull() throws java.sql.SQLException
wasNull
in interface java.sql.CallableStatement
java.sql.SQLException
public java.lang.String getString(int parameterIndex) throws java.sql.SQLException
getString
in interface java.sql.CallableStatement
java.sql.SQLException
public boolean getBoolean(int parameterIndex) throws java.sql.SQLException
getBoolean
in interface java.sql.CallableStatement
java.sql.SQLException
public byte getByte(int parameterIndex) throws java.sql.SQLException
getByte
in interface java.sql.CallableStatement
java.sql.SQLException
public short getShort(int parameterIndex) throws java.sql.SQLException
getShort
in interface java.sql.CallableStatement
java.sql.SQLException
public int getInt(int parameterIndex) throws java.sql.SQLException
getInt
in interface java.sql.CallableStatement
java.sql.SQLException
public long getLong(int parameterIndex) throws java.sql.SQLException
getLong
in interface java.sql.CallableStatement
java.sql.SQLException
public float getFloat(int parameterIndex) throws java.sql.SQLException
getFloat
in interface java.sql.CallableStatement
java.sql.SQLException
public double getDouble(int parameterIndex) throws java.sql.SQLException
getDouble
in interface java.sql.CallableStatement
java.sql.SQLException
public java.math.BigDecimal getBigDecimal(int parameterIndex, int scale) throws java.sql.SQLException
getBigDecimal
in interface java.sql.CallableStatement
java.sql.SQLException
public byte[] getBytes(int parameterIndex) throws java.sql.SQLException
getBytes
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Date getDate(int parameterIndex) throws java.sql.SQLException
getDate
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Time getTime(int parameterIndex) throws java.sql.SQLException
getTime
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Timestamp getTimestamp(int parameterIndex) throws java.sql.SQLException
getTimestamp
in interface java.sql.CallableStatement
java.sql.SQLException
public java.lang.Object getObject(int parameterIndex) throws java.sql.SQLException
getObject
in interface java.sql.CallableStatement
java.sql.SQLException
protected void checkIndex(int parameterIndex, int type1, int type2, java.lang.String getName) throws java.sql.SQLException
parameterIndex
- parameter index (1-based)type1
- type 1type2
- type 2getName
- getter namejava.sql.SQLException
- if something goes wrongprotected void checkIndex(int parameterIndex, int type, java.lang.String getName) throws java.sql.SQLException
parameterIndex
- parameter index (1-based)type
- typegetName
- getter namejava.sql.SQLException
- if given index is not validprivate void checkIndex(int parameterIndex) throws java.sql.SQLException
java.sql.SQLException
private void checkIndex(int parameterIndex, boolean fetchingData) throws java.sql.SQLException
parameterIndex
- index of getXXX (index) check to make sure is a function and index == 1fetchingData
- fetching datajava.sql.SQLException
protected BatchResultHandler createBatchHandler(Query[] queries, ParameterList[] parameterLists)
createBatchHandler
in class PgStatement
public java.sql.Array getArray(int i) throws java.sql.SQLException
getArray
in interface java.sql.CallableStatement
java.sql.SQLException
public java.math.BigDecimal getBigDecimal(int parameterIndex) throws java.sql.SQLException
getBigDecimal
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Blob getBlob(int i) throws java.sql.SQLException
getBlob
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Clob getClob(int i) throws java.sql.SQLException
getClob
in interface java.sql.CallableStatement
java.sql.SQLException
public java.lang.Object getObjectImpl(int i, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws java.sql.SQLException
java.sql.SQLException
public java.sql.Ref getRef(int i) throws java.sql.SQLException
getRef
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Date getDate(int i, java.util.Calendar cal) throws java.sql.SQLException
getDate
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Time getTime(int i, java.util.Calendar cal) throws java.sql.SQLException
getTime
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Timestamp getTimestamp(int i, java.util.Calendar cal) throws java.sql.SQLException
getTimestamp
in interface java.sql.CallableStatement
java.sql.SQLException
public void registerOutParameter(int parameterIndex, int sqlType, java.lang.String typeName) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
java.sql.SQLException
public void setObject(java.lang.String parameterName, java.lang.Object x, java.sql.SQLType targetSqlType, int scaleOrLength) throws java.sql.SQLException
setObject
in interface java.sql.CallableStatement
java.sql.SQLException
public void setObject(java.lang.String parameterName, java.lang.Object x, java.sql.SQLType targetSqlType) throws java.sql.SQLException
setObject
in interface java.sql.CallableStatement
java.sql.SQLException
public void registerOutParameter(int parameterIndex, java.sql.SQLType sqlType) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
java.sql.SQLException
public void registerOutParameter(int parameterIndex, java.sql.SQLType sqlType, int scale) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
java.sql.SQLException
public void registerOutParameter(int parameterIndex, java.sql.SQLType sqlType, java.lang.String typeName) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
java.sql.SQLException
public void registerOutParameter(java.lang.String parameterName, java.sql.SQLType sqlType) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
java.sql.SQLException
public void registerOutParameter(java.lang.String parameterName, java.sql.SQLType sqlType, int scale) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
java.sql.SQLException
public void registerOutParameter(java.lang.String parameterName, java.sql.SQLType sqlType, java.lang.String typeName) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.RowId getRowId(int parameterIndex) throws java.sql.SQLException
getRowId
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.RowId getRowId(java.lang.String parameterName) throws java.sql.SQLException
getRowId
in interface java.sql.CallableStatement
java.sql.SQLException
public void setRowId(java.lang.String parameterName, java.sql.RowId x) throws java.sql.SQLException
setRowId
in interface java.sql.CallableStatement
java.sql.SQLException
public void setNString(java.lang.String parameterName, java.lang.String value) throws java.sql.SQLException
setNString
in interface java.sql.CallableStatement
java.sql.SQLException
public void setNCharacterStream(java.lang.String parameterName, java.io.Reader value, long length) throws java.sql.SQLException
setNCharacterStream
in interface java.sql.CallableStatement
java.sql.SQLException
public void setNCharacterStream(java.lang.String parameterName, java.io.Reader value) throws java.sql.SQLException
setNCharacterStream
in interface java.sql.CallableStatement
java.sql.SQLException
public void setCharacterStream(java.lang.String parameterName, java.io.Reader value, long length) throws java.sql.SQLException
setCharacterStream
in interface java.sql.CallableStatement
java.sql.SQLException
public void setCharacterStream(java.lang.String parameterName, java.io.Reader value) throws java.sql.SQLException
setCharacterStream
in interface java.sql.CallableStatement
java.sql.SQLException
public void setBinaryStream(java.lang.String parameterName, java.io.InputStream value, long length) throws java.sql.SQLException
setBinaryStream
in interface java.sql.CallableStatement
java.sql.SQLException
public void setBinaryStream(java.lang.String parameterName, java.io.InputStream value) throws java.sql.SQLException
setBinaryStream
in interface java.sql.CallableStatement
java.sql.SQLException
public void setAsciiStream(java.lang.String parameterName, java.io.InputStream value, long length) throws java.sql.SQLException
setAsciiStream
in interface java.sql.CallableStatement
java.sql.SQLException
public void setAsciiStream(java.lang.String parameterName, java.io.InputStream value) throws java.sql.SQLException
setAsciiStream
in interface java.sql.CallableStatement
java.sql.SQLException
public void setNClob(java.lang.String parameterName, java.sql.NClob value) throws java.sql.SQLException
setNClob
in interface java.sql.CallableStatement
java.sql.SQLException
public void setClob(java.lang.String parameterName, java.io.Reader reader, long length) throws java.sql.SQLException
setClob
in interface java.sql.CallableStatement
java.sql.SQLException
public void setClob(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException
setClob
in interface java.sql.CallableStatement
java.sql.SQLException
public void setBlob(java.lang.String parameterName, java.io.InputStream inputStream, long length) throws java.sql.SQLException
setBlob
in interface java.sql.CallableStatement
java.sql.SQLException
public void setBlob(java.lang.String parameterName, java.io.InputStream inputStream) throws java.sql.SQLException
setBlob
in interface java.sql.CallableStatement
java.sql.SQLException
public void setBlob(java.lang.String parameterName, java.sql.Blob x) throws java.sql.SQLException
setBlob
in interface java.sql.CallableStatement
java.sql.SQLException
public void setClob(java.lang.String parameterName, java.sql.Clob x) throws java.sql.SQLException
setClob
in interface java.sql.CallableStatement
java.sql.SQLException
public void setNClob(java.lang.String parameterName, java.io.Reader reader, long length) throws java.sql.SQLException
setNClob
in interface java.sql.CallableStatement
java.sql.SQLException
public void setNClob(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException
setNClob
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.NClob getNClob(int parameterIndex) throws java.sql.SQLException
getNClob
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.NClob getNClob(java.lang.String parameterName) throws java.sql.SQLException
getNClob
in interface java.sql.CallableStatement
java.sql.SQLException
public void setSQLXML(java.lang.String parameterName, java.sql.SQLXML xmlObject) throws java.sql.SQLException
setSQLXML
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.SQLXML getSQLXML(int parameterIndex) throws java.sql.SQLException
getSQLXML
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.SQLXML getSQLXML(java.lang.String parameterIndex) throws java.sql.SQLException
getSQLXML
in interface java.sql.CallableStatement
java.sql.SQLException
public java.lang.String getNString(int parameterIndex) throws java.sql.SQLException
getNString
in interface java.sql.CallableStatement
java.sql.SQLException
public java.lang.String getNString(java.lang.String parameterName) throws java.sql.SQLException
getNString
in interface java.sql.CallableStatement
java.sql.SQLException
public java.io.Reader getNCharacterStream(int parameterIndex) throws java.sql.SQLException
getNCharacterStream
in interface java.sql.CallableStatement
java.sql.SQLException
public java.io.Reader getNCharacterStream(java.lang.String parameterName) throws java.sql.SQLException
getNCharacterStream
in interface java.sql.CallableStatement
java.sql.SQLException
public java.io.Reader getCharacterStream(int parameterIndex) throws java.sql.SQLException
getCharacterStream
in interface java.sql.CallableStatement
java.sql.SQLException
public java.io.Reader getCharacterStream(java.lang.String parameterName) throws java.sql.SQLException
getCharacterStream
in interface java.sql.CallableStatement
java.sql.SQLException
public <T> T getObject(int parameterIndex, java.lang.Class<T> type) throws java.sql.SQLException
getObject
in interface java.sql.CallableStatement
java.sql.SQLException
public <T> T getObject(java.lang.String parameterName, java.lang.Class<T> type) throws java.sql.SQLException
getObject
in interface java.sql.CallableStatement
java.sql.SQLException
public void registerOutParameter(java.lang.String parameterName, int sqlType) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
java.sql.SQLException
public void registerOutParameter(java.lang.String parameterName, int sqlType, int scale) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
java.sql.SQLException
public void registerOutParameter(java.lang.String parameterName, int sqlType, java.lang.String typeName) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
java.sql.SQLException
public java.net.URL getURL(int parameterIndex) throws java.sql.SQLException
getURL
in interface java.sql.CallableStatement
java.sql.SQLException
public void setURL(java.lang.String parameterName, java.net.URL val) throws java.sql.SQLException
setURL
in interface java.sql.CallableStatement
java.sql.SQLException
public void setNull(java.lang.String parameterName, int sqlType) throws java.sql.SQLException
setNull
in interface java.sql.CallableStatement
java.sql.SQLException
public void setBoolean(java.lang.String parameterName, boolean x) throws java.sql.SQLException
setBoolean
in interface java.sql.CallableStatement
java.sql.SQLException
public void setByte(java.lang.String parameterName, byte x) throws java.sql.SQLException
setByte
in interface java.sql.CallableStatement
java.sql.SQLException
public void setShort(java.lang.String parameterName, short x) throws java.sql.SQLException
setShort
in interface java.sql.CallableStatement
java.sql.SQLException
public void setInt(java.lang.String parameterName, int x) throws java.sql.SQLException
setInt
in interface java.sql.CallableStatement
java.sql.SQLException
public void setLong(java.lang.String parameterName, long x) throws java.sql.SQLException
setLong
in interface java.sql.CallableStatement
java.sql.SQLException
public void setFloat(java.lang.String parameterName, float x) throws java.sql.SQLException
setFloat
in interface java.sql.CallableStatement
java.sql.SQLException
public void setDouble(java.lang.String parameterName, double x) throws java.sql.SQLException
setDouble
in interface java.sql.CallableStatement
java.sql.SQLException
public void setBigDecimal(java.lang.String parameterName, java.math.BigDecimal x) throws java.sql.SQLException
setBigDecimal
in interface java.sql.CallableStatement
java.sql.SQLException
public void setString(java.lang.String parameterName, java.lang.String x) throws java.sql.SQLException
setString
in interface java.sql.CallableStatement
java.sql.SQLException
public void setBytes(java.lang.String parameterName, byte[] x) throws java.sql.SQLException
setBytes
in interface java.sql.CallableStatement
java.sql.SQLException
public void setDate(java.lang.String parameterName, java.sql.Date x) throws java.sql.SQLException
setDate
in interface java.sql.CallableStatement
java.sql.SQLException
public void setTime(java.lang.String parameterName, java.sql.Time x) throws java.sql.SQLException
setTime
in interface java.sql.CallableStatement
java.sql.SQLException
public void setTimestamp(java.lang.String parameterName, java.sql.Timestamp x) throws java.sql.SQLException
setTimestamp
in interface java.sql.CallableStatement
java.sql.SQLException
public void setAsciiStream(java.lang.String parameterName, java.io.InputStream x, int length) throws java.sql.SQLException
setAsciiStream
in interface java.sql.CallableStatement
java.sql.SQLException
public void setBinaryStream(java.lang.String parameterName, java.io.InputStream x, int length) throws java.sql.SQLException
setBinaryStream
in interface java.sql.CallableStatement
java.sql.SQLException
public void setObject(java.lang.String parameterName, java.lang.Object x, int targetSqlType, int scale) throws java.sql.SQLException
setObject
in interface java.sql.CallableStatement
java.sql.SQLException
public void setObject(java.lang.String parameterName, java.lang.Object x, int targetSqlType) throws java.sql.SQLException
setObject
in interface java.sql.CallableStatement
java.sql.SQLException
public void setObject(java.lang.String parameterName, java.lang.Object x) throws java.sql.SQLException
setObject
in interface java.sql.CallableStatement
java.sql.SQLException
public void setCharacterStream(java.lang.String parameterName, java.io.Reader reader, int length) throws java.sql.SQLException
setCharacterStream
in interface java.sql.CallableStatement
java.sql.SQLException
public void setDate(java.lang.String parameterName, java.sql.Date x, java.util.Calendar cal) throws java.sql.SQLException
setDate
in interface java.sql.CallableStatement
java.sql.SQLException
public void setTime(java.lang.String parameterName, java.sql.Time x, java.util.Calendar cal) throws java.sql.SQLException
setTime
in interface java.sql.CallableStatement
java.sql.SQLException
public void setTimestamp(java.lang.String parameterName, java.sql.Timestamp x, java.util.Calendar cal) throws java.sql.SQLException
setTimestamp
in interface java.sql.CallableStatement
java.sql.SQLException
public void setNull(java.lang.String parameterName, int sqlType, java.lang.String typeName) throws java.sql.SQLException
setNull
in interface java.sql.CallableStatement
java.sql.SQLException
public java.lang.String getString(java.lang.String parameterName) throws java.sql.SQLException
getString
in interface java.sql.CallableStatement
java.sql.SQLException
public boolean getBoolean(java.lang.String parameterName) throws java.sql.SQLException
getBoolean
in interface java.sql.CallableStatement
java.sql.SQLException
public byte getByte(java.lang.String parameterName) throws java.sql.SQLException
getByte
in interface java.sql.CallableStatement
java.sql.SQLException
public short getShort(java.lang.String parameterName) throws java.sql.SQLException
getShort
in interface java.sql.CallableStatement
java.sql.SQLException
public int getInt(java.lang.String parameterName) throws java.sql.SQLException
getInt
in interface java.sql.CallableStatement
java.sql.SQLException
public long getLong(java.lang.String parameterName) throws java.sql.SQLException
getLong
in interface java.sql.CallableStatement
java.sql.SQLException
public float getFloat(java.lang.String parameterName) throws java.sql.SQLException
getFloat
in interface java.sql.CallableStatement
java.sql.SQLException
public double getDouble(java.lang.String parameterName) throws java.sql.SQLException
getDouble
in interface java.sql.CallableStatement
java.sql.SQLException
public byte[] getBytes(java.lang.String parameterName) throws java.sql.SQLException
getBytes
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Date getDate(java.lang.String parameterName) throws java.sql.SQLException
getDate
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Time getTime(java.lang.String parameterName) throws java.sql.SQLException
getTime
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Timestamp getTimestamp(java.lang.String parameterName) throws java.sql.SQLException
getTimestamp
in interface java.sql.CallableStatement
java.sql.SQLException
public java.lang.Object getObject(java.lang.String parameterName) throws java.sql.SQLException
getObject
in interface java.sql.CallableStatement
java.sql.SQLException
public java.math.BigDecimal getBigDecimal(java.lang.String parameterName) throws java.sql.SQLException
getBigDecimal
in interface java.sql.CallableStatement
java.sql.SQLException
public java.lang.Object getObjectImpl(java.lang.String parameterName, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws java.sql.SQLException
java.sql.SQLException
public java.sql.Ref getRef(java.lang.String parameterName) throws java.sql.SQLException
getRef
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Blob getBlob(java.lang.String parameterName) throws java.sql.SQLException
getBlob
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Clob getClob(java.lang.String parameterName) throws java.sql.SQLException
getClob
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Array getArray(java.lang.String parameterName) throws java.sql.SQLException
getArray
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Date getDate(java.lang.String parameterName, java.util.Calendar cal) throws java.sql.SQLException
getDate
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Time getTime(java.lang.String parameterName, java.util.Calendar cal) throws java.sql.SQLException
getTime
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Timestamp getTimestamp(java.lang.String parameterName, java.util.Calendar cal) throws java.sql.SQLException
getTimestamp
in interface java.sql.CallableStatement
java.sql.SQLException
public java.net.URL getURL(java.lang.String parameterName) throws java.sql.SQLException
getURL
in interface java.sql.CallableStatement
java.sql.SQLException
public void registerOutParameter(int parameterIndex, int sqlType, int scale) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
java.sql.SQLException