public final class JdbcCallableStatement extends JdbcPreparedStatement implements java.sql.CallableStatement
Thread safety: the callable statement is not thread-safe. If the same callable statement is used by multiple threads access to it must be synchronized. The single synchronized block must include assignment of parameters, execution of the command and all operations with its result.
synchronized (call) { call.setInt(1, 10); try (ResultSet rs = call.executeQuery()) { while (rs.next) { // Do something } } } synchronized (call) { call.setInt(1, 15); updateCount = call.executeUpdate(); }
command
conn, fetchSize, generatedKeys, maxRows, resultSet, resultSetConcurrency, resultSetType, session, updateCount
Modifier and Type | Method and Description |
---|---|
long |
executeLargeUpdate()
Executes a statement (insert, update, delete, create, drop)
and returns the update count.
|
int |
executeUpdate()
Executes a statement (insert, update, delete, create, drop)
and returns the update count.
|
java.sql.Array |
getArray(int parameterIndex)
Returns the value of the specified column as an Array.
|
java.sql.Array |
getArray(java.lang.String parameterName)
Returns the value of the specified column as an Array.
|
java.math.BigDecimal |
getBigDecimal(int parameterIndex)
Returns the value of the specified column as a BigDecimal.
|
java.math.BigDecimal |
getBigDecimal(int parameterIndex,
int scale)
Deprecated.
|
java.math.BigDecimal |
getBigDecimal(java.lang.String parameterName)
Returns the value of the specified column as a BigDecimal.
|
java.sql.Blob |
getBlob(int parameterIndex)
Returns the value of the specified column as a Blob.
|
java.sql.Blob |
getBlob(java.lang.String parameterName)
Returns the value of the specified column as a Blob.
|
boolean |
getBoolean(int parameterIndex)
Returns the value of the specified column as a boolean.
|
boolean |
getBoolean(java.lang.String parameterName)
Returns the value of the specified column as a boolean.
|
byte |
getByte(int parameterIndex)
Returns the value of the specified column as a byte.
|
byte |
getByte(java.lang.String parameterName)
Returns the value of the specified column as a byte.
|
byte[] |
getBytes(int parameterIndex)
Returns the value of the specified column as a byte array.
|
byte[] |
getBytes(java.lang.String parameterName)
Returns the value of the specified column as a byte array.
|
java.io.Reader |
getCharacterStream(int parameterIndex)
Returns the value of the specified column as a reader.
|
java.io.Reader |
getCharacterStream(java.lang.String parameterName)
Returns the value of the specified column as a reader.
|
java.sql.Clob |
getClob(int parameterIndex)
Returns the value of the specified column as a Clob.
|
java.sql.Clob |
getClob(java.lang.String parameterName)
Returns the value of the specified column as a Clob.
|
java.sql.Date |
getDate(int parameterIndex)
Returns the value of the specified column as a java.sql.Date.
|
java.sql.Date |
getDate(int parameterIndex,
java.util.Calendar cal)
Returns the value of the specified column as a java.sql.Date using a
specified time zone.
|
java.sql.Date |
getDate(java.lang.String parameterName)
Returns the value of the specified column as a java.sql.Date.
|
java.sql.Date |
getDate(java.lang.String parameterName,
java.util.Calendar cal)
Returns the value of the specified column as a java.sql.Date using a
specified time zone.
|
double |
getDouble(int parameterIndex)
Returns the value of the specified column as a double.
|
double |
getDouble(java.lang.String parameterName)
Returns the value of the specified column as a double.
|
float |
getFloat(int parameterIndex)
Returns the value of the specified column as a float.
|
float |
getFloat(java.lang.String parameterName)
Returns the value of the specified column as a float.
|
int |
getInt(int parameterIndex)
Returns the value of the specified column as an int.
|
int |
getInt(java.lang.String parameterName)
Returns the value of the specified column as an int.
|
long |
getLong(int parameterIndex)
Returns the value of the specified column as a long.
|
long |
getLong(java.lang.String parameterName)
Returns the value of the specified column as a long.
|
java.io.Reader |
getNCharacterStream(int parameterIndex)
Returns the value of the specified column as a reader.
|
java.io.Reader |
getNCharacterStream(java.lang.String parameterName)
Returns the value of the specified column as a reader.
|
java.sql.NClob |
getNClob(int parameterIndex)
Returns the value of the specified column as a Clob.
|
java.sql.NClob |
getNClob(java.lang.String parameterName)
Returns the value of the specified column as a Clob.
|
java.lang.String |
getNString(int parameterIndex)
Returns the value of the specified column as a String.
|
java.lang.String |
getNString(java.lang.String parameterName)
Returns the value of the specified column as a String.
|
java.lang.Object |
getObject(int parameterIndex)
Returns a column value as a Java object.
|
<T> T |
getObject(int parameterIndex,
java.lang.Class<T> type)
Returns the value of the specified column as a Java object of the
specified type.
|
java.lang.Object |
getObject(int parameterIndex,
java.util.Map<java.lang.String,java.lang.Class<?>> map)
[Not supported] Gets a column as a object using the specified type
mapping.
|
java.lang.Object |
getObject(java.lang.String parameterName)
Returns a column value as a Java object.
|
<T> T |
getObject(java.lang.String parameterName,
java.lang.Class<T> type)
Returns the value of the specified column as a Java object of the
specified type.
|
java.lang.Object |
getObject(java.lang.String parameterName,
java.util.Map<java.lang.String,java.lang.Class<?>> map)
[Not supported] Gets a column as a object using the specified type
mapping.
|
java.sql.Ref |
getRef(int parameterIndex)
[Not supported] Gets a column as a reference.
|
java.sql.Ref |
getRef(java.lang.String parameterName)
[Not supported] Gets a column as a reference.
|
java.sql.RowId |
getRowId(int parameterIndex)
[Not supported] Returns the value of the specified column as a row id.
|
java.sql.RowId |
getRowId(java.lang.String parameterName)
[Not supported] Returns the value of the specified column as a row id.
|
short |
getShort(int parameterIndex)
Returns the value of the specified column as a short.
|
short |
getShort(java.lang.String parameterName)
Returns the value of the specified column as a short.
|
java.sql.SQLXML |
getSQLXML(int parameterIndex)
Returns the value of the specified column as a SQLXML object.
|
java.sql.SQLXML |
getSQLXML(java.lang.String parameterName)
Returns the value of the specified column as a SQLXML object.
|
java.lang.String |
getString(int parameterIndex)
Returns the value of the specified column as a String.
|
java.lang.String |
getString(java.lang.String parameterName)
Returns the value of the specified column as a String.
|
java.sql.Time |
getTime(int parameterIndex)
Returns the value of the specified column as a java.sql.Time.
|
java.sql.Time |
getTime(int parameterIndex,
java.util.Calendar cal)
Returns the value of the specified column as a java.sql.Time using a
specified time zone.
|
java.sql.Time |
getTime(java.lang.String parameterName)
Returns the value of the specified column as a java.sql.Time.
|
java.sql.Time |
getTime(java.lang.String parameterName,
java.util.Calendar cal)
Returns the value of the specified column as a java.sql.Time using a
specified time zone.
|
java.sql.Timestamp |
getTimestamp(int parameterIndex)
Returns the value of the specified column as a java.sql.Timestamp.
|
java.sql.Timestamp |
getTimestamp(int parameterIndex,
java.util.Calendar cal)
Returns the value of the specified column as a java.sql.Timestamp using a
specified time zone.
|
java.sql.Timestamp |
getTimestamp(java.lang.String parameterName)
Returns the value of the specified column as a java.sql.Timestamp.
|
java.sql.Timestamp |
getTimestamp(java.lang.String parameterName,
java.util.Calendar cal)
Returns the value of the specified column as a java.sql.Timestamp using a
specified time zone.
|
java.net.URL |
getURL(int parameterIndex)
[Not supported]
|
java.net.URL |
getURL(java.lang.String parameterName)
[Not supported]
|
void |
registerOutParameter(int parameterIndex,
int sqlType)
Registers the given OUT parameter.
|
void |
registerOutParameter(int parameterIndex,
int sqlType,
int scale)
Registers the given OUT parameter.
|
void |
registerOutParameter(int parameterIndex,
int sqlType,
java.lang.String typeName)
Registers the given OUT parameter.
|
void |
registerOutParameter(java.lang.String parameterName,
int sqlType)
Registers the given OUT parameter.
|
void |
registerOutParameter(java.lang.String parameterName,
int sqlType,
int scale)
Registers the given OUT parameter.
|
void |
registerOutParameter(java.lang.String parameterName,
int sqlType,
java.lang.String typeName)
Registers the given OUT parameter.
|
void |
setAsciiStream(java.lang.String parameterName,
java.io.InputStream x)
Sets the value of a parameter as an ASCII stream.
|
void |
setAsciiStream(java.lang.String parameterName,
java.io.InputStream x,
int length)
Sets the value of a parameter as an ASCII stream.
|
void |
setAsciiStream(java.lang.String parameterName,
java.io.InputStream x,
long length)
Sets the value of a parameter as an ASCII stream.
|
void |
setBigDecimal(java.lang.String parameterName,
java.math.BigDecimal x)
Sets the value of a parameter.
|
void |
setBinaryStream(java.lang.String parameterName,
java.io.InputStream x)
Sets the value of a parameter as an input stream.
|
void |
setBinaryStream(java.lang.String parameterName,
java.io.InputStream x,
int length)
Sets the value of a parameter as an input stream.
|
void |
setBinaryStream(java.lang.String parameterName,
java.io.InputStream x,
long length)
Sets the value of a parameter as an input stream.
|
void |
setBlob(java.lang.String parameterName,
java.sql.Blob x)
Sets the value of a parameter as a Blob.
|
void |
setBlob(java.lang.String parameterName,
java.io.InputStream x)
Sets the value of a parameter as a Blob.
|
void |
setBlob(java.lang.String parameterName,
java.io.InputStream x,
long length)
Sets the value of a parameter as a Blob.
|
void |
setBoolean(java.lang.String parameterName,
boolean x)
Sets the value of a parameter.
|
void |
setByte(java.lang.String parameterName,
byte x)
Sets the value of a parameter.
|
void |
setBytes(java.lang.String parameterName,
byte[] x)
Sets the value of a parameter as a byte array.
|
void |
setCharacterStream(java.lang.String parameterName,
java.io.Reader x)
Sets the value of a parameter as a character stream.
|
void |
setCharacterStream(java.lang.String parameterName,
java.io.Reader x,
int length)
Sets the value of a parameter as a character stream.
|
void |
setCharacterStream(java.lang.String parameterName,
java.io.Reader x,
long length)
Sets the value of a parameter as a character stream.
|
void |
setClob(java.lang.String parameterName,
java.sql.Clob x)
Sets the value of a parameter as a Clob.
|
void |
setClob(java.lang.String parameterName,
java.io.Reader x)
Sets the value of a parameter as a character stream.
|
void |
setClob(java.lang.String parameterName,
java.io.Reader x,
long length)
Sets the value of a parameter as a Clob.
|
void |
setDate(java.lang.String parameterName,
java.sql.Date x)
Sets the value of a parameter.
|
void |
setDate(java.lang.String parameterName,
java.sql.Date x,
java.util.Calendar cal)
Sets the date using a specified time zone.
|
void |
setDouble(java.lang.String parameterName,
double x)
Sets the value of a parameter.
|
void |
setFloat(java.lang.String parameterName,
float x)
Sets the value of a parameter.
|
void |
setInt(java.lang.String parameterName,
int x)
Sets the value of a parameter.
|
void |
setLong(java.lang.String parameterName,
long x)
Sets the value of a parameter.
|
void |
setNCharacterStream(java.lang.String parameterName,
java.io.Reader x)
Sets the value of a parameter as a character stream.
|
void |
setNCharacterStream(java.lang.String parameterName,
java.io.Reader x,
long length)
Sets the value of a parameter as a character stream.
|
void |
setNClob(java.lang.String parameterName,
java.sql.NClob x)
Sets the value of a parameter as a Clob.
|
void |
setNClob(java.lang.String parameterName,
java.io.Reader x)
Sets the value of a parameter as a Clob.
|
void |
setNClob(java.lang.String parameterName,
java.io.Reader x,
long length)
Sets the value of a parameter as a Clob.
|
void |
setNString(java.lang.String parameterName,
java.lang.String x)
Sets the value of a parameter.
|
void |
setNull(java.lang.String parameterName,
int sqlType)
Sets a parameter to null.
|
void |
setNull(java.lang.String parameterName,
int sqlType,
java.lang.String typeName)
Sets a parameter to null.
|
void |
setObject(java.lang.String parameterName,
java.lang.Object x)
Sets the value of a parameter.
|
void |
setObject(java.lang.String parameterName,
java.lang.Object x,
int targetSqlType)
Sets the value of a parameter.
|
void |
setObject(java.lang.String parameterName,
java.lang.Object x,
int targetSqlType,
int scale)
Sets the value of a parameter.
|
void |
setObject(java.lang.String parameterName,
java.lang.Object x,
java.sql.SQLType targetSqlType)
Sets the value of a parameter.
|
void |
setObject(java.lang.String parameterName,
java.lang.Object x,
java.sql.SQLType targetSqlType,
int scaleOrLength)
Sets the value of a parameter.
|
void |
setRowId(java.lang.String parameterName,
java.sql.RowId x)
[Not supported] Sets the value of a parameter as a row id.
|
void |
setShort(java.lang.String parameterName,
short x)
Sets the value of a parameter.
|
void |
setSQLXML(java.lang.String parameterName,
java.sql.SQLXML x)
Sets the value of a parameter as a SQLXML object.
|
void |
setString(java.lang.String parameterName,
java.lang.String x)
Sets the value of a parameter.
|
void |
setTime(java.lang.String parameterName,
java.sql.Time x)
Sets the time using a specified time zone.
|
void |
setTime(java.lang.String parameterName,
java.sql.Time x,
java.util.Calendar cal)
Sets the time using a specified time zone.
|
void |
setTimestamp(java.lang.String parameterName,
java.sql.Timestamp x)
Sets the value of a parameter.
|
void |
setTimestamp(java.lang.String parameterName,
java.sql.Timestamp x,
java.util.Calendar cal)
Sets the timestamp using a specified time zone.
|
void |
setURL(java.lang.String parameterName,
java.net.URL val)
[Not supported]
|
boolean |
wasNull()
Returns whether the last column accessed was null.
|
addBatch, addBatch, clearBatch, clearParameters, close, execute, executeBatch, executeLargeBatch, executeQuery, executeQuery, getGeneratedKeys, 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, toString
cancel, clearWarnings, closeOldResultSet, closeOnCompletion, enquoteIdentifier, execute, execute, execute, execute, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getLargeMaxRows, getLargeUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isCancelled, isClosed, isCloseOnCompletion, isPoolable, isSimpleIdentifier, isWrapperFor, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout, unwrap
debugCode, debugCodeAssign, debugCodeCall, debugCodeCall, debugCodeCall, getNextId, getTraceId, getTraceObjectName, isDebugEnabled, isInfoEnabled, logAndConvert, quote, quoteArray, quoteBigDecimal, quoteBytes, quoteDate, quoteIntArray, quoteMap, quoteTime, quoteTimestamp, setTrace, unsupported
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter
addBatch, clearParameters, execute, executeQuery, getMetaData, getParameterMetaData, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setNull, setNull, setObject, setObject, setObject, setObject, setObject, setRef, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL
addBatch, cancel, clearBatch, clearWarnings, close, closeOnCompletion, execute, execute, execute, execute, executeBatch, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getLargeMaxRows, getLargeUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout
public int executeUpdate() throws java.sql.SQLException
executeUpdate
in interface java.sql.PreparedStatement
executeUpdate
in class JdbcPreparedStatement
java.sql.SQLException
- if this object is closed or invalidJdbcPreparedStatement.executeLargeUpdate()
public long executeLargeUpdate() throws java.sql.SQLException
executeLargeUpdate
in interface java.sql.PreparedStatement
executeLargeUpdate
in class JdbcPreparedStatement
java.sql.SQLException
- if this object is closed or invalidpublic void registerOutParameter(int parameterIndex, int sqlType) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
parameterIndex
- the parameter index (1, 2, ...)sqlType
- the data type (Types.x) - ignoredjava.sql.SQLException
public void registerOutParameter(int parameterIndex, int sqlType, java.lang.String typeName) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
parameterIndex
- the parameter index (1, 2, ...)sqlType
- the data type (Types.x) - ignoredtypeName
- the SQL type name - ignoredjava.sql.SQLException
public void registerOutParameter(int parameterIndex, int sqlType, int scale) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
parameterIndex
- the parameter index (1, 2, ...)sqlType
- the data type (Types.x)scale
- is ignoredjava.sql.SQLException
public void registerOutParameter(java.lang.String parameterName, int sqlType, java.lang.String typeName) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
parameterName
- the parameter namesqlType
- the data type (Types.x) - ignoredtypeName
- the SQL type name - ignoredjava.sql.SQLException
public void registerOutParameter(java.lang.String parameterName, int sqlType, int scale) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
parameterName
- the parameter namesqlType
- the data type (Types.x) - ignoredscale
- is ignoredjava.sql.SQLException
public void registerOutParameter(java.lang.String parameterName, int sqlType) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
parameterName
- the parameter namesqlType
- the data type (Types.x) - ignoredjava.sql.SQLException
public boolean wasNull() throws java.sql.SQLException
wasNull
in interface java.sql.CallableStatement
java.sql.SQLException
public java.net.URL getURL(int parameterIndex) throws java.sql.SQLException
getURL
in interface java.sql.CallableStatement
java.sql.SQLException
public java.lang.String getString(int parameterIndex) throws java.sql.SQLException
getString
in interface java.sql.CallableStatement
parameterIndex
- (1,2,...)java.sql.SQLException
- if the column is not found or if this object is
closedpublic boolean getBoolean(int parameterIndex) throws java.sql.SQLException
getBoolean
in interface java.sql.CallableStatement
parameterIndex
- (1,2,...)java.sql.SQLException
- if the column is not found or if this object is
closedpublic byte getByte(int parameterIndex) throws java.sql.SQLException
getByte
in interface java.sql.CallableStatement
parameterIndex
- (1,2,...)java.sql.SQLException
- if the column is not found or if this object is
closedpublic short getShort(int parameterIndex) throws java.sql.SQLException
getShort
in interface java.sql.CallableStatement
parameterIndex
- (1,2,...)java.sql.SQLException
- if the column is not found or if this object is
closedpublic int getInt(int parameterIndex) throws java.sql.SQLException
getInt
in interface java.sql.CallableStatement
parameterIndex
- the parameter index (1, 2, ...)java.sql.SQLException
- if the column is not found or if this object is
closedpublic long getLong(int parameterIndex) throws java.sql.SQLException
getLong
in interface java.sql.CallableStatement
parameterIndex
- the parameter index (1, 2, ...)java.sql.SQLException
- if the column is not found or if this object is
closedpublic float getFloat(int parameterIndex) throws java.sql.SQLException
getFloat
in interface java.sql.CallableStatement
parameterIndex
- the parameter index (1, 2, ...)java.sql.SQLException
- if the column is not found or if this object is
closedpublic double getDouble(int parameterIndex) throws java.sql.SQLException
getDouble
in interface java.sql.CallableStatement
parameterIndex
- the parameter index (1, 2, ...)java.sql.SQLException
- if the column is not found or if this object is
closed@Deprecated public java.math.BigDecimal getBigDecimal(int parameterIndex, int scale) throws java.sql.SQLException
getBigDecimal(int)
getBigDecimal
in interface java.sql.CallableStatement
parameterIndex
- the parameter index (1, 2, ...)scale
- is ignoredjava.sql.SQLException
- if the column is not found or if this object is
closedpublic byte[] getBytes(int parameterIndex) throws java.sql.SQLException
getBytes
in interface java.sql.CallableStatement
parameterIndex
- the parameter index (1, 2, ...)java.sql.SQLException
- if the column is not found or if this object is
closedpublic java.sql.Date getDate(int parameterIndex) throws java.sql.SQLException
Usage of this method is discouraged. Use
getObject(columnIndex, LocalDate.class)
instead.
getDate
in interface java.sql.CallableStatement
parameterIndex
- the parameter index (1, 2, ...)java.sql.SQLException
- if the column is not found or if this object is
closedgetObject(int, Class)
public java.sql.Time getTime(int parameterIndex) throws java.sql.SQLException
Usage of this method is discouraged. Use
getObject(columnIndex, LocalTime.class)
instead.
getTime
in interface java.sql.CallableStatement
parameterIndex
- the parameter index (1, 2, ...)java.sql.SQLException
- if the column is not found or if this object is
closedgetObject(int, Class)
public java.sql.Timestamp getTimestamp(int parameterIndex) throws java.sql.SQLException
Usage of this method is discouraged. Use
getObject(columnIndex, LocalDateTime.class)
instead.
getTimestamp
in interface java.sql.CallableStatement
parameterIndex
- the parameter index (1, 2, ...)java.sql.SQLException
- if the column is not found or if this object is
closedgetObject(int, Class)
public java.lang.Object getObject(int parameterIndex) throws java.sql.SQLException
getObject
in interface java.sql.CallableStatement
parameterIndex
- the parameter index (1, 2, ...)java.sql.SQLException
- if the column is not found or if this object is
closedpublic java.math.BigDecimal getBigDecimal(int parameterIndex) throws java.sql.SQLException
getBigDecimal
in interface java.sql.CallableStatement
parameterIndex
- the parameter index (1, 2, ...)java.sql.SQLException
- if the column is not found or if this object is
closedpublic java.lang.Object getObject(int parameterIndex, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws java.sql.SQLException
getObject
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Ref getRef(int parameterIndex) throws java.sql.SQLException
getRef
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Blob getBlob(int parameterIndex) throws java.sql.SQLException
getBlob
in interface java.sql.CallableStatement
parameterIndex
- the parameter index (1, 2, ...)java.sql.SQLException
- if the column is not found or if this object is
closedpublic java.sql.Clob getClob(int parameterIndex) throws java.sql.SQLException
getClob
in interface java.sql.CallableStatement
parameterIndex
- the parameter index (1, 2, ...)java.sql.SQLException
- if the column is not found or if this object is
closedpublic java.sql.Array getArray(int parameterIndex) throws java.sql.SQLException
getArray
in interface java.sql.CallableStatement
parameterIndex
- the parameter index (1, 2, ...)java.sql.SQLException
- if the column is not found or if this object is
closedpublic java.sql.Date getDate(int parameterIndex, java.util.Calendar cal) throws java.sql.SQLException
Usage of this method is discouraged. Use
getObject(columnIndex, LocalDate.class)
instead.
getDate
in interface java.sql.CallableStatement
parameterIndex
- the parameter index (1, 2, ...)cal
- the calendarjava.sql.SQLException
- if the column is not found or if this object is
closedgetObject(int, Class)
public java.sql.Time getTime(int parameterIndex, java.util.Calendar cal) throws java.sql.SQLException
Usage of this method is discouraged. Use
getObject(columnIndex, LocalTime.class)
instead.
getTime
in interface java.sql.CallableStatement
parameterIndex
- the parameter index (1, 2, ...)cal
- the calendarjava.sql.SQLException
- if the column is not found or if this object is
closedgetObject(int, Class)
public java.sql.Timestamp getTimestamp(int parameterIndex, java.util.Calendar cal) throws java.sql.SQLException
Usage of this method is discouraged. Use
getObject(columnIndex, LocalDateTime.class)
instead.
getTimestamp
in interface java.sql.CallableStatement
parameterIndex
- the parameter index (1, 2, ...)cal
- the calendarjava.sql.SQLException
- if the column is not found or if this object is
closedgetObject(int, Class)
public java.net.URL getURL(java.lang.String parameterName) throws java.sql.SQLException
getURL
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Timestamp getTimestamp(java.lang.String parameterName, java.util.Calendar cal) throws java.sql.SQLException
Usage of this method is discouraged. Use
getObject(parameterName, LocalDateTime.class)
instead.
getTimestamp
in interface java.sql.CallableStatement
parameterName
- the parameter namecal
- the calendarjava.sql.SQLException
- if the column is not found or if this object is
closedgetObject(String, Class)
public java.sql.Time getTime(java.lang.String parameterName, java.util.Calendar cal) throws java.sql.SQLException
Usage of this method is discouraged. Use
getObject(parameterName, LocalTime.class)
instead.
getTime
in interface java.sql.CallableStatement
parameterName
- the parameter namecal
- the calendarjava.sql.SQLException
- if the column is not found or if this object is
closedgetObject(String, Class)
public java.sql.Date getDate(java.lang.String parameterName, java.util.Calendar cal) throws java.sql.SQLException
Usage of this method is discouraged. Use
getObject(parameterName, LocalDate.class)
instead.
getDate
in interface java.sql.CallableStatement
parameterName
- the parameter namecal
- the calendarjava.sql.SQLException
- if the column is not found or if this object is
closedgetObject(String, Class)
public java.sql.Array getArray(java.lang.String parameterName) throws java.sql.SQLException
getArray
in interface java.sql.CallableStatement
parameterName
- the parameter namejava.sql.SQLException
- if the column is not found or if this object is
closedpublic java.sql.Clob getClob(java.lang.String parameterName) throws java.sql.SQLException
getClob
in interface java.sql.CallableStatement
parameterName
- the parameter namejava.sql.SQLException
- if the column is not found or if this object is
closedpublic java.sql.Blob getBlob(java.lang.String parameterName) throws java.sql.SQLException
getBlob
in interface java.sql.CallableStatement
parameterName
- the parameter namejava.sql.SQLException
- if the column is not found or if this object is
closedpublic java.sql.Ref getRef(java.lang.String parameterName) throws java.sql.SQLException
getRef
in interface java.sql.CallableStatement
java.sql.SQLException
public java.lang.Object getObject(java.lang.String parameterName, java.util.Map<java.lang.String,java.lang.Class<?>> map) throws java.sql.SQLException
getObject
in interface java.sql.CallableStatement
java.sql.SQLException
public java.math.BigDecimal getBigDecimal(java.lang.String parameterName) throws java.sql.SQLException
getBigDecimal
in interface java.sql.CallableStatement
parameterName
- the parameter namejava.sql.SQLException
- if the column is not found or if this object is
closedpublic java.lang.Object getObject(java.lang.String parameterName) throws java.sql.SQLException
getObject
in interface java.sql.CallableStatement
parameterName
- the parameter namejava.sql.SQLException
- if the column is not found or if this object is
closedpublic java.sql.Timestamp getTimestamp(java.lang.String parameterName) throws java.sql.SQLException
Usage of this method is discouraged. Use
getObject(parameterName, LocalDateTime.class)
instead.
getTimestamp
in interface java.sql.CallableStatement
parameterName
- the parameter namejava.sql.SQLException
- if the column is not found or if this object is
closedgetObject(String, Class)
public java.sql.Time getTime(java.lang.String parameterName) throws java.sql.SQLException
Usage of this method is discouraged. Use
getObject(parameterName, LocalTime.class)
instead.
getTime
in interface java.sql.CallableStatement
parameterName
- the parameter namejava.sql.SQLException
- if the column is not found or if this object is
closedgetObject(String, Class)
public java.sql.Date getDate(java.lang.String parameterName) throws java.sql.SQLException
Usage of this method is discouraged. Use
getObject(parameterName, LocalDate.class)
instead.
getDate
in interface java.sql.CallableStatement
parameterName
- the parameter namejava.sql.SQLException
- if the column is not found or if this object is
closedgetObject(String, Class)
public byte[] getBytes(java.lang.String parameterName) throws java.sql.SQLException
getBytes
in interface java.sql.CallableStatement
parameterName
- the parameter namejava.sql.SQLException
- if the column is not found or if this object is
closedpublic double getDouble(java.lang.String parameterName) throws java.sql.SQLException
getDouble
in interface java.sql.CallableStatement
parameterName
- the parameter namejava.sql.SQLException
- if the column is not found or if this object is
closedpublic float getFloat(java.lang.String parameterName) throws java.sql.SQLException
getFloat
in interface java.sql.CallableStatement
parameterName
- the parameter namejava.sql.SQLException
- if the column is not found or if this object is
closedpublic long getLong(java.lang.String parameterName) throws java.sql.SQLException
getLong
in interface java.sql.CallableStatement
parameterName
- the parameter namejava.sql.SQLException
- if the column is not found or if this object is
closedpublic int getInt(java.lang.String parameterName) throws java.sql.SQLException
getInt
in interface java.sql.CallableStatement
parameterName
- the parameter namejava.sql.SQLException
- if the column is not found or if this object is
closedpublic short getShort(java.lang.String parameterName) throws java.sql.SQLException
getShort
in interface java.sql.CallableStatement
parameterName
- the parameter namejava.sql.SQLException
- if the column is not found or if this object is
closedpublic byte getByte(java.lang.String parameterName) throws java.sql.SQLException
getByte
in interface java.sql.CallableStatement
parameterName
- the parameter namejava.sql.SQLException
- if the column is not found or if this object is
closedpublic boolean getBoolean(java.lang.String parameterName) throws java.sql.SQLException
getBoolean
in interface java.sql.CallableStatement
parameterName
- the parameter namejava.sql.SQLException
- if the column is not found or if this object is
closedpublic java.lang.String getString(java.lang.String parameterName) throws java.sql.SQLException
getString
in interface java.sql.CallableStatement
parameterName
- the parameter namejava.sql.SQLException
- if the column is not found or if this object is
closedpublic java.sql.RowId getRowId(int parameterIndex) throws java.sql.SQLException
getRowId
in interface java.sql.CallableStatement
parameterIndex
- the parameter index (1, 2, ...)java.sql.SQLException
public java.sql.RowId getRowId(java.lang.String parameterName) throws java.sql.SQLException
getRowId
in interface java.sql.CallableStatement
parameterName
- the parameter namejava.sql.SQLException
public java.sql.NClob getNClob(int parameterIndex) throws java.sql.SQLException
getNClob
in interface java.sql.CallableStatement
parameterIndex
- the parameter index (1, 2, ...)java.sql.SQLException
- if the column is not found or if this object is
closedpublic java.sql.NClob getNClob(java.lang.String parameterName) throws java.sql.SQLException
getNClob
in interface java.sql.CallableStatement
parameterName
- the parameter namejava.sql.SQLException
- if the column is not found or if this object is
closedpublic java.sql.SQLXML getSQLXML(int parameterIndex) throws java.sql.SQLException
getSQLXML
in interface java.sql.CallableStatement
parameterIndex
- the parameter index (1, 2, ...)java.sql.SQLException
- if the column is not found or if this object is
closedpublic java.sql.SQLXML getSQLXML(java.lang.String parameterName) throws java.sql.SQLException
getSQLXML
in interface java.sql.CallableStatement
parameterName
- the parameter namejava.sql.SQLException
- if the column is not found or if this object is
closedpublic java.lang.String getNString(int parameterIndex) throws java.sql.SQLException
getNString
in interface java.sql.CallableStatement
parameterIndex
- the parameter index (1, 2, ...)java.sql.SQLException
- if the column is not found or if this object is
closedpublic java.lang.String getNString(java.lang.String parameterName) throws java.sql.SQLException
getNString
in interface java.sql.CallableStatement
parameterName
- the parameter namejava.sql.SQLException
- if the column is not found or if this object is
closedpublic java.io.Reader getNCharacterStream(int parameterIndex) throws java.sql.SQLException
getNCharacterStream
in interface java.sql.CallableStatement
parameterIndex
- the parameter index (1, 2, ...)java.sql.SQLException
- if the column is not found or if this object is
closedpublic java.io.Reader getNCharacterStream(java.lang.String parameterName) throws java.sql.SQLException
getNCharacterStream
in interface java.sql.CallableStatement
parameterName
- the parameter namejava.sql.SQLException
- if the column is not found or if this object is
closedpublic java.io.Reader getCharacterStream(int parameterIndex) throws java.sql.SQLException
getCharacterStream
in interface java.sql.CallableStatement
parameterIndex
- the parameter index (1, 2, ...)java.sql.SQLException
- if the column is not found or if this object is
closedpublic java.io.Reader getCharacterStream(java.lang.String parameterName) throws java.sql.SQLException
getCharacterStream
in interface java.sql.CallableStatement
parameterName
- the parameter namejava.sql.SQLException
- if the column is not found or if this object is
closedpublic void setNull(java.lang.String parameterName, int sqlType, java.lang.String typeName) throws java.sql.SQLException
setNull
in interface java.sql.CallableStatement
parameterName
- the parameter namesqlType
- the data type (Types.x)typeName
- this parameter is ignoredjava.sql.SQLException
- if this object is closedpublic void setNull(java.lang.String parameterName, int sqlType) throws java.sql.SQLException
setNull
in interface java.sql.CallableStatement
parameterName
- the parameter namesqlType
- the data type (Types.x)java.sql.SQLException
- if this object is closedpublic void setTimestamp(java.lang.String parameterName, java.sql.Timestamp x, java.util.Calendar cal) throws java.sql.SQLException
Usage of this method is discouraged. Use
setObject(parameterName, value)
with
LocalDateTime
parameter instead.
setTimestamp
in interface java.sql.CallableStatement
parameterName
- the parameter namex
- the valuecal
- the calendarjava.sql.SQLException
- if this object is closedsetObject(String, Object)
public void setTime(java.lang.String parameterName, java.sql.Time x, java.util.Calendar cal) throws java.sql.SQLException
Usage of this method is discouraged. Use
setObject(parameterName, value)
with LocalTime
parameter instead.
setTime
in interface java.sql.CallableStatement
parameterName
- the parameter namex
- the valuecal
- the calendarjava.sql.SQLException
- if this object is closedsetObject(String, Object)
public void setDate(java.lang.String parameterName, java.sql.Date x, java.util.Calendar cal) throws java.sql.SQLException
Usage of this method is discouraged. Use
setObject(parameterName, value)
with LocalDate
parameter instead.
setDate
in interface java.sql.CallableStatement
parameterName
- the parameter namex
- the valuecal
- the calendarjava.sql.SQLException
- if this object is closedsetObject(String, Object)
public void setCharacterStream(java.lang.String parameterName, java.io.Reader x, int length) throws java.sql.SQLException
setCharacterStream
in interface java.sql.CallableStatement
parameterName
- the parameter namex
- the valuelength
- the maximum number of charactersjava.sql.SQLException
- if this object is closedpublic void setObject(java.lang.String parameterName, java.lang.Object x) throws java.sql.SQLException
setObject
in interface java.sql.CallableStatement
parameterName
- the parameter namex
- the valuejava.sql.SQLException
- if this object is closedpublic void setObject(java.lang.String parameterName, java.lang.Object x, int targetSqlType) throws java.sql.SQLException
setObject
in interface java.sql.CallableStatement
parameterName
- the parameter namex
- the value, null is allowedtargetSqlType
- the type as defined in java.sql.Typesjava.sql.SQLException
- if this object is closedpublic void setObject(java.lang.String parameterName, java.lang.Object x, int targetSqlType, int scale) throws java.sql.SQLException
setObject
in interface java.sql.CallableStatement
parameterName
- the parameter namex
- the value, null is allowedtargetSqlType
- the type as defined in java.sql.Typesscale
- is ignoredjava.sql.SQLException
- if this object is closedpublic void setObject(java.lang.String parameterName, java.lang.Object x, java.sql.SQLType targetSqlType) throws java.sql.SQLException
setObject
in interface java.sql.CallableStatement
parameterName
- the parameter namex
- the value, null is allowedtargetSqlType
- the typejava.sql.SQLException
- if this object is closedpublic void setObject(java.lang.String parameterName, java.lang.Object x, java.sql.SQLType targetSqlType, int scaleOrLength) throws java.sql.SQLException
setObject
in interface java.sql.CallableStatement
parameterName
- the parameter namex
- the value, null is allowedtargetSqlType
- the typescaleOrLength
- is ignoredjava.sql.SQLException
- if this object is closedpublic void setBinaryStream(java.lang.String parameterName, java.io.InputStream x, int length) throws java.sql.SQLException
setBinaryStream
in interface java.sql.CallableStatement
parameterName
- the parameter namex
- the valuelength
- the maximum number of bytesjava.sql.SQLException
- if this object is closedpublic void setAsciiStream(java.lang.String parameterName, java.io.InputStream x, long length) throws java.sql.SQLException
setAsciiStream
in interface java.sql.CallableStatement
parameterName
- the parameter namex
- the valuelength
- the maximum number of bytesjava.sql.SQLException
- if this object is closedpublic void setTimestamp(java.lang.String parameterName, java.sql.Timestamp x) throws java.sql.SQLException
Usage of this method is discouraged. Use
setObject(parameterName, value)
with
LocalDateTime
parameter instead.
setTimestamp
in interface java.sql.CallableStatement
parameterName
- the parameter namex
- the valuejava.sql.SQLException
- if this object is closedsetObject(String, Object)
public void setTime(java.lang.String parameterName, java.sql.Time x) throws java.sql.SQLException
Usage of this method is discouraged. Use
setObject(parameterName, value)
with LocalTime
parameter instead.
setTime
in interface java.sql.CallableStatement
parameterName
- the parameter namex
- the valuejava.sql.SQLException
- if this object is closedsetObject(String, Object)
public void setDate(java.lang.String parameterName, java.sql.Date x) throws java.sql.SQLException
Usage of this method is discouraged. Use
setObject(parameterName, value)
with LocalDate
parameter instead.
setDate
in interface java.sql.CallableStatement
parameterName
- the parameter namex
- the valuejava.sql.SQLException
- if this object is closedsetObject(String, Object)
public void setBytes(java.lang.String parameterName, byte[] x) throws java.sql.SQLException
setBytes
in interface java.sql.CallableStatement
parameterName
- the parameter namex
- the valuejava.sql.SQLException
- if this object is closedpublic void setString(java.lang.String parameterName, java.lang.String x) throws java.sql.SQLException
setString
in interface java.sql.CallableStatement
parameterName
- the parameter namex
- the valuejava.sql.SQLException
- if this object is closedpublic void setBigDecimal(java.lang.String parameterName, java.math.BigDecimal x) throws java.sql.SQLException
setBigDecimal
in interface java.sql.CallableStatement
parameterName
- the parameter namex
- the valuejava.sql.SQLException
- if this object is closedpublic void setDouble(java.lang.String parameterName, double x) throws java.sql.SQLException
setDouble
in interface java.sql.CallableStatement
parameterName
- the parameter namex
- the valuejava.sql.SQLException
- if this object is closedpublic void setFloat(java.lang.String parameterName, float x) throws java.sql.SQLException
setFloat
in interface java.sql.CallableStatement
parameterName
- the parameter namex
- the valuejava.sql.SQLException
- if this object is closedpublic void setLong(java.lang.String parameterName, long x) throws java.sql.SQLException
setLong
in interface java.sql.CallableStatement
parameterName
- the parameter namex
- the valuejava.sql.SQLException
- if this object is closedpublic void setInt(java.lang.String parameterName, int x) throws java.sql.SQLException
setInt
in interface java.sql.CallableStatement
parameterName
- the parameter namex
- the valuejava.sql.SQLException
- if this object is closedpublic void setShort(java.lang.String parameterName, short x) throws java.sql.SQLException
setShort
in interface java.sql.CallableStatement
parameterName
- the parameter namex
- the valuejava.sql.SQLException
- if this object is closedpublic void setByte(java.lang.String parameterName, byte x) throws java.sql.SQLException
setByte
in interface java.sql.CallableStatement
parameterName
- the parameter namex
- the valuejava.sql.SQLException
- if this object is closedpublic void setBoolean(java.lang.String parameterName, boolean x) throws java.sql.SQLException
setBoolean
in interface java.sql.CallableStatement
parameterName
- the parameter namex
- the valuejava.sql.SQLException
- if this object is closedpublic void setURL(java.lang.String parameterName, java.net.URL val) throws java.sql.SQLException
setURL
in interface java.sql.CallableStatement
java.sql.SQLException
public void setRowId(java.lang.String parameterName, java.sql.RowId x) throws java.sql.SQLException
setRowId
in interface java.sql.CallableStatement
java.sql.SQLException
public void setNString(java.lang.String parameterName, java.lang.String x) throws java.sql.SQLException
setNString
in interface java.sql.CallableStatement
parameterName
- the parameter namex
- the valuejava.sql.SQLException
- if this object is closedpublic void setNCharacterStream(java.lang.String parameterName, java.io.Reader x, long length) throws java.sql.SQLException
setNCharacterStream
in interface java.sql.CallableStatement
parameterName
- the parameter namex
- the valuelength
- the maximum number of charactersjava.sql.SQLException
- if this object is closedpublic void setNClob(java.lang.String parameterName, java.sql.NClob x) throws java.sql.SQLException
setNClob
in interface java.sql.CallableStatement
parameterName
- the parameter namex
- the valuejava.sql.SQLException
- if this object is closedpublic void setClob(java.lang.String parameterName, java.io.Reader x, long length) throws java.sql.SQLException
setClob
in interface java.sql.CallableStatement
parameterName
- the parameter namex
- the valuelength
- the maximum number of charactersjava.sql.SQLException
- if this object is closedpublic void setBlob(java.lang.String parameterName, java.io.InputStream x, long length) throws java.sql.SQLException
setBlob
in interface java.sql.CallableStatement
parameterName
- the parameter namex
- the valuelength
- the maximum number of bytesjava.sql.SQLException
- if this object is closedpublic void setNClob(java.lang.String parameterName, java.io.Reader x, long length) throws java.sql.SQLException
setNClob
in interface java.sql.CallableStatement
parameterName
- the parameter namex
- the valuelength
- the maximum number of charactersjava.sql.SQLException
- if this object is closedpublic void setBlob(java.lang.String parameterName, java.sql.Blob x) throws java.sql.SQLException
setBlob
in interface java.sql.CallableStatement
parameterName
- the parameter namex
- the valuejava.sql.SQLException
- if this object is closedpublic void setClob(java.lang.String parameterName, java.sql.Clob x) throws java.sql.SQLException
setClob
in interface java.sql.CallableStatement
parameterName
- the parameter namex
- the valuejava.sql.SQLException
- if this object is closedpublic void setAsciiStream(java.lang.String parameterName, java.io.InputStream x) throws java.sql.SQLException
setAsciiStream
in interface java.sql.CallableStatement
parameterName
- the parameter namex
- the valuejava.sql.SQLException
- if this object is closedpublic void setAsciiStream(java.lang.String parameterName, java.io.InputStream x, int length) throws java.sql.SQLException
setAsciiStream
in interface java.sql.CallableStatement
parameterName
- the parameter namex
- the valuelength
- the maximum number of bytesjava.sql.SQLException
- if this object is closedpublic void setBinaryStream(java.lang.String parameterName, java.io.InputStream x) throws java.sql.SQLException
setBinaryStream
in interface java.sql.CallableStatement
parameterName
- the parameter namex
- the valuejava.sql.SQLException
- if this object is closedpublic void setBinaryStream(java.lang.String parameterName, java.io.InputStream x, long length) throws java.sql.SQLException
setBinaryStream
in interface java.sql.CallableStatement
parameterName
- the parameter namex
- the valuelength
- the maximum number of bytesjava.sql.SQLException
- if this object is closedpublic void setBlob(java.lang.String parameterName, java.io.InputStream x) throws java.sql.SQLException
setBlob
in interface java.sql.CallableStatement
parameterName
- the parameter namex
- the valuejava.sql.SQLException
- if this object is closedpublic void setCharacterStream(java.lang.String parameterName, java.io.Reader x) throws java.sql.SQLException
setCharacterStream
in interface java.sql.CallableStatement
parameterName
- the parameter namex
- the valuejava.sql.SQLException
- if this object is closedpublic void setCharacterStream(java.lang.String parameterName, java.io.Reader x, long length) throws java.sql.SQLException
setCharacterStream
in interface java.sql.CallableStatement
parameterName
- the parameter namex
- the valuelength
- the maximum number of charactersjava.sql.SQLException
- if this object is closedpublic void setClob(java.lang.String parameterName, java.io.Reader x) throws java.sql.SQLException
setClob
in interface java.sql.CallableStatement
parameterName
- the parameter namex
- the valuejava.sql.SQLException
- if this object is closedpublic void setNCharacterStream(java.lang.String parameterName, java.io.Reader x) throws java.sql.SQLException
setNCharacterStream
in interface java.sql.CallableStatement
parameterName
- the parameter namex
- the valuejava.sql.SQLException
- if this object is closedpublic void setNClob(java.lang.String parameterName, java.io.Reader x) throws java.sql.SQLException
setNClob
in interface java.sql.CallableStatement
parameterName
- the parameter namex
- the valuejava.sql.SQLException
- if this object is closedpublic void setSQLXML(java.lang.String parameterName, java.sql.SQLXML x) throws java.sql.SQLException
setSQLXML
in interface java.sql.CallableStatement
parameterName
- the parameter namex
- the valuejava.sql.SQLException
- if this object is closedpublic <T> T getObject(int parameterIndex, java.lang.Class<T> type) throws java.sql.SQLException
getObject
in interface java.sql.CallableStatement
parameterIndex
- the parameter index (1, 2, ...)type
- the class of the returned valuejava.sql.SQLException
- if the column is not found or if this object is
closedpublic <T> T getObject(java.lang.String parameterName, java.lang.Class<T> type) throws java.sql.SQLException
getObject
in interface java.sql.CallableStatement
parameterName
- the parameter nametype
- the class of the returned valuejava.sql.SQLException
- if the column is not found or if this object is
closed