Class CallableStatementWrapper
- java.lang.Object
-
- com.gargoylesoftware.base.resource.jdbc.StatementWrapper
-
- com.gargoylesoftware.base.resource.jdbc.PreparedStatementWrapper
-
- com.gargoylesoftware.base.resource.jdbc.CallableStatementWrapper
-
- All Implemented Interfaces:
java.lang.AutoCloseable
,java.sql.CallableStatement
,java.sql.PreparedStatement
,java.sql.Statement
,java.sql.Wrapper
public final class CallableStatementWrapper extends PreparedStatementWrapper implements java.sql.CallableStatement
The interface used to execute SQL stored procedures. JDBC provides a stored procedure SQL escape syntax that allows stored procedures to be called in a standard way for all RDBMSs. This escape syntax has one form that includes a result parameter and one that does not. If used, the result parameter must be registered as an OUT parameter. The other parameters can be used for input, output or both. Parameters are referred to sequentially, by number, with the first parameter being 1.{?= call <procedure-name>[<arg1>,<arg2>, ...]} {call <procedure-name>[<arg1>,<arg2>, ...]}
IN parameter values are set using the set methods inherited from PreparedStatement. The type of all OUT parameters must be registered prior to executing the stored procedure; their values are retrieved after execution via the
get
methods provided here.A
CallableStatement
can return one ResultSet or multipleResultSet
objects. MultipleResultSet
objects are handled using operations inherited from Statement.For maximum portability, a call's
ResultSet
objects and update counts should be processed prior to getting the values of output parameters.Methods that are new in the JDBC 2.0 API are marked "Since 1.2."
- Version:
- $Revision: 1.4 $
-
-
Field Summary
Fields Modifier and Type Field Description private java.sql.CallableStatement
delegate_
-
Constructor Summary
Constructors Constructor Description CallableStatementWrapper(java.sql.CallableStatement statement)
Create a wrapper
-
Method Summary
All Methods Instance Methods Concrete Methods Deprecated Methods Modifier and Type Method Description java.sql.Array
getArray(int i)
Gets the value of a JDBCARRAY
parameter as an Array object in the Java programming language.java.sql.Array
getArray(java.lang.String parameterName)
Retrieves the value of a JDBCARRAY
parameter as anArray
object in the Java programming language.java.math.BigDecimal
getBigDecimal(int parameterIndex)
Gets the value of a JDBCNUMERIC
parameter as ajava.math.BigDecimal
object with as many digits to the right of the decimal point as the value contains.java.math.BigDecimal
getBigDecimal(int parameterIndex, int scale)
Deprecated.java.math.BigDecimal
getBigDecimal(java.lang.String parameterName)
Retrieves the value of a JDBCNUMERIC
parameter as ajava.math.BigDecimal
object with as many digits to the right of the decimal point as the value contains.java.sql.Blob
getBlob(int i)
Gets the value of a JDBCBLOB
parameter as a Blob\ object in the Java programming language.java.sql.Blob
getBlob(java.lang.String parameterName)
Retrieves the value of a JDBCBLOB
parameter as aBlob
object in the Java programming language.boolean
getBoolean(int parameterIndex)
Gets the value of a JDBCBIT
parameter as aboolean
in the Java programming language.boolean
getBoolean(java.lang.String parameterName)
Retrieves the value of a JDBCBIT
parameter as aboolean
in the Java programming language.byte
getByte(int parameterIndex)
Gets the value of a JDBCTINYINT
parameter as abyte
in the Java programming language.byte
getByte(java.lang.String parameterName)
Retrieves the value of a JDBCTINYINT
parameter as abyte
in the Java programming language.byte[]
getBytes(int parameterIndex)
Gets the value of a JDBCBINARY
orVARBINARY
parameter as an array ofbyte
values in the Java programming language.byte[]
getBytes(java.lang.String parameterName)
Retrieves the value of a JDBCBINARY
orVARBINARY
parameter as an array ofbyte
values in the Java programming language.java.io.Reader
getCharacterStream(int parameterIndex)
java.io.Reader
getCharacterStream(java.lang.String parameterName)
java.sql.Clob
getClob(int i)
Gets the value of a JDBCCLOB
parameter as aClob
object in the Java programming language.java.sql.Clob
getClob(java.lang.String parameterName)
Retrieves the value of a JDBCCLOB
parameter as aClob
object in the Java programming language.java.sql.Date
getDate(int parameterIndex)
Gets the value of a JDBCDATE
parameter as ajava.sql.Date
object.java.sql.Date
getDate(int parameterIndex, java.util.Calendar cal)
Gets the value of a JDBCDATE
parameter as ajava.sql.Date
object, using the givenCalendar
object to construct the date.java.sql.Date
getDate(java.lang.String parameterName)
Retrieves the value of a JDBCDATE
parameter as ajava.sql.Date
object.java.sql.Date
getDate(java.lang.String parameterName, java.util.Calendar cal)
Retrieves the value of a JDBCDATE
parameter as ajava.sql.Date
object, using the givenCalendar
object to construct the date.double
getDouble(int parameterIndex)
Gets the value of a JDBCDOUBLE
parameter as adouble
in the Java programming language.double
getDouble(java.lang.String parameterName)
Retrieves the value of a JDBCDOUBLE
parameter as adouble
in the Java programming language.float
getFloat(int parameterIndex)
Gets the value of a JDBCFLOAT
parameter as afloat
in the Java programming language.float
getFloat(java.lang.String parameterName)
Retrieves the value of a JDBCFLOAT
parameter as afloat
in the Java programming language.int
getInt(int parameterIndex)
Gets the value of a JDBCINTEGER
parameter as anint
in the Java programming language.int
getInt(java.lang.String parameterName)
Retrieves the value of a JDBCINTEGER
parameter as anint
in the Java programming language.long
getLong(int parameterIndex)
Gets the value of a JDBCBIGINT
parameter as along
in the Java programming language.long
getLong(java.lang.String parameterName)
Retrieves the value of a JDBCBIGINT
parameter as along
in the Java programming language.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)
Gets the value of a parameter as anObject
in the Java programming language.<T> T
getObject(int columnIndex, java.lang.Class<T> arg0)
java.lang.Object
getObject(int i, java.util.Map map)
Returns an object representing the value of OUT parameteri
and usesmap
for the custom mapping of the parameter value.java.lang.Object
getObject(java.lang.String parameterName)
Retrieves the value of a parameter as anObject
in the Java programming language.<T> T
getObject(java.lang.String parameterName, java.lang.Class<T> arg0)
java.lang.Object
getObject(java.lang.String parameterName, java.util.Map map)
Returns an object representing the value of OUT parameteri
and usesmap
for the custom mapping of the parameter value.java.sql.Ref
getRef(int i)
Gets the value of a JDBCREF(<structured-type>)
parameter as a Ref object in the Java programming language.java.sql.Ref
getRef(java.lang.String parameterName)
Retrieves the value of a JDBCREF(<structured-type>)
parameter as aRef
object in the Java programming language.java.sql.RowId
getRowId(int parameterIndex)
java.sql.RowId
getRowId(java.lang.String parameterName)
short
getShort(int parameterIndex)
Gets the value of a JDBCSMALLINT
parameter as ashort
in the Java programming language.short
getShort(java.lang.String parameterName)
Retrieves the value of a JDBCSMALLINT
parameter as ashort
in the Java programming language.java.sql.SQLXML
getSQLXML(int parameterIndex)
java.sql.SQLXML
getSQLXML(java.lang.String parameterName)
java.lang.String
getString(int parameterIndex)
Retrieves the value of a JDBCCHAR
,VARCHAR
, orLONGVARCHAR
parameter as aString
in the Java programming language.java.lang.String
getString(java.lang.String parameterName)
Retrieves the value of a JDBCCHAR
,VARCHAR
, orLONGVARCHAR
parameter as aString
in the Java programming language.java.sql.Time
getTime(int parameterIndex)
Get the value of a JDBCTIME
parameter as ajava.sql.Time
object.java.sql.Time
getTime(int parameterIndex, java.util.Calendar cal)
Gets the value of a JDBCTIME
parameter as ajava.sql.Time
object, using the givenCalendar
object to construct the time.java.sql.Time
getTime(java.lang.String parameterName)
Retrieves the value of a JDBCTIME
parameter as ajava.sql.Time
object.java.sql.Time
getTime(java.lang.String parameterName, java.util.Calendar cal)
Retrieves the value of a JDBCTIME
parameter as ajava.sql.Time
object, using the givenCalendar
object to construct the time.java.sql.Timestamp
getTimestamp(int parameterIndex)
Gets the value of a JDBCTIMESTAMP
parameter as ajava.sql.Timestamp
object.java.sql.Timestamp
getTimestamp(int parameterIndex, java.util.Calendar cal)
Gets the value of a JDBCTIMESTAMP
parameter as ajava.sql.Timestamp
object, using the givenCalendar
object to construct theTimestamp
object.java.sql.Timestamp
getTimestamp(java.lang.String parameterName)
Retrieves the value of a JDBCTIMESTAMP
parameter as ajava.sql.Timestamp
object.java.sql.Timestamp
getTimestamp(java.lang.String parameterName, java.util.Calendar cal)
Retrieves the value of a JDBCTIMESTAMP
parameter as ajava.sql.Timestamp
object, using the givenCalendar
object to construct theTimestamp
object.java.net.URL
getURL(int parameterIndex)
Retrieves the value of the designated JDBCDATALINK
parameter as ajava.net.URL
object.java.net.URL
getURL(java.lang.String parameterName)
Retrieves the value of a JDBCDATALINK
parameter as ajava.net.URL
object.void
registerOutParameter(int parameterIndex, int sqlType)
Registers the OUT parameter in ordinal positionparameterIndex
to the JDBC typesqlType
.void
registerOutParameter(int parameterIndex, int sqlType, int scale)
Registers the parameter in ordinal positionparameterIndex
to be of JDBC typesqlType
.void
registerOutParameter(int paramIndex, int sqlType, java.lang.String typeName)
Registers the designated output parameter.void
registerOutParameter(java.lang.String parameterName, int sqlType)
Registers the OUT parameter namedparameterName
to the JDBC typesqlType
.void
registerOutParameter(java.lang.String parameterName, int sqlType, int scale)
Registers the parameter namedparameterName
to be of JDBC typesqlType
.void
registerOutParameter(java.lang.String parameterName, int sqlType, java.lang.String typeName)
Registers the designated output parameter.void
setAsciiStream(java.lang.String parameterName, java.io.InputStream x)
void
setAsciiStream(java.lang.String parameterName, java.io.InputStream x, int length)
Sets the designated parameter to the given input stream, which will have the specified number of bytes.void
setAsciiStream(java.lang.String parameterName, java.io.InputStream x, long length)
void
setBigDecimal(java.lang.String parameterName, java.math.BigDecimal x)
Sets the designated parameter to the givenjava.math.BigDecimal
value.void
setBinaryStream(java.lang.String parameterName, java.io.InputStream x)
void
setBinaryStream(java.lang.String parameterName, java.io.InputStream x, int length)
Sets the designated parameter to the given input stream, which will have the specified number of bytes.void
setBinaryStream(java.lang.String parameterName, java.io.InputStream x, 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)
Sets the designated parameter to the given Javaboolean
value.void
setByte(java.lang.String parameterName, byte x)
Sets the designated parameter to the given Javabyte
value.void
setBytes(java.lang.String parameterName, byte[] x)
Sets the designated parameter to the given Java array of bytes.void
setCharacterStream(java.lang.String parameterName, java.io.Reader reader)
void
setCharacterStream(java.lang.String parameterName, java.io.Reader reader, int length)
Sets the designated parameter to the givenReader
object, which is the given number of characters long.void
setCharacterStream(java.lang.String parameterName, java.io.Reader reader, 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)
Sets the designated parameter to the givenjava.sql.Date
value.void
setDate(java.lang.String parameterName, java.sql.Date x, java.util.Calendar cal)
Sets the designated parameter to the givenjava.sql.Date
value, using the givenCalendar
object.void
setDouble(java.lang.String parameterName, double x)
Sets the designated parameter to the given Javadouble
value.void
setFloat(java.lang.String parameterName, float x)
Sets the designated parameter to the given Javafloat
value.void
setInt(java.lang.String parameterName, int x)
Sets the designated parameter to the given Javaint
value.void
setLong(java.lang.String parameterName, long x)
Sets the designated parameter to the given Javalong
value.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)
Sets the designated parameter to SQLNULL
.void
setNull(java.lang.String parameterName, int sqlType, java.lang.String typeName)
Sets the designated parameter to SQLNULL
.void
setObject(java.lang.String parameterName, java.lang.Object x)
Sets the value of the designated parameter with the given object.void
setObject(java.lang.String parameterName, java.lang.Object x, int targetSqlType)
Sets the value of the designated parameter with the given object.void
setObject(java.lang.String parameterName, java.lang.Object x, int targetSqlType, int scale)
Sets the value of the designated parameter with the given object.void
setRowId(java.lang.String parameterName, java.sql.RowId x)
void
setShort(java.lang.String parameterName, short x)
Sets the designated parameter to the given Javashort
value.void
setSQLXML(java.lang.String parameterName, java.sql.SQLXML xmlObject)
void
setString(java.lang.String parameterName, java.lang.String x)
Sets the designated parameter to the given JavaString
value.void
setTime(java.lang.String parameterName, java.sql.Time x)
Sets the designated parameter to the givenjava.sql.Time
value.void
setTime(java.lang.String parameterName, java.sql.Time x, java.util.Calendar cal)
Sets the designated parameter to the givenjava.sql.Time
value, using the givenCalendar
object.void
setTimestamp(java.lang.String parameterName, java.sql.Timestamp x)
Sets the designated parameter to the givenjava.sql.Timestamp
value.void
setTimestamp(java.lang.String parameterName, java.sql.Timestamp x, java.util.Calendar cal)
Sets the designated parameter to the givenjava.sql.Timestamp
value, using the givenCalendar
object.void
setURL(java.lang.String parameterName, java.net.URL val)
Sets the designated parameter to the givenjava.net.URL
object.boolean
wasNull()
Indicates whether or not the last OUT parameter read had the value of SQLNULL
.-
Methods inherited from class com.gargoylesoftware.base.resource.jdbc.PreparedStatementWrapper
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 class com.gargoylesoftware.base.resource.jdbc.StatementWrapper
addBatch, cancel, checkIsOpen, clearBatch, clearWarnings, close, closeOnCompletion, execute, execute, execute, execute, executeBatch, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getDelegate, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, isWrapperFor, setConnection, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout, unwrap, wrapResultSet
-
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
-
Methods inherited from interface java.sql.CallableStatement
registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, setObject, setObject
-
Methods inherited from interface java.sql.PreparedStatement
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
-
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
-
-
-
-
Method Detail
-
getString
public final java.lang.String getString(int parameterIndex) throws java.sql.SQLException
Retrieves the value of a JDBCCHAR
,VARCHAR
, orLONGVARCHAR
parameter as aString
in the Java programming language.For the fixed-length type JDBC
CHAR
, theString
object returned has exactly the same value the JDBCCHAR
value had in the database, including any padding added by the database.- Specified by:
getString
in interfacejava.sql.CallableStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so on- Returns:
- the parameter value. If the value is SQL
NULL
, the result isnull
. - Throws:
java.sql.SQLException
- if a database access error occurs
-
getBoolean
public final boolean getBoolean(int parameterIndex) throws java.sql.SQLException
Gets the value of a JDBCBIT
parameter as aboolean
in the Java programming language.- Specified by:
getBoolean
in interfacejava.sql.CallableStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so on- Returns:
- the parameter value. If the value is SQL
NULL
, the result isfalse
. - Throws:
java.sql.SQLException
- if a database access error occurs
-
getByte
public final byte getByte(int parameterIndex) throws java.sql.SQLException
Gets the value of a JDBCTINYINT
parameter as abyte
in the Java programming language.- Specified by:
getByte
in interfacejava.sql.CallableStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so on- Returns:
- the parameter value. If the value is SQL
NULL
, the result is 0. - Throws:
java.sql.SQLException
- if a database access error occurs
-
getShort
public final short getShort(int parameterIndex) throws java.sql.SQLException
Gets the value of a JDBCSMALLINT
parameter as ashort
in the Java programming language.- Specified by:
getShort
in interfacejava.sql.CallableStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so on- Returns:
- the parameter value. If the value is SQL
NULL
, the result is 0. - Throws:
java.sql.SQLException
- if a database access error occurs
-
getInt
public final int getInt(int parameterIndex) throws java.sql.SQLException
Gets the value of a JDBCINTEGER
parameter as anint
in the Java programming language.- Specified by:
getInt
in interfacejava.sql.CallableStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so on- Returns:
- the parameter value. If the value is SQL
NULL
, the result is 0. - Throws:
java.sql.SQLException
- if a database access error occurs
-
getLong
public final long getLong(int parameterIndex) throws java.sql.SQLException
Gets the value of a JDBCBIGINT
parameter as along
in the Java programming language.- Specified by:
getLong
in interfacejava.sql.CallableStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so on- Returns:
- the parameter value. If the value is SQL
NULL
, the result is 0. - Throws:
java.sql.SQLException
- if a database access error occurs
-
getFloat
public final float getFloat(int parameterIndex) throws java.sql.SQLException
Gets the value of a JDBCFLOAT
parameter as afloat
in the Java programming language.- Specified by:
getFloat
in interfacejava.sql.CallableStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so on- Returns:
- the parameter value. If the value is SQL
NULL
, the result is 0. - Throws:
java.sql.SQLException
- if a database access error occurs
-
getDouble
public final double getDouble(int parameterIndex) throws java.sql.SQLException
Gets the value of a JDBCDOUBLE
parameter as adouble
in the Java programming language.- Specified by:
getDouble
in interfacejava.sql.CallableStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so on- Returns:
- the parameter value. If the value is SQL
NULL
, the result is 0. - Throws:
java.sql.SQLException
- if a database access error occurs
-
getBigDecimal
public final java.math.BigDecimal getBigDecimal(int parameterIndex, int scale) throws java.sql.SQLException
Deprecated.Gets the value of a JDBCNUMERIC
parameter as ajava.math.BigDecimal
object with scale digits to the right of the decimal point.- Specified by:
getBigDecimal
in interfacejava.sql.CallableStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so onscale
- the number of digits to the right of the decimal point- Returns:
- the parameter value. If the value is SQL
NULL
, the result isnull
. - Throws:
java.sql.SQLException
- if a database access error occurs
-
getBytes
public final byte[] getBytes(int parameterIndex) throws java.sql.SQLException
Gets the value of a JDBCBINARY
orVARBINARY
parameter as an array ofbyte
values in the Java programming language.- Specified by:
getBytes
in interfacejava.sql.CallableStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so on- Returns:
- the parameter value. If the value is SQL
NULL
, the result isnull
. - Throws:
java.sql.SQLException
- if a database access error occurs
-
getDate
public final java.sql.Date getDate(int parameterIndex) throws java.sql.SQLException
Gets the value of a JDBCDATE
parameter as ajava.sql.Date
object.- Specified by:
getDate
in interfacejava.sql.CallableStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so on- Returns:
- the parameter value. If the value is SQL
NULL
, the result isnull
. - Throws:
java.sql.SQLException
- if a database access error occurs
-
getTime
public final java.sql.Time getTime(int parameterIndex) throws java.sql.SQLException
Get the value of a JDBCTIME
parameter as ajava.sql.Time
object.- Specified by:
getTime
in interfacejava.sql.CallableStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so on- Returns:
- the parameter value. If the value is SQL
NULL
, the result isnull
. - Throws:
java.sql.SQLException
- if a database access error occurs
-
getTimestamp
public final java.sql.Timestamp getTimestamp(int parameterIndex) throws java.sql.SQLException
Gets the value of a JDBCTIMESTAMP
parameter as ajava.sql.Timestamp
object.- Specified by:
getTimestamp
in interfacejava.sql.CallableStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so on- Returns:
- the parameter value. If the value is SQL
NULL
, the result isnull
. - Throws:
java.sql.SQLException
- if a database access error occurs
-
getObject
public final java.lang.Object getObject(int parameterIndex) throws java.sql.SQLException
Gets the value of a parameter as anObject
in the Java programming language.This method returns a Java object whose type corresponds to the JDBC type that was registered for this parameter using the method
registerOutParameter
. By registering the target JDBC type asjava.sql.Types.OTHER
, this method can be used to read database-specific abstract data types.- Specified by:
getObject
in interfacejava.sql.CallableStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so on- Returns:
- A
java.lang.Object
holding the OUT parameter value. - Throws:
java.sql.SQLException
- if a database access error occurs
-
getBigDecimal
public final java.math.BigDecimal getBigDecimal(int parameterIndex) throws java.sql.SQLException
Gets the value of a JDBCNUMERIC
parameter as ajava.math.BigDecimal
object with as many digits to the right of the decimal point as the value contains.- Specified by:
getBigDecimal
in interfacejava.sql.CallableStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so on- Returns:
- the parameter value in full precision. If the value is SQL
NULL
, the result isnull
. - Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.2
-
getObject
public final java.lang.Object getObject(int i, java.util.Map map) throws java.sql.SQLException
Returns an object representing the value of OUT parameteri
and usesmap
for the custom mapping of the parameter value.This method returns a Java object whose type corresponds to the JDBC type that was registered for this parameter using the method
registerOutParameter
. By registering the target JDBC type asjava.sql.Types.OTHER
, this method can be used to read database-specific abstract data types.- Specified by:
getObject
in interfacejava.sql.CallableStatement
- Parameters:
i
- the first parameter is 1, the second is 2, and so onmap
- the mapping from SQL type names to Java classes- Returns:
- a
java.lang.Object
holding the OUT parameter value - Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.2
-
getRef
public final java.sql.Ref getRef(int i) throws java.sql.SQLException
Gets the value of a JDBCREF(<structured-type>)
parameter as a Ref object in the Java programming language.- Specified by:
getRef
in interfacejava.sql.CallableStatement
- Parameters:
i
- the first parameter is 1, the second is 2, and so on- Returns:
- the parameter value as a
Ref
object in the Java programming language. If the value was SQLNULL
, the valuenull
is returned. - Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.2
-
getBlob
public final java.sql.Blob getBlob(int i) throws java.sql.SQLException
Gets the value of a JDBCBLOB
parameter as a Blob\ object in the Java programming language.- Specified by:
getBlob
in interfacejava.sql.CallableStatement
- Parameters:
i
- the first parameter is 1, the second is 2, and so on- Returns:
- the parameter value as a
Blob
object in the Java programming language. If the value was SQLNULL
, the valuenull
is returned. - Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.2
-
getClob
public final java.sql.Clob getClob(int i) throws java.sql.SQLException
Gets the value of a JDBCCLOB
parameter as aClob
object in the Java programming language.- Specified by:
getClob
in interfacejava.sql.CallableStatement
- Parameters:
i
- the first parameter is 1, the second is 2, and so on- Returns:
- the parameter value as a
Clob
object in the Java programming language. If the value was SQLNULL
, the valuenull
is returned. - Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.2
-
getArray
public final java.sql.Array getArray(int i) throws java.sql.SQLException
Gets the value of a JDBCARRAY
parameter as an Array object in the Java programming language.- Specified by:
getArray
in interfacejava.sql.CallableStatement
- Parameters:
i
- the first parameter is 1, the second is 2, and so on- Returns:
- the parameter value as an
Array
object in the Java programming language. If the value was SQLNULL
, the valuenull
is returned. - Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.2
-
getDate
public final java.sql.Date getDate(int parameterIndex, java.util.Calendar cal) throws java.sql.SQLException
Gets the value of a JDBCDATE
parameter as ajava.sql.Date
object, using the givenCalendar
object to construct the date. With aCalendar
object, the driver can calculate the date taking into account a custom timezone and locale. If noCalendar
object is specified, the driver uses the default timezone and locale.- Specified by:
getDate
in interfacejava.sql.CallableStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so oncal
- theCalendar
object the driver will use to construct the date- Returns:
- the parameter value. If the value is SQL
NULL
, the result isnull
. - Throws:
java.sql.SQLException
- if a database access error occurs
-
getTime
public final java.sql.Time getTime(int parameterIndex, java.util.Calendar cal) throws java.sql.SQLException
Gets the value of a JDBCTIME
parameter as ajava.sql.Time
object, using the givenCalendar
object to construct the time. With aCalendar
object, the driver can calculate the time taking into account a custom timezone and locale. If noCalendar
object is specified, the driver uses the default timezone and locale.- Specified by:
getTime
in interfacejava.sql.CallableStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so oncal
- theCalendar
object the driver will use to construct the time- Returns:
- the parameter value; if the value is SQL
NULL
, the result isnull
. - Throws:
java.sql.SQLException
- if a database access error occurs
-
getTimestamp
public final java.sql.Timestamp getTimestamp(int parameterIndex, java.util.Calendar cal) throws java.sql.SQLException
Gets the value of a JDBCTIMESTAMP
parameter as ajava.sql.Timestamp
object, using the givenCalendar
object to construct theTimestamp
object. With aCalendar
object, the driver can calculate the timestamp taking into account a custom timezone and locale. If noCalendar
object is specified, the driver uses the default timezone and locale.- Specified by:
getTimestamp
in interfacejava.sql.CallableStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so oncal
- theCalendar
object the driver will use to construct the timestamp- Returns:
- the parameter value. If the value is SQL
NULL
, the result isnull
. - Throws:
java.sql.SQLException
- if a database access error occurs
-
registerOutParameter
public final void registerOutParameter(int parameterIndex, int sqlType) throws java.sql.SQLException
Registers the OUT parameter in ordinal positionparameterIndex
to the JDBC typesqlType
. All OUT parameters must be registered before a stored procedure is executed.The JDBC type specified by
sqlType
for an OUT parameter determines the Java type that must be used in theget
method to read the value of that parameter.If the JDBC type expected to be returned to this output parameter is specific to this particular database,
sqlType
should bejava.sql.Types.OTHER
. The method getObject retrieves the value.- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so onsqlType
- the JDBC type code defined byjava.sql.Types
. If the parameter is of JDBC typeNUMERIC
orDECIMAL
, the version ofregisterOutParameter
that accepts a scale value should be used.- Throws:
java.sql.SQLException
- if a database access error occurs
-
registerOutParameter
public final void registerOutParameter(int parameterIndex, int sqlType, int scale) throws java.sql.SQLException
Registers the parameter in ordinal positionparameterIndex
to be of JDBC typesqlType
. This method must be called before a stored procedure is executed.The JDBC type specified by
sqlType
for an OUT parameter determines the Java type that must be used in theget
method to read the value of that parameter.This version of
registerOutParameter
should be used when the parameter is of JDBC typeNUMERIC
orDECIMAL
.- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so onsqlType
- SQL type code defined byjava.sql.Types
.scale
- the desired number of digits to the right of the decimal point. It must be greater than or equal to zero.- Throws:
java.sql.SQLException
- if a database access error occurs
-
wasNull
public final boolean wasNull() throws java.sql.SQLException
Indicates whether or not the last OUT parameter read had the value of SQLNULL
. Note that this method should be called only after calling agetXXX
method; otherwise, there is no value to use in determining whether it isnull
or not.- Specified by:
wasNull
in interfacejava.sql.CallableStatement
- Returns:
true
if the last parameter read was SQLNULL
;false
otherwise- Throws:
java.sql.SQLException
- if a database access error occurs
-
registerOutParameter
public final void registerOutParameter(int paramIndex, int sqlType, java.lang.String typeName) throws java.sql.SQLException
Registers the designated output parameter. This version of the methodregisterOutParameter
should be used for a user-named or REF output parameter. Examples of user-named types include: STRUCT, DISTINCT, JAVA_OBJECT, and named array types. Before executing a stored procedure call, you must explicitly callregisterOutParameter
to register the type fromjava.sql.Types
for each OUT parameter. For a user-named parameter the fully-qualified SQL type name of the parameter should also be given, while a REF parameter requires that the fully-qualified type name of the referenced type be given. A JDBC driver that does not need the type code and type name information may ignore it. To be portable, however, applications should always provide these values for user-named and REF parameters. Although it is intended for user-named and REF parameters, this method may be used to register a parameter of any JDBC type. If the parameter does not have a user-named or REF type, the typeName parameter is ignored.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.- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Parameters:
paramIndex
- the first parameter is 1, the second is 2,...sqlType
- a value from java.sql.TypestypeName
- the fully-qualified name of an SQL structured type- Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.2
-
getURL
public java.net.URL getURL(int parameterIndex) throws java.sql.SQLException
Retrieves the value of the designated JDBCDATALINK
parameter as ajava.net.URL
object.- Specified by:
getURL
in interfacejava.sql.CallableStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2,...- Returns:
- a
java.net.URL
object that represents the JDBCDATALINK
value used as the designated parameter - Throws:
java.sql.SQLException
- if a database access error occurs, or if the URL being returned is not a valid URL on the Java platform- Since:
- 1.4
- See Also:
setURL(java.lang.String, java.net.URL)
-
setURL
public void setURL(java.lang.String parameterName, java.net.URL val) throws java.sql.SQLException
Sets the designated parameter to the givenjava.net.URL
object. The driver converts this to an SQLDATALINK
value when it sends it to the database.- Specified by:
setURL
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parameterval
- the parameter value- Throws:
java.sql.SQLException
- if a database access error occurs, or if a URL is malformed- Since:
- 1.4
-
setNull
public void setNull(java.lang.String parameterName, int sqlType) throws java.sql.SQLException
Sets the designated parameter to SQLNULL
.Note: You must specify the parameter's SQL type.
- Specified by:
setNull
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parametersqlType
- the SQL type code defined injava.sql.Types
- Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
-
setBoolean
public void setBoolean(java.lang.String parameterName, boolean x) throws java.sql.SQLException
Sets the designated parameter to the given Javaboolean
value. The driver converts this to an SQLBIT
value when it sends it to the database.- Specified by:
setBoolean
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parameterx
- the parameter value- Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
-
setByte
public void setByte(java.lang.String parameterName, byte x) throws java.sql.SQLException
Sets the designated parameter to the given Javabyte
value. The driver converts this to an SQLTINYINT
value when it sends it to the database.- Specified by:
setByte
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parameterx
- the parameter value- Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
-
setShort
public void setShort(java.lang.String parameterName, short x) throws java.sql.SQLException
Sets the designated parameter to the given Javashort
value. The driver converts this to an SQLSMALLINT
value when it sends it to the database.- Specified by:
setShort
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parameterx
- the parameter value- Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
-
setInt
public void setInt(java.lang.String parameterName, int x) throws java.sql.SQLException
Sets the designated parameter to the given Javaint
value. The driver converts this to an SQLINTEGER
value when it sends it to the database.- Specified by:
setInt
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parameterx
- the parameter value- Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
-
setLong
public void setLong(java.lang.String parameterName, long x) throws java.sql.SQLException
Sets the designated parameter to the given Javalong
value. The driver converts this to an SQLBIGINT
value when it sends it to the database.- Specified by:
setLong
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parameterx
- the parameter value- Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
-
setFloat
public void setFloat(java.lang.String parameterName, float x) throws java.sql.SQLException
Sets the designated parameter to the given Javafloat
value. The driver converts this to an SQLFLOAT
value when it sends it to the database.- Specified by:
setFloat
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parameterx
- the parameter value- Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
-
setDouble
public void setDouble(java.lang.String parameterName, double x) throws java.sql.SQLException
Sets the designated parameter to the given Javadouble
value. The driver converts this to an SQLDOUBLE
value when it sends it to the database.- Specified by:
setDouble
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parameterx
- the parameter value- Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
-
setBigDecimal
public void setBigDecimal(java.lang.String parameterName, java.math.BigDecimal x) throws java.sql.SQLException
Sets the designated parameter to the givenjava.math.BigDecimal
value. The driver converts this to an SQLNUMERIC
value when it sends it to the database.- Specified by:
setBigDecimal
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parameterx
- the parameter value- Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
-
setString
public void setString(java.lang.String parameterName, java.lang.String x) throws java.sql.SQLException
Sets the designated parameter to the given JavaString
value. The driver converts this to an SQLVARCHAR
orLONGVARCHAR
value (depending on the argument's size relative to the driver's limits onVARCHAR
values) when it sends it to the database.- Specified by:
setString
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parameterx
- the parameter value- Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
-
setBytes
public void setBytes(java.lang.String parameterName, byte[] x) throws java.sql.SQLException
Sets the designated parameter to the given Java array of bytes. The driver converts this to an SQLVARBINARY
orLONGVARBINARY
(depending on the argument's size relative to the driver's limits onVARBINARY
values) when it sends it to the database.- Specified by:
setBytes
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parameterx
- the parameter value- Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
-
setDate
public void setDate(java.lang.String parameterName, java.sql.Date x) throws java.sql.SQLException
Sets the designated parameter to the givenjava.sql.Date
value. The driver converts this to an SQLDATE
value when it sends it to the database.- Specified by:
setDate
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parameterx
- the parameter value- Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
-
setTime
public void setTime(java.lang.String parameterName, java.sql.Time x) throws java.sql.SQLException
Sets the designated parameter to the givenjava.sql.Time
value. The driver converts this to an SQLTIME
value when it sends it to the database.- Specified by:
setTime
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parameterx
- the parameter value- Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
-
setTimestamp
public void setTimestamp(java.lang.String parameterName, java.sql.Timestamp x) throws java.sql.SQLException
Sets the designated parameter to the givenjava.sql.Timestamp
value. The driver converts this to an SQLTIMESTAMP
value when it sends it to the database.- Specified by:
setTimestamp
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parameterx
- the parameter value- Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
-
setAsciiStream
public void setAsciiStream(java.lang.String parameterName, java.io.InputStream x, int length) throws java.sql.SQLException
Sets the designated parameter to the given input stream, which will have the specified number of bytes. When a very large ASCII value is input to aLONGVARCHAR
parameter, it may be more practical to send it via ajava.io.InputStream
. Data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from ASCII to the database char format.Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
- Specified by:
setAsciiStream
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parameterx
- the Java input stream that contains the ASCII parameter valuelength
- the number of bytes in the stream- Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
-
setBinaryStream
public void setBinaryStream(java.lang.String parameterName, java.io.InputStream x, int length) throws java.sql.SQLException
Sets the designated parameter to the given input stream, which will have the specified number of bytes. When a very large binary value is input to aLONGVARBINARY
parameter, it may be more practical to send it via ajava.io.InputStream
object. The data will be read from the stream as needed until end-of-file is reached.Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
- Specified by:
setBinaryStream
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parameterx
- the java input stream which contains the binary parameter valuelength
- the number of bytes in the stream- Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
-
setObject
public void setObject(java.lang.String parameterName, java.lang.Object x, int targetSqlType, int scale) throws java.sql.SQLException
Sets the value of the designated parameter with the given object. The second argument must be an object type; for integral values, thejava.lang
equivalent objects should be used.The given Java object will be converted to the given targetSqlType before being sent to the database. If the object has a custom mapping (is of a class implementing the interface
SQLData
), the JDBC driver should call the methodSQLData.writeSQL
to write it to the SQL data stream. If, on the other hand, the object is of a class implementingRef
,Blob
,Clob
,Struct
, orArray
, the driver should pass it to the database as a value of the corresponding SQL type.Note that this method may be used to pass datatabase- specific abstract data types.
- Specified by:
setObject
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parameterx
- the object containing the input parameter valuetargetSqlType
- the SQL type (as defined in java.sql.Types) to be sent to the database. The scale argument may further qualify this type.scale
- for java.sql.Types.DECIMAL or java.sql.Types.NUMERIC types, this is the number of digits after the decimal point. For all other types, this value will be ignored.- Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
- See Also:
Types
-
setObject
public void setObject(java.lang.String parameterName, java.lang.Object x, int targetSqlType) throws java.sql.SQLException
Sets the value of the designated parameter with the given object. This method is like the methodsetObject
above, except that it assumes a scale of zero.- Specified by:
setObject
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parameterx
- the object containing the input parameter valuetargetSqlType
- the SQL type (as defined in java.sql.Types) to be sent to the database- Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
-
setObject
public void setObject(java.lang.String parameterName, java.lang.Object x) throws java.sql.SQLException
Sets the value of the designated parameter with the given object. The second parameter must be of typeObject
; therefore, thejava.lang
equivalent objects should be used for built-in types.The JDBC specification specifies a standard mapping from Java
Object
types to SQL types. The given argument will be converted to the corresponding SQL type before being sent to the database.Note that this method may be used to pass datatabase- specific abstract data types, by using a driver-specific Java type. If the object is of a class implementing the interface
SQLData
, the JDBC driver should call the methodSQLData.writeSQL
to write it to the SQL data stream. If, on the other hand, the object is of a class implementingRef
,Blob
,Clob
,Struct
, orArray
, the driver should pass it to the database as a value of the corresponding SQL type.This method throws an exception if there is an ambiguity, for example, if the object is of a class implementing more than one of the interfaces named above.
- Specified by:
setObject
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parameterx
- the object containing the input parameter value- Throws:
java.sql.SQLException
- if a database access error occurs or if the givenObject
parameter is ambiguous- Since:
- 1.4
-
setCharacterStream
public void setCharacterStream(java.lang.String parameterName, java.io.Reader reader, int length) throws java.sql.SQLException
Sets the designated parameter to the givenReader
object, which is the given number of characters long. When a very large UNICODE value is input to aLONGVARCHAR
parameter, it may be more practical to send it via ajava.io.Reader
object. The data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from UNICODE to the database char format.Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
- Specified by:
setCharacterStream
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parameterreader
- thejava.io.Reader
object that contains the UNICODE data used as the designated parameterlength
- the number of characters in the stream- Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
-
setDate
public void setDate(java.lang.String parameterName, java.sql.Date x, java.util.Calendar cal) throws java.sql.SQLException
Sets the designated parameter to the givenjava.sql.Date
value, using the givenCalendar
object. The driver uses theCalendar
object to construct an SQLDATE
value, which the driver then sends to the database. With a aCalendar
object, the driver can calculate the date taking into account a custom timezone. If noCalendar
object is specified, the driver uses the default timezone, which is that of the virtual machine running the application.- Specified by:
setDate
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parameterx
- the parameter valuecal
- theCalendar
object the driver will use to construct the date- Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
-
setTime
public void setTime(java.lang.String parameterName, java.sql.Time x, java.util.Calendar cal) throws java.sql.SQLException
Sets the designated parameter to the givenjava.sql.Time
value, using the givenCalendar
object. The driver uses theCalendar
object to construct an SQLTIME
value, which the driver then sends to the database. With a aCalendar
object, the driver can calculate the time taking into account a custom timezone. If noCalendar
object is specified, the driver uses the default timezone, which is that of the virtual machine running the application.- Specified by:
setTime
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parameterx
- the parameter valuecal
- theCalendar
object the driver will use to construct the time- Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
-
setTimestamp
public void setTimestamp(java.lang.String parameterName, java.sql.Timestamp x, java.util.Calendar cal) throws java.sql.SQLException
Sets the designated parameter to the givenjava.sql.Timestamp
value, using the givenCalendar
object. The driver uses theCalendar
object to construct an SQLTIMESTAMP
value, which the driver then sends to the database. With a aCalendar
object, the driver can calculate the timestamp taking into account a custom timezone. If noCalendar
object is specified, the driver uses the default timezone, which is that of the virtual machine running the application.- Specified by:
setTimestamp
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parameterx
- the parameter valuecal
- theCalendar
object the driver will use to construct the timestamp- Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
-
setNull
public void setNull(java.lang.String parameterName, int sqlType, java.lang.String typeName) throws java.sql.SQLException
Sets the designated parameter to SQLNULL
. This version of the methodsetNull
should be used for user-defined types and REF type parameters. Examples of user-defined types include: STRUCT, DISTINCT, JAVA_OBJECT, and named array types.Note: To be portable, applications must give the SQL type code and the fully-qualified SQL type name when specifying a NULL user-defined or REF parameter. In the case of a user-defined type the name is the type name of the parameter itself. For a REF parameter, the name is the type name of the referenced type. If a JDBC driver does not need the type code or type name information, it may ignore it. Although it is intended for user-defined and Ref parameters, this method may be used to set a null parameter of any JDBC type. If the parameter does not have a user-defined or REF type, the given typeName is ignored.
- Specified by:
setNull
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parametersqlType
- a value fromjava.sql.Types
typeName
- the fully-qualified name of an SQL user-defined type; ignored if the parameter is not a user-defined type or SQLREF
value- Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
-
getString
public java.lang.String getString(java.lang.String parameterName) throws java.sql.SQLException
Retrieves the value of a JDBCCHAR
,VARCHAR
, orLONGVARCHAR
parameter as aString
in the Java programming language.For the fixed-length type JDBC
CHAR
, theString
object returned has exactly the same value the JDBCCHAR
value had in the database, including any padding added by the database.- Specified by:
getString
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parameter- Returns:
- the parameter value. If the value is SQL
NULL
, the result isnull
. - Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
- See Also:
setString(java.lang.String, java.lang.String)
-
getBoolean
public boolean getBoolean(java.lang.String parameterName) throws java.sql.SQLException
Retrieves the value of a JDBCBIT
parameter as aboolean
in the Java programming language.- Specified by:
getBoolean
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parameter- Returns:
- the parameter value. If the value is SQL
NULL
, the result isfalse
. - Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
- See Also:
setBoolean(java.lang.String, boolean)
-
getByte
public byte getByte(java.lang.String parameterName) throws java.sql.SQLException
Retrieves the value of a JDBCTINYINT
parameter as abyte
in the Java programming language.- Specified by:
getByte
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parameter- Returns:
- the parameter value. If the value is SQL
NULL
, the result is0
. - Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
- See Also:
setByte(java.lang.String, byte)
-
getShort
public short getShort(java.lang.String parameterName) throws java.sql.SQLException
Retrieves the value of a JDBCSMALLINT
parameter as ashort
in the Java programming language.- Specified by:
getShort
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parameter- Returns:
- the parameter value. If the value is SQL
NULL
, the result is0
. - Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
- See Also:
setShort(java.lang.String, short)
-
getInt
public int getInt(java.lang.String parameterName) throws java.sql.SQLException
Retrieves the value of a JDBCINTEGER
parameter as anint
in the Java programming language.- Specified by:
getInt
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parameter- Returns:
- the parameter value. If the value is SQL
NULL
, the result is0
. - Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
- See Also:
setInt(java.lang.String, int)
-
getLong
public long getLong(java.lang.String parameterName) throws java.sql.SQLException
Retrieves the value of a JDBCBIGINT
parameter as along
in the Java programming language.- Specified by:
getLong
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parameter- Returns:
- the parameter value. If the value is SQL
NULL
, the result is0
. - Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
- See Also:
setLong(java.lang.String, long)
-
getFloat
public float getFloat(java.lang.String parameterName) throws java.sql.SQLException
Retrieves the value of a JDBCFLOAT
parameter as afloat
in the Java programming language.- Specified by:
getFloat
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parameter- Returns:
- the parameter value. If the value is SQL
NULL
, the result is0
. - Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
- See Also:
setFloat(java.lang.String, float)
-
getDouble
public double getDouble(java.lang.String parameterName) throws java.sql.SQLException
Retrieves the value of a JDBCDOUBLE
parameter as adouble
in the Java programming language.- Specified by:
getDouble
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parameter- Returns:
- the parameter value. If the value is SQL
NULL
, the result is0
. - Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
- See Also:
setDouble(java.lang.String, double)
-
getBytes
public byte[] getBytes(java.lang.String parameterName) throws java.sql.SQLException
Retrieves the value of a JDBCBINARY
orVARBINARY
parameter as an array ofbyte
values in the Java programming language.- Specified by:
getBytes
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parameter- Returns:
- the parameter value. If the value is SQL
NULL
, the result isnull
. - Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
- See Also:
setBytes(java.lang.String, byte[])
-
getDate
public java.sql.Date getDate(java.lang.String parameterName) throws java.sql.SQLException
Retrieves the value of a JDBCDATE
parameter as ajava.sql.Date
object.- Specified by:
getDate
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parameter- Returns:
- the parameter value. If the value is SQL
NULL
, the result isnull
. - Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
-
getTime
public java.sql.Time getTime(java.lang.String parameterName) throws java.sql.SQLException
Retrieves the value of a JDBCTIME
parameter as ajava.sql.Time
object.- Specified by:
getTime
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parameter- Returns:
- the parameter value. If the value is SQL
NULL
, the result isnull
. - Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
-
getTimestamp
public java.sql.Timestamp getTimestamp(java.lang.String parameterName) throws java.sql.SQLException
Retrieves the value of a JDBCTIMESTAMP
parameter as ajava.sql.Timestamp
object.- Specified by:
getTimestamp
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parameter- Returns:
- the parameter value. If the value is SQL
NULL
, the result isnull
. - Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
-
getObject
public java.lang.Object getObject(java.lang.String parameterName) throws java.sql.SQLException
Retrieves the value of a parameter as anObject
in the Java programming language. If the value is an SQLNULL
, the driver returns a Javanull
.This method returns a Java object whose type corresponds to the JDBC type that was registered for this parameter using the method
registerOutParameter
. By registering the target JDBC type asjava.sql.Types.OTHER
, this method can be used to read database-specific abstract data types.- Specified by:
getObject
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parameter- Returns:
- A
java.lang.Object
holding the OUT parameter value. - Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
- See Also:
Types
-
getBigDecimal
public java.math.BigDecimal getBigDecimal(java.lang.String parameterName) throws java.sql.SQLException
Retrieves the value of a JDBCNUMERIC
parameter as ajava.math.BigDecimal
object with as many digits to the right of the decimal point as the value contains.- Specified by:
getBigDecimal
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parameter- Returns:
- the parameter value in full precision. If the value is
SQL
NULL
, the result isnull
. - Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
- See Also:
setBigDecimal(java.lang.String, java.math.BigDecimal)
-
getObject
public java.lang.Object getObject(java.lang.String parameterName, java.util.Map map) throws java.sql.SQLException
Returns an object representing the value of OUT parameteri
and usesmap
for the custom mapping of the parameter value.This method returns a Java object whose type corresponds to the JDBC type that was registered for this parameter using the method
registerOutParameter
. By registering the target JDBC type asjava.sql.Types.OTHER
, this method can be used to read database-specific abstract data types.- Specified by:
getObject
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parametermap
- the mapping from SQL type names to Java classes- Returns:
- a
java.lang.Object
holding the OUT parameter value - Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
-
getRef
public java.sql.Ref getRef(java.lang.String parameterName) throws java.sql.SQLException
Retrieves the value of a JDBCREF(<structured-type>)
parameter as aRef
object in the Java programming language.- Specified by:
getRef
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parameter- Returns:
- the parameter value as a
Ref
object in the Java programming language. If the value was SQLNULL
, the valuenull
is returned. - Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
-
getBlob
public java.sql.Blob getBlob(java.lang.String parameterName) throws java.sql.SQLException
Retrieves the value of a JDBCBLOB
parameter as aBlob
object in the Java programming language.- Specified by:
getBlob
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parameter- Returns:
- the parameter value as a
Blob
object in the Java programming language. If the value was SQLNULL
, the valuenull
is returned. - Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
-
getClob
public java.sql.Clob getClob(java.lang.String parameterName) throws java.sql.SQLException
Retrieves the value of a JDBCCLOB
parameter as aClob
object in the Java programming language.- Specified by:
getClob
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parameter- Returns:
- the parameter value as a
Clob
object in the Java programming language. If the value was SQLNULL
, the valuenull
is returned. - Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
-
getArray
public java.sql.Array getArray(java.lang.String parameterName) throws java.sql.SQLException
Retrieves the value of a JDBCARRAY
parameter as anArray
object in the Java programming language.- Specified by:
getArray
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parameter- Returns:
- the parameter value as an
Array
object in Java programming language. If the value was SQLNULL
, the valuenull
is returned. - Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
-
getDate
public java.sql.Date getDate(java.lang.String parameterName, java.util.Calendar cal) throws java.sql.SQLException
Retrieves the value of a JDBCDATE
parameter as ajava.sql.Date
object, using the givenCalendar
object to construct the date. With aCalendar
object, the driver can calculate the date taking into account a custom timezone and locale. If noCalendar
object is specified, the driver uses the default timezone and locale.- Specified by:
getDate
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parametercal
- theCalendar
object the driver will use to construct the date- Returns:
- the parameter value. If the value is SQL
NULL
, the result isnull
. - Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
-
getTime
public java.sql.Time getTime(java.lang.String parameterName, java.util.Calendar cal) throws java.sql.SQLException
Retrieves the value of a JDBCTIME
parameter as ajava.sql.Time
object, using the givenCalendar
object to construct the time. With aCalendar
object, the driver can calculate the time taking into account a custom timezone and locale. If noCalendar
object is specified, the driver uses the default timezone and locale.- Specified by:
getTime
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parametercal
- theCalendar
object the driver will use to construct the time- Returns:
- the parameter value; if the value is SQL
NULL
, the result isnull
. - Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
-
getTimestamp
public java.sql.Timestamp getTimestamp(java.lang.String parameterName, java.util.Calendar cal) throws java.sql.SQLException
Retrieves the value of a JDBCTIMESTAMP
parameter as ajava.sql.Timestamp
object, using the givenCalendar
object to construct theTimestamp
object. With aCalendar
object, the driver can calculate the timestamp taking into account a custom timezone and locale. If noCalendar
object is specified, the driver uses the default timezone and locale.- Specified by:
getTimestamp
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parametercal
- theCalendar
object the driver will use to construct the timestamp- Returns:
- the parameter value. If the value is SQL
NULL
, the result isnull
. - Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
-
getURL
public java.net.URL getURL(java.lang.String parameterName) throws java.sql.SQLException
Retrieves the value of a JDBCDATALINK
parameter as ajava.net.URL
object.- Specified by:
getURL
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parameter- Returns:
- the parameter value as a
java.net.URL
object in the Java programming language. If the value was SQLNULL
, the valuenull
is returned. - Throws:
java.sql.SQLException
- if a database access error occurs, or if there is a problem with the URL- Since:
- 1.4
- See Also:
setURL(java.lang.String, java.net.URL)
-
registerOutParameter
public void registerOutParameter(java.lang.String parameterName, int sqlType) throws java.sql.SQLException
Registers the OUT parameter namedparameterName
to the JDBC typesqlType
. All OUT parameters must be registered before a stored procedure is executed.The JDBC type specified by
sqlType
for an OUT parameter determines the Java type that must be used in theget
method to read the value of that parameter.If the JDBC type expected to be returned to this output parameter is specific to this particular database,
sqlType
should bejava.sql.Types.OTHER
. The method getObject retrieves the value.- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parametersqlType
- the JDBC type code defined byjava.sql.Types
. If the parameter is of JDBC typeNUMERIC
orDECIMAL
, the version ofregisterOutParameter
that accepts a scale value should be used.- Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
- See Also:
Types
-
registerOutParameter
public void registerOutParameter(java.lang.String parameterName, int sqlType, int scale) throws java.sql.SQLException
Registers the parameter namedparameterName
to be of JDBC typesqlType
. This method must be called before a stored procedure is executed.The JDBC type specified by
sqlType
for an OUT parameter determines the Java type that must be used in theget
method to read the value of that parameter.This version of
registerOutParameter
should be used when the parameter is of JDBC typeNUMERIC
orDECIMAL
.- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parametersqlType
- SQL type code defined byjava.sql.Types
.scale
- the desired number of digits to the right of the decimal point. It must be greater than or equal to zero.- Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
- See Also:
Types
-
registerOutParameter
public void registerOutParameter(java.lang.String parameterName, int sqlType, java.lang.String typeName) throws java.sql.SQLException
Registers the designated output parameter. This version of the methodregisterOutParameter
should be used for a user-named or REF output parameter. Examples of user-named types include: STRUCT, DISTINCT, JAVA_OBJECT, and named array types. Before executing a stored procedure call, you must explicitly callregisterOutParameter
to register the type fromjava.sql.Types
for each OUT parameter. For a user-named parameter the fully-qualified SQL type name of the parameter should also be given, while a REF parameter requires that the fully-qualified type name of the referenced type be given. A JDBC driver that does not need the type code and type name information may ignore it. To be portable, however, applications should always provide these values for user-named and REF parameters. Although it is intended for user-named and REF parameters, this method may be used to register a parameter of any JDBC type. If the parameter does not have a user-named or REF type, the typeName parameter is ignored.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.- Specified by:
registerOutParameter
in interfacejava.sql.CallableStatement
- Parameters:
parameterName
- the name of the parametersqlType
- a value fromTypes
typeName
- the fully-qualified name of an SQL structured type- Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
- See Also:
Types
-
getObject
public <T> T getObject(java.lang.String parameterName, java.lang.Class<T> arg0) throws java.sql.SQLException
- Specified by:
getObject
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getObject
public <T> T getObject(int columnIndex, java.lang.Class<T> arg0) throws java.sql.SQLException
- Specified by:
getObject
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
-
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
-
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
-
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 reader) 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 x) 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 x) throws java.sql.SQLException
- Specified by:
setAsciiStream
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
setCharacterStream
public void setCharacterStream(java.lang.String parameterName, java.io.Reader reader, long length) 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 x, long length) 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 x, long length) throws java.sql.SQLException
- Specified by:
setAsciiStream
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
-
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
-
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
-
getCharacterStream
public java.io.Reader getCharacterStream(int parameterIndex) throws java.sql.SQLException
- Specified by:
getCharacterStream
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
-
getNCharacterStream
public java.io.Reader getNCharacterStream(int parameterIndex) throws java.sql.SQLException
- Specified by:
getNCharacterStream
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
-
getNString
public java.lang.String getNString(int parameterIndex) throws java.sql.SQLException
- Specified by:
getNString
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
getSQLXML
public java.sql.SQLXML getSQLXML(java.lang.String parameterName) throws java.sql.SQLException
- Specified by:
getSQLXML
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
-
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
-
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
-
getNClob
public java.sql.NClob getNClob(int parameterIndex) throws java.sql.SQLException
- Specified by:
getNClob
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
getRowId
public java.sql.RowId getRowId(int parameterIndex) throws java.sql.SQLException
- Specified by:
getRowId
in interfacejava.sql.CallableStatement
- Throws:
java.sql.SQLException
-
-