Package org.postgresql.jdbc
Class PgCallableStatement
- java.lang.Object
-
- org.postgresql.jdbc.PgStatement
-
- org.postgresql.jdbc.PgPreparedStatement
-
- org.postgresql.jdbc.PgCallableStatement
-
- All Implemented Interfaces:
java.lang.AutoCloseable
,java.sql.CallableStatement
,java.sql.PreparedStatement
,java.sql.Statement
,java.sql.Wrapper
,BaseStatement
,PGStatement
class PgCallableStatement extends PgPreparedStatement implements java.sql.CallableStatement
-
-
Nested Class Summary
-
Nested classes/interfaces inherited from class org.postgresql.jdbc.PgStatement
PgStatement.StatementResultHandler
-
-
Field Summary
Fields Modifier and Type Field Description protected java.lang.Object[]
callResult
private int[]
functionReturnType
private boolean
isFunction
private int
lastIndex
private boolean
returnTypeSet
private int[]
testReturn
-
Fields inherited from class org.postgresql.jdbc.PgPreparedStatement
preparedParameters, preparedQuery
-
Fields inherited from class org.postgresql.jdbc.PgStatement
adaptiveFetch, batchParameters, batchStatements, concurrency, connection, fetchdirection, fetchSize, firstUnclosedResult, generatedKeys, maxFieldSize, maxrows, mPrepareThreshold, replaceProcessingEnabled, result, resultsettype, timeout, wantsGeneratedKeysAlways, wantsGeneratedKeysOnce, warnings
-
Fields inherited from interface org.postgresql.PGStatement
DATE_NEGATIVE_INFINITY, DATE_NEGATIVE_SMALLER_INFINITY, DATE_POSITIVE_INFINITY, DATE_POSITIVE_SMALLER_INFINITY
-
-
Constructor Summary
Constructors Constructor Description PgCallableStatement(PgConnection connection, java.lang.String sql, int rsType, int rsConcurrency, int rsHoldability)
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description protected java.lang.Object
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 java.lang.Object
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)
private java.lang.Object
getCallResult(int parameterIndex)
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.io.InputStream inputStream)
void
setBlob(java.lang.String parameterName, java.io.InputStream inputStream, long length)
void
setBlob(java.lang.String parameterName, java.sql.Blob x)
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.io.Reader reader)
void
setClob(java.lang.String parameterName, java.io.Reader reader, long length)
void
setClob(java.lang.String parameterName, java.sql.Clob x)
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.io.Reader reader)
void
setNClob(java.lang.String parameterName, java.io.Reader reader, long length)
void
setNClob(java.lang.String parameterName, java.sql.NClob value)
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()
-
Methods inherited from class org.postgresql.jdbc.PgPreparedStatement
addBatch, addBatch, bindBytes, bindLiteral, clearParameters, closeImpl, createBlob, createParameterMetaData, execute, execute, executeBatch, executeLargeUpdate, executeQuery, executeQuery, executeUpdate, getMetaData, getParameterMetaData, isOneShotQuery, isUseServerPrepare, maximumNumberOfParameters, 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
-
Methods inherited from class org.postgresql.jdbc.PgStatement
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, getAdaptiveFetch, getConnection, getFetchDirection, getFetchingCursorName, getFetchSize, getForceBinaryTransfer, getGeneratedKeys, getLargeMaxRows, getLargeUpdateCount, getLastOID, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getPGConnection, getPrepareThreshold, getQueryTimeout, getQueryTimeoutMs, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getSingleResultSet, getTimestampUtils, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, isWrapperFor, setAdaptiveFetch, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setPrepareThreshold, setQueryTimeout, setQueryTimeoutMs, setUseServerPrepare, unwrap, wantsHoldableResultSet, wantsScrollableResultSet
-
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
-
Methods inherited from interface java.sql.PreparedStatement
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
-
Methods inherited from interface java.sql.Statement
addBatch, cancel, clearBatch, clearWarnings, close, closeOnCompletion, enquoteIdentifier, enquoteLiteral, enquoteNCharLiteral, 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, isSimpleIdentifier, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout
-
-
-
-
Constructor Detail
-
PgCallableStatement
PgCallableStatement(PgConnection connection, java.lang.String sql, int rsType, int rsConcurrency, int rsHoldability) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
-
Method Detail
-
executeUpdate
public int executeUpdate() throws java.sql.SQLException
- Specified by:
executeUpdate
in interfacejava.sql.PreparedStatement
- Overrides:
executeUpdate
in classPgPreparedStatement
- Throws:
java.sql.SQLException
-
getObject
public java.lang.Object getObject(int i, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws java.sql.SQLException
- Specified by:
getObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getObject
public java.lang.Object getObject(java.lang.String s, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws java.sql.SQLException
- Specified by:
getObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
executeWithFlags
public boolean executeWithFlags(int flags) throws java.sql.SQLException
Description copied from interface:BaseStatement
Execute a prepared query, passing additional query flags.- Specified by:
executeWithFlags
in interfaceBaseStatement
- Overrides:
executeWithFlags
in classPgPreparedStatement
- Parameters:
flags
- additionalQueryExecutor
flags for execution; these are bitwise-ORed into the default flags.- Returns:
- true if there is a result set
- Throws:
java.sql.SQLException
- if something goes wrong.
-
registerOutParameter
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
- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Parameters:
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 value- Throws:
java.sql.SQLException
- if a database-access error occurs.
-
wasNull
public boolean wasNull() throws java.sql.SQLException
- Specified by:
wasNull
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getString
public java.lang.String getString(int parameterIndex) throws java.sql.SQLException
- Specified by:
getString
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getBoolean
public boolean getBoolean(int parameterIndex) throws java.sql.SQLException
- Specified by:
getBoolean
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getByte
public byte getByte(int parameterIndex) throws java.sql.SQLException
- Specified by:
getByte
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getShort
public short getShort(int parameterIndex) throws java.sql.SQLException
- Specified by:
getShort
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getInt
public int getInt(int parameterIndex) throws java.sql.SQLException
- Specified by:
getInt
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getLong
public long getLong(int parameterIndex) throws java.sql.SQLException
- Specified by:
getLong
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getFloat
public float getFloat(int parameterIndex) throws java.sql.SQLException
- Specified by:
getFloat
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getDouble
public double getDouble(int parameterIndex) throws java.sql.SQLException
- Specified by:
getDouble
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getBigDecimal
public java.math.BigDecimal getBigDecimal(int parameterIndex, int scale) throws java.sql.SQLException
- Specified by:
getBigDecimal
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getBytes
public byte[] getBytes(int parameterIndex) throws java.sql.SQLException
- Specified by:
getBytes
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getDate
public java.sql.Date getDate(int parameterIndex) throws java.sql.SQLException
- Specified by:
getDate
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getTime
public java.sql.Time getTime(int parameterIndex) throws java.sql.SQLException
- Specified by:
getTime
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getTimestamp
public java.sql.Timestamp getTimestamp(int parameterIndex) throws java.sql.SQLException
- Specified by:
getTimestamp
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getObject
public java.lang.Object getObject(int parameterIndex) throws java.sql.SQLException
- Specified by:
getObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
checkIndex
protected java.lang.Object checkIndex(int parameterIndex, int type1, int type2, java.lang.String getName) throws java.sql.SQLException
helperfunction for the getXXX calls to check isFunction and index == 1 Compare BOTH type fields against the return type.- Parameters:
parameterIndex
- parameter index (1-based)type1
- type 1type2
- type 2getName
- getter name- Throws:
java.sql.SQLException
- if something goes wrong
-
checkIndex
protected java.lang.Object checkIndex(int parameterIndex, int type, java.lang.String getName) throws java.sql.SQLException
Helper function for the getXXX calls to check isFunction and index == 1.- Parameters:
parameterIndex
- parameter index (1-based)type
- typegetName
- getter name- Throws:
java.sql.SQLException
- if given index is not valid
-
getCallResult
private java.lang.Object getCallResult(int parameterIndex) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
createBatchHandler
protected BatchResultHandler createBatchHandler(Query[] queries, ParameterList[] parameterLists)
- Overrides:
createBatchHandler
in classPgStatement
-
getArray
public java.sql.Array getArray(int i) throws java.sql.SQLException
- Specified by:
getArray
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getBigDecimal
public java.math.BigDecimal getBigDecimal(int parameterIndex) throws java.sql.SQLException
- Specified by:
getBigDecimal
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getBlob
public java.sql.Blob getBlob(int i) throws java.sql.SQLException
- Specified by:
getBlob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getClob
public java.sql.Clob getClob(int i) throws java.sql.SQLException
- Specified by:
getClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getObjectImpl
public java.lang.Object getObjectImpl(int i, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
getRef
public java.sql.Ref getRef(int i) throws java.sql.SQLException
- Specified by:
getRef
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getDate
public java.sql.Date getDate(int i, java.util.Calendar cal) throws java.sql.SQLException
- Specified by:
getDate
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getTime
public java.sql.Time getTime(int i, java.util.Calendar cal) throws java.sql.SQLException
- Specified by:
getTime
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getTimestamp
public java.sql.Timestamp getTimestamp(int i, java.util.Calendar cal) throws java.sql.SQLException
- Specified by:
getTimestamp
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
registerOutParameter
public void registerOutParameter(int parameterIndex, int sqlType, java.lang.String typeName) throws java.sql.SQLException
- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setObject
public void setObject(java.lang.String parameterName, java.lang.Object x, java.sql.SQLType targetSqlType, int scaleOrLength) throws java.sql.SQLException
- Specified by:
setObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setObject
public void setObject(java.lang.String parameterName, java.lang.Object x, java.sql.SQLType targetSqlType) throws java.sql.SQLException
- Specified by:
setObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
registerOutParameter
public void registerOutParameter(int parameterIndex, java.sql.SQLType sqlType) throws java.sql.SQLException
- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
registerOutParameter
public void registerOutParameter(int parameterIndex, java.sql.SQLType sqlType, int scale) throws java.sql.SQLException
- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
registerOutParameter
public void registerOutParameter(int parameterIndex, java.sql.SQLType sqlType, java.lang.String typeName) throws java.sql.SQLException
- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
registerOutParameter
public void registerOutParameter(java.lang.String parameterName, java.sql.SQLType sqlType) throws java.sql.SQLException
- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
registerOutParameter
public void registerOutParameter(java.lang.String parameterName, java.sql.SQLType sqlType, int scale) throws java.sql.SQLException
- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
registerOutParameter
public void registerOutParameter(java.lang.String parameterName, java.sql.SQLType sqlType, java.lang.String typeName) throws java.sql.SQLException
- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getRowId
public java.sql.RowId getRowId(int parameterIndex) throws java.sql.SQLException
- Specified by:
getRowId
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getRowId
public java.sql.RowId getRowId(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getRowId
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setRowId
public void setRowId(java.lang.String parameterName, java.sql.RowId x) throws java.sql.SQLException
- Specified by:
setRowId
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setNString
public void setNString(java.lang.String parameterName, java.lang.String value) throws java.sql.SQLException
- Specified by:
setNString
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setNCharacterStream
public void setNCharacterStream(java.lang.String parameterName, java.io.Reader value, long length) throws java.sql.SQLException
- Specified by:
setNCharacterStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setNCharacterStream
public void setNCharacterStream(java.lang.String parameterName, java.io.Reader value) throws java.sql.SQLException
- Specified by:
setNCharacterStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setCharacterStream
public void setCharacterStream(java.lang.String parameterName, java.io.Reader value, long length) throws java.sql.SQLException
- Specified by:
setCharacterStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setCharacterStream
public void setCharacterStream(java.lang.String parameterName, java.io.Reader value) throws java.sql.SQLException
- Specified by:
setCharacterStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setBinaryStream
public void setBinaryStream(java.lang.String parameterName, java.io.InputStream value, long length) throws java.sql.SQLException
- Specified by:
setBinaryStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setBinaryStream
public void setBinaryStream(java.lang.String parameterName, java.io.InputStream value) throws java.sql.SQLException
- Specified by:
setBinaryStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setAsciiStream
public void setAsciiStream(java.lang.String parameterName, java.io.InputStream value, long length) throws java.sql.SQLException
- Specified by:
setAsciiStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setAsciiStream
public void setAsciiStream(java.lang.String parameterName, java.io.InputStream value) throws java.sql.SQLException
- Specified by:
setAsciiStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setNClob
public void setNClob(java.lang.String parameterName, java.sql.NClob value) throws java.sql.SQLException
- Specified by:
setNClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setClob
public void setClob(java.lang.String parameterName, java.io.Reader reader, long length) throws java.sql.SQLException
- Specified by:
setClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setClob
public void setClob(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException
- Specified by:
setClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setBlob
public void setBlob(java.lang.String parameterName, java.io.InputStream inputStream, long length) throws java.sql.SQLException
- Specified by:
setBlob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setBlob
public void setBlob(java.lang.String parameterName, java.io.InputStream inputStream) throws java.sql.SQLException
- Specified by:
setBlob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setBlob
public void setBlob(java.lang.String parameterName, java.sql.Blob x) throws java.sql.SQLException
- Specified by:
setBlob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setClob
public void setClob(java.lang.String parameterName, java.sql.Clob x) throws java.sql.SQLException
- Specified by:
setClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setNClob
public void setNClob(java.lang.String parameterName, java.io.Reader reader, long length) throws java.sql.SQLException
- Specified by:
setNClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setNClob
public void setNClob(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException
- Specified by:
setNClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getNClob
public java.sql.NClob getNClob(int parameterIndex) throws java.sql.SQLException
- Specified by:
getNClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getNClob
public java.sql.NClob getNClob(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getNClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setSQLXML
public void setSQLXML(java.lang.String parameterName, java.sql.SQLXML xmlObject) throws java.sql.SQLException
- Specified by:
setSQLXML
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getSQLXML
public java.sql.SQLXML getSQLXML(int parameterIndex) throws java.sql.SQLException
- Specified by:
getSQLXML
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getSQLXML
public java.sql.SQLXML getSQLXML(java.lang.String parameterIndex) throws java.sql.SQLException
- Specified by:
getSQLXML
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getNString
public java.lang.String getNString(int parameterIndex) throws java.sql.SQLException
- Specified by:
getNString
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getNString
public java.lang.String getNString(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getNString
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getNCharacterStream
public java.io.Reader getNCharacterStream(int parameterIndex) throws java.sql.SQLException
- Specified by:
getNCharacterStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getNCharacterStream
public java.io.Reader getNCharacterStream(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getNCharacterStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getCharacterStream
public java.io.Reader getCharacterStream(int parameterIndex) throws java.sql.SQLException
- Specified by:
getCharacterStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getCharacterStream
public java.io.Reader getCharacterStream(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getCharacterStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getObject
public <T> T getObject(int parameterIndex, java.lang.Class<T> type) throws java.sql.SQLException
- Specified by:
getObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getObject
public <T> T getObject(java.lang.String parameterName, java.lang.Class<T> type) throws java.sql.SQLException
- Specified by:
getObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
registerOutParameter
public void registerOutParameter(java.lang.String parameterName, int sqlType) throws java.sql.SQLException
- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
registerOutParameter
public void registerOutParameter(java.lang.String parameterName, int sqlType, int scale) throws java.sql.SQLException
- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
registerOutParameter
public void registerOutParameter(java.lang.String parameterName, int sqlType, java.lang.String typeName) throws java.sql.SQLException
- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getURL
public java.net.URL getURL(int parameterIndex) throws java.sql.SQLException
- Specified by:
getURL
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setURL
public void setURL(java.lang.String parameterName, java.net.URL val) throws java.sql.SQLException
- Specified by:
setURL
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setNull
public void setNull(java.lang.String parameterName, int sqlType) throws java.sql.SQLException
- Specified by:
setNull
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setBoolean
public void setBoolean(java.lang.String parameterName, boolean x) throws java.sql.SQLException
- Specified by:
setBoolean
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setByte
public void setByte(java.lang.String parameterName, byte x) throws java.sql.SQLException
- Specified by:
setByte
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setShort
public void setShort(java.lang.String parameterName, short x) throws java.sql.SQLException
- Specified by:
setShort
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setInt
public void setInt(java.lang.String parameterName, int x) throws java.sql.SQLException
- Specified by:
setInt
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setLong
public void setLong(java.lang.String parameterName, long x) throws java.sql.SQLException
- Specified by:
setLong
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setFloat
public void setFloat(java.lang.String parameterName, float x) throws java.sql.SQLException
- Specified by:
setFloat
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setDouble
public void setDouble(java.lang.String parameterName, double x) throws java.sql.SQLException
- Specified by:
setDouble
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setBigDecimal
public void setBigDecimal(java.lang.String parameterName, java.math.BigDecimal x) throws java.sql.SQLException
- Specified by:
setBigDecimal
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setString
public void setString(java.lang.String parameterName, java.lang.String x) throws java.sql.SQLException
- Specified by:
setString
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setBytes
public void setBytes(java.lang.String parameterName, byte[] x) throws java.sql.SQLException
- Specified by:
setBytes
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setDate
public void setDate(java.lang.String parameterName, java.sql.Date x) throws java.sql.SQLException
- Specified by:
setDate
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setTime
public void setTime(java.lang.String parameterName, java.sql.Time x) throws java.sql.SQLException
- Specified by:
setTime
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setTimestamp
public void setTimestamp(java.lang.String parameterName, java.sql.Timestamp x) throws java.sql.SQLException
- Specified by:
setTimestamp
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setAsciiStream
public void setAsciiStream(java.lang.String parameterName, java.io.InputStream x, int length) throws java.sql.SQLException
- Specified by:
setAsciiStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setBinaryStream
public void setBinaryStream(java.lang.String parameterName, java.io.InputStream x, int length) throws java.sql.SQLException
- Specified by:
setBinaryStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setObject
public void setObject(java.lang.String parameterName, java.lang.Object x, int targetSqlType, int scale) throws java.sql.SQLException
- Specified by:
setObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setObject
public void setObject(java.lang.String parameterName, java.lang.Object x, int targetSqlType) throws java.sql.SQLException
- Specified by:
setObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setObject
public void setObject(java.lang.String parameterName, java.lang.Object x) throws java.sql.SQLException
- Specified by:
setObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setCharacterStream
public void setCharacterStream(java.lang.String parameterName, java.io.Reader reader, int length) throws java.sql.SQLException
- Specified by:
setCharacterStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setDate
public void setDate(java.lang.String parameterName, java.sql.Date x, java.util.Calendar cal) throws java.sql.SQLException
- Specified by:
setDate
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setTime
public void setTime(java.lang.String parameterName, java.sql.Time x, java.util.Calendar cal) throws java.sql.SQLException
- Specified by:
setTime
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setTimestamp
public void setTimestamp(java.lang.String parameterName, java.sql.Timestamp x, java.util.Calendar cal) throws java.sql.SQLException
- Specified by:
setTimestamp
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setNull
public void setNull(java.lang.String parameterName, int sqlType, java.lang.String typeName) throws java.sql.SQLException
- Specified by:
setNull
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getString
public java.lang.String getString(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getString
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getBoolean
public boolean getBoolean(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getBoolean
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getByte
public byte getByte(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getByte
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getShort
public short getShort(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getShort
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getInt
public int getInt(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getInt
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getLong
public long getLong(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getLong
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getFloat
public float getFloat(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getFloat
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getDouble
public double getDouble(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getDouble
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getBytes
public byte[] getBytes(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getBytes
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getDate
public java.sql.Date getDate(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getDate
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getTime
public java.sql.Time getTime(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getTime
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getTimestamp
public java.sql.Timestamp getTimestamp(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getTimestamp
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getObject
public java.lang.Object getObject(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getBigDecimal
public java.math.BigDecimal getBigDecimal(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getBigDecimal
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getObjectImpl
public java.lang.Object getObjectImpl(java.lang.String parameterName, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
getRef
public java.sql.Ref getRef(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getRef
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getBlob
public java.sql.Blob getBlob(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getBlob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getClob
public java.sql.Clob getClob(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getClob
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getArray
public java.sql.Array getArray(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getArray
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getDate
public java.sql.Date getDate(java.lang.String parameterName, java.util.Calendar cal) throws java.sql.SQLException
- Specified by:
getDate
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getTime
public java.sql.Time getTime(java.lang.String parameterName, java.util.Calendar cal) throws java.sql.SQLException
- Specified by:
getTime
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getTimestamp
public java.sql.Timestamp getTimestamp(java.lang.String parameterName, java.util.Calendar cal) throws java.sql.SQLException
- Specified by:
getTimestamp
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getURL
public java.net.URL getURL(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getURL
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
registerOutParameter
public void registerOutParameter(int parameterIndex, int sqlType, int scale) throws java.sql.SQLException
- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
-