Top Description Fields Constructors Methods
org.h2.jdbc

public final Class JdbcCallableStatement

extends JdbcPreparedStatement
implements CallableStatement
Class Inheritance
All Implemented Interfaces
java.sql.CallableStatement, java.sql.PreparedStatement, java.sql.Statement, java.lang.AutoCloseable, java.sql.Wrapper
Imports
java.io.InputStream, .Reader, java.math.BigDecimal, java.net.URL, java.sql.Array, .Blob, .CallableStatement, .Clob, .Date, .NClob, .Ref, .ResultSetMetaData, .RowId, .SQLException, .SQLType, .SQLXML, .Time, .Timestamp, java.util.BitSet, .Calendar, .HashMap, .Map, org.h2.api.ErrorCode, org.h2.expression.ParameterInterface, org.h2.message.DbException, .TraceObject, org.h2.value.ValueNull

Represents a callable statement.

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();
}
Authors
Sergi Vladykin, Thomas Mueller

Field Summary

Modifier and TypeField and Description
private int
private HashMap<String, Integer>
private BitSet
Inherited from org.h2.jdbc.JdbcPreparedStatement:
command

Constructor Summary

AccessConstructor and Description
pack-priv
JdbcCallableStatement(JdbcConnection conn, String sql, int id, int resultSetType, int resultSetConcurrency)

Method Summary

Modifier and TypeMethod and Description
private void
checkIndexBounds(int parameterIndex)

private void
checkRegistered(int parameterIndex)

public long

Returns:

the update count (number of row affected by an insert, update or delete, or 0 if no rows or the statement was a create, drop, commit or rollback)
executeLargeUpdate
()

Overrides org.h2.jdbc.JdbcPreparedStatement.executeLargeUpdate.

Overrides default java.sql.PreparedStatement.executeLargeUpdate.

Executes a statement (insert, update, delete, create, drop) and returns the update count.

public int

Returns:

the update count (number of row affected by an insert, update or delete, or 0 if no rows or the statement was a create, drop, commit or rollback)
executeUpdate
()

Overrides org.h2.jdbc.JdbcPreparedStatement.executeUpdate.

Implements java.sql.PreparedStatement.executeUpdate.

Executes a statement (insert, update, delete, create, drop) and returns the update count.

public Array

Returns:

the value
getArray
(int
the parameter index (1, 2, ...)
parameterIndex
)

Implements java.sql.CallableStatement.getArray.

Returns the value of the specified column as an Array.

public Array

Returns:

the value
getArray
(String
the parameter name
parameterName
)

Implements java.sql.CallableStatement.getArray.

Returns the value of the specified column as an Array.

public BigDecimal

Returns:

the value
getBigDecimal
(int
the parameter index (1, 2, ...)
parameterIndex
,
int
is ignored
scale
)

Implements java.sql.CallableStatement.getBigDecimal.

Deprecated use getBigDecimal(int)

Returns the value of the specified column as a BigDecimal.

public BigDecimal

Returns:

the value
getBigDecimal
(int
the parameter index (1, 2, ...)
parameterIndex
)

Implements java.sql.CallableStatement.getBigDecimal.

Returns the value of the specified column as a BigDecimal.

public BigDecimal

Returns:

the value
getBigDecimal
(String
the parameter name
parameterName
)

Implements java.sql.CallableStatement.getBigDecimal.

Returns the value of the specified column as a BigDecimal.

public Blob

Returns:

the value
getBlob
(int
the parameter index (1, 2, ...)
parameterIndex
)

Implements java.sql.CallableStatement.getBlob.

Returns the value of the specified column as a Blob.

public Blob

Returns:

the value
getBlob
(String
the parameter name
parameterName
)

Implements java.sql.CallableStatement.getBlob.

Returns the value of the specified column as a Blob.

public boolean

Returns:

the value
getBoolean
(int
(1,2,...)
parameterIndex
)

Implements java.sql.CallableStatement.getBoolean.

Returns the value of the specified column as a boolean.

public boolean

Returns:

the value
getBoolean
(String
the parameter name
parameterName
)

Implements java.sql.CallableStatement.getBoolean.

Returns the value of the specified column as a boolean.

public byte

Returns:

the value
getByte
(int
(1,2,...)
parameterIndex
)

Implements java.sql.CallableStatement.getByte.

Returns the value of the specified column as a byte.

public byte

Returns:

the value
getByte
(String
the parameter name
parameterName
)

Implements java.sql.CallableStatement.getByte.

Returns the value of the specified column as a byte.

public byte[]

Returns:

the value
getBytes
(int
the parameter index (1, 2, ...)
parameterIndex
)

Implements java.sql.CallableStatement.getBytes.

Returns the value of the specified column as a byte array.

public byte[]

Returns:

the value
getBytes
(String
the parameter name
parameterName
)

Implements java.sql.CallableStatement.getBytes.

Returns the value of the specified column as a byte array.

public Reader

Returns:

the value
getCharacterStream
(int
the parameter index (1, 2, ...)
parameterIndex
)

Implements java.sql.CallableStatement.getCharacterStream.

Returns the value of the specified column as a reader.

public Reader

Returns:

the value
getCharacterStream
(String
the parameter name
parameterName
)

Implements java.sql.CallableStatement.getCharacterStream.

Returns the value of the specified column as a reader.

private ResultSetMetaData
public Clob

Returns:

the value
getClob
(int
the parameter index (1, 2, ...)
parameterIndex
)

Implements java.sql.CallableStatement.getClob.

Returns the value of the specified column as a Clob.

public Clob

Returns:

the value
getClob
(String
the parameter name
parameterName
)

Implements java.sql.CallableStatement.getClob.

Returns the value of the specified column as a Clob.

public Date

Returns:

the value
getDate
(int
the parameter index (1, 2, ...)
parameterIndex
)

Implements java.sql.CallableStatement.getDate.

Returns the value of the specified column as a java.sql.Date.

public Date

Returns:

the value
getDate
(int
the parameter index (1, 2, ...)
parameterIndex
,
Calendar
the calendar
cal
)

Implements java.sql.CallableStatement.getDate.

Returns the value of the specified column as a java.sql.Date using a specified time zone.

public Date

Returns:

the value
getDate
(String
the parameter name
parameterName
,
Calendar
the calendar
cal
)

Implements java.sql.CallableStatement.getDate.

Returns the value of the specified column as a java.sql.Date using a specified time zone.

public Date

Returns:

the value
getDate
(String
the parameter name
parameterName
)

Implements java.sql.CallableStatement.getDate.

Returns the value of the specified column as a java.sql.Date.

public double

Returns:

the value
getDouble
(int
the parameter index (1, 2, ...)
parameterIndex
)

Implements java.sql.CallableStatement.getDouble.

Returns the value of the specified column as a double.

public double

Returns:

the value
getDouble
(String
the parameter name
parameterName
)

Implements java.sql.CallableStatement.getDouble.

Returns the value of the specified column as a double.

public float

Returns:

the value
getFloat
(int
the parameter index (1, 2, ...)
parameterIndex
)

Implements java.sql.CallableStatement.getFloat.

Returns the value of the specified column as a float.

public float

Returns:

the value
getFloat
(String
the parameter name
parameterName
)

Implements java.sql.CallableStatement.getFloat.

Returns the value of the specified column as a float.

private int
getIndexForName(String parameterName)

public int

Returns:

the value
getInt
(int
the parameter index (1, 2, ...)
parameterIndex
)

Implements java.sql.CallableStatement.getInt.

Returns the value of the specified column as an int.

public int

Returns:

the value
getInt
(String
the parameter name
parameterName
)

Implements java.sql.CallableStatement.getInt.

Returns the value of the specified column as an int.

public long

Returns:

the value
getLong
(int
the parameter index (1, 2, ...)
parameterIndex
)

Implements java.sql.CallableStatement.getLong.

Returns the value of the specified column as a long.

public long

Returns:

the value
getLong
(String
the parameter name
parameterName
)

Implements java.sql.CallableStatement.getLong.

Returns the value of the specified column as a long.

public Reader

Returns:

the value
getNCharacterStream
(int
the parameter index (1, 2, ...)
parameterIndex
)

Implements java.sql.CallableStatement.getNCharacterStream.

Returns the value of the specified column as a reader.

public Reader

Returns:

the value
getNCharacterStream
(String
the parameter name
parameterName
)

Implements java.sql.CallableStatement.getNCharacterStream.

Returns the value of the specified column as a reader.

public NClob

Returns:

the value
getNClob
(int
the parameter index (1, 2, ...)
parameterIndex
)

Implements java.sql.CallableStatement.getNClob.

Returns the value of the specified column as a Clob.

public NClob

Returns:

the value
getNClob
(String
the parameter name
parameterName
)

Implements java.sql.CallableStatement.getNClob.

Returns the value of the specified column as a Clob.

public String

Returns:

the value
getNString
(int
the parameter index (1, 2, ...)
parameterIndex
)

Implements java.sql.CallableStatement.getNString.

Returns the value of the specified column as a String.

public String

Returns:

the value
getNString
(String
the parameter name
parameterName
)

Implements java.sql.CallableStatement.getNString.

Returns the value of the specified column as a String.

public Object

Returns:

the value or null
getObject
(int
the parameter index (1, 2, ...)
parameterIndex
)

Implements java.sql.CallableStatement.getObject.

Returns a column value as a Java object.

public Object
getObject(int
the first parameter is 1, the second is 2, and so on
parameterIndex
,
Map<String, Class<?>>
the mapping from SQL type names to Java classes
map
)

Implements java.sql.CallableStatement.getObject.

[Not supported] Gets a column as a object using the specified type mapping.

public Object
getObject(String
the name of the parameter
parameterName
,
Map<String, Class<?>>
the mapping from SQL type names to Java classes
map
)

Implements java.sql.CallableStatement.getObject.

[Not supported] Gets a column as a object using the specified type mapping.

public Object

Returns:

the value or null
getObject
(String
the parameter name
parameterName
)

Implements java.sql.CallableStatement.getObject.

Returns a column value as a Java object.

public <T> T

Returns:

the value
getObject
(int
the parameter index (1, 2, ...)
parameterIndex
,
Class<T>
the class of the returned value
type
)

Implements java.sql.CallableStatement.getObject.

Returns the value of the specified column as a Java object of the specified type.

public <T> T

Returns:

the value
getObject
(String
the parameter name
parameterName
,
Class<T>
the class of the returned value
type
)

Implements java.sql.CallableStatement.getObject.

Returns the value of the specified column as a Java object of the specified type.

private JdbcResultSet
public Ref
getRef(int
the first parameter is 1, the second is 2, and so on
parameterIndex
)

Implements java.sql.CallableStatement.getRef.

[Not supported] Gets a column as a reference.

public Ref
getRef(String
the name of the parameter
parameterName
)

Implements java.sql.CallableStatement.getRef.

[Not supported] Gets a column as a reference.

public RowId
getRowId(int
the parameter index (1, 2, ...)
parameterIndex
)

Implements java.sql.CallableStatement.getRowId.

[Not supported] Returns the value of the specified column as a row id.

public RowId
getRowId(String
the parameter name
parameterName
)

Implements java.sql.CallableStatement.getRowId.

[Not supported] Returns the value of the specified column as a row id.

public short

Returns:

the value
getShort
(int
(1,2,...)
parameterIndex
)

Implements java.sql.CallableStatement.getShort.

Returns the value of the specified column as a short.

public short

Returns:

the value
getShort
(String
the parameter name
parameterName
)

Implements java.sql.CallableStatement.getShort.

Returns the value of the specified column as a short.

public SQLXML

Returns:

the value
getSQLXML
(int
the parameter index (1, 2, ...)
parameterIndex
)

Implements java.sql.CallableStatement.getSQLXML.

Returns the value of the specified column as a SQLXML object.

public SQLXML

Returns:

the value
getSQLXML
(String
the parameter name
parameterName
)

Implements java.sql.CallableStatement.getSQLXML.

Returns the value of the specified column as a SQLXML object.

public String

Returns:

the value
getString
(int
(1,2,...)
parameterIndex
)

Implements java.sql.CallableStatement.getString.

Returns the value of the specified column as a String.

public String

Returns:

the value
getString
(String
the parameter name
parameterName
)

Implements java.sql.CallableStatement.getString.

Returns the value of the specified column as a String.

public Time

Returns:

the value
getTime
(int
the parameter index (1, 2, ...)
parameterIndex
)

Implements java.sql.CallableStatement.getTime.

Returns the value of the specified column as a java.sql.Time.

public Time

Returns:

the value
getTime
(int
the parameter index (1, 2, ...)
parameterIndex
,
Calendar
the calendar
cal
)

Implements java.sql.CallableStatement.getTime.

Returns the value of the specified column as a java.sql.Time using a specified time zone.

public Time

Returns:

the value
getTime
(String
the parameter name
parameterName
,
Calendar
the calendar
cal
)

Implements java.sql.CallableStatement.getTime.

Returns the value of the specified column as a java.sql.Time using a specified time zone.

public Time

Returns:

the value
getTime
(String
the parameter name
parameterName
)

Implements java.sql.CallableStatement.getTime.

Returns the value of the specified column as a java.sql.Time.

public Timestamp

Returns:

the value
getTimestamp
(int
the parameter index (1, 2, ...)
parameterIndex
)

Implements java.sql.CallableStatement.getTimestamp.

Returns the value of the specified column as a java.sql.Timestamp.

public Timestamp

Returns:

the value
getTimestamp
(int
the parameter index (1, 2, ...)
parameterIndex
,
Calendar
the calendar
cal
)

Implements java.sql.CallableStatement.getTimestamp.

Returns the value of the specified column as a java.sql.Timestamp using a specified time zone.

public Timestamp

Returns:

the value
getTimestamp
(String
the parameter name
parameterName
,
Calendar
the calendar
cal
)

Implements java.sql.CallableStatement.getTimestamp.

Returns the value of the specified column as a java.sql.Timestamp using a specified time zone.

public Timestamp

Returns:

the value
getTimestamp
(String
the parameter name
parameterName
)

Implements java.sql.CallableStatement.getTimestamp.

Returns the value of the specified column as a java.sql.Timestamp.

public URL
getURL(int
the first parameter is 1, the second is 2,...
parameterIndex
)

Implements java.sql.CallableStatement.getURL.

[Not supported]

public URL
getURL(String
the name of the parameter
parameterName
)

Implements java.sql.CallableStatement.getURL.

[Not supported]

public void
registerOutParameter(int
the parameter index (1, 2, ...)
parameterIndex
,
int
the data type (Types.x) - ignored
sqlType
)

Implements java.sql.CallableStatement.registerOutParameter.

Registers the given OUT parameter.

public void
registerOutParameter(int
the parameter index (1, 2, ...)
parameterIndex
,
int
the data type (Types.x) - ignored
sqlType
,
String
the SQL type name - ignored
typeName
)

Implements java.sql.CallableStatement.registerOutParameter.

Registers the given OUT parameter.

public void
registerOutParameter(int
the parameter index (1, 2, ...)
parameterIndex
,
int
the data type (Types.x)
sqlType
,
int
is ignored
scale
)

Implements java.sql.CallableStatement.registerOutParameter.

Registers the given OUT parameter.

public void
registerOutParameter(String
the parameter name
parameterName
,
int
the data type (Types.x) - ignored
sqlType
,
String
the SQL type name - ignored
typeName
)

Implements java.sql.CallableStatement.registerOutParameter.

Registers the given OUT parameter.

public void
registerOutParameter(String
the parameter name
parameterName
,
int
the data type (Types.x) - ignored
sqlType
,
int
is ignored
scale
)

Implements java.sql.CallableStatement.registerOutParameter.

Registers the given OUT parameter.

public void
registerOutParameter(String
the parameter name
parameterName
,
int
the data type (Types.x) - ignored
sqlType
)

Implements java.sql.CallableStatement.registerOutParameter.

Registers the given OUT parameter.

private void
registerOutParameter(int parameterIndex)

public void
setAsciiStream(String
the parameter name
parameterName
,
InputStream
the value
x
,
long
the maximum number of bytes
length
)

Implements java.sql.CallableStatement.setAsciiStream.

Sets the value of a parameter as an ASCII stream.

public void
setAsciiStream(String
the parameter name
parameterName
,
InputStream
the value
x
)

Implements java.sql.CallableStatement.setAsciiStream.

Sets the value of a parameter as an ASCII stream.

public void
setAsciiStream(String
the parameter name
parameterName
,
InputStream
the value
x
,
int
the maximum number of bytes
length
)

Implements java.sql.CallableStatement.setAsciiStream.

Sets the value of a parameter as an ASCII stream.

public void
setBigDecimal(String
the parameter name
parameterName
,
BigDecimal
the value
x
)

Implements java.sql.CallableStatement.setBigDecimal.

Sets the value of a parameter.

public void
setBinaryStream(String
the parameter name
parameterName
,
InputStream
the value
x
,
int
the maximum number of bytes
length
)

Implements java.sql.CallableStatement.setBinaryStream.

Sets the value of a parameter as an input stream.

public void
setBinaryStream(String
the parameter name
parameterName
,
InputStream
the value
x
)

Implements java.sql.CallableStatement.setBinaryStream.

Sets the value of a parameter as an input stream.

public void
setBinaryStream(String
the parameter name
parameterName
,
InputStream
the value
x
,
long
the maximum number of bytes
length
)

Implements java.sql.CallableStatement.setBinaryStream.

Sets the value of a parameter as an input stream.

public void
setBlob(String
the parameter name
parameterName
,
InputStream
the value
x
,
long
the maximum number of bytes
length
)

Implements java.sql.CallableStatement.setBlob.

Sets the value of a parameter as a Blob.

public void
setBlob(String
the parameter name
parameterName
,
Blob
the value
x
)

Implements java.sql.CallableStatement.setBlob.

Sets the value of a parameter as a Blob.

public void
setBlob(String
the parameter name
parameterName
,
InputStream
the value
x
)

Implements java.sql.CallableStatement.setBlob.

Sets the value of a parameter as a Blob.

public void
setBoolean(String
the parameter name
parameterName
,
boolean
the value
x
)

Implements java.sql.CallableStatement.setBoolean.

Sets the value of a parameter.

public void
setByte(String
the parameter name
parameterName
,
byte
the value
x
)

Implements java.sql.CallableStatement.setByte.

Sets the value of a parameter.

public void
setBytes(String
the parameter name
parameterName
,
byte[]
the value
x
)

Implements java.sql.CallableStatement.setBytes.

Sets the value of a parameter as a byte array.

public void
setCharacterStream(String
the parameter name
parameterName
,
Reader
the value
x
,
int
the maximum number of characters
length
)

Implements java.sql.CallableStatement.setCharacterStream.

Sets the value of a parameter as a character stream.

public void
setCharacterStream(String
the parameter name
parameterName
,
Reader
the value
x
)

Implements java.sql.CallableStatement.setCharacterStream.

Sets the value of a parameter as a character stream.

public void
setCharacterStream(String
the parameter name
parameterName
,
Reader
the value
x
,
long
the maximum number of characters
length
)

Implements java.sql.CallableStatement.setCharacterStream.

Sets the value of a parameter as a character stream.

public void
setClob(String
the parameter name
parameterName
,
Reader
the value
x
,
long
the maximum number of characters
length
)

Implements java.sql.CallableStatement.setClob.

Sets the value of a parameter as a Clob.

public void
setClob(String
the parameter name
parameterName
,
Clob
the value
x
)

Implements java.sql.CallableStatement.setClob.

Sets the value of a parameter as a Clob.

public void
setClob(String
the parameter name
parameterName
,
Reader
the value
x
)

Implements java.sql.CallableStatement.setClob.

Sets the value of a parameter as a character stream.

public void
setDate(String
the parameter name
parameterName
,
Date
the value
x
,
Calendar
the calendar
cal
)

Implements java.sql.CallableStatement.setDate.

Sets the date using a specified time zone.

public void
setDate(String
the parameter name
parameterName
,
Date
the value
x
)

Implements java.sql.CallableStatement.setDate.

Sets the value of a parameter.

public void
setDouble(String
the parameter name
parameterName
,
double
the value
x
)

Implements java.sql.CallableStatement.setDouble.

Sets the value of a parameter.

public void
setFloat(String
the parameter name
parameterName
,
float
the value
x
)

Implements java.sql.CallableStatement.setFloat.

Sets the value of a parameter.

public void
setInt(String
the parameter name
parameterName
,
int
the value
x
)

Implements java.sql.CallableStatement.setInt.

Sets the value of a parameter.

public void
setLong(String
the parameter name
parameterName
,
long
the value
x
)

Implements java.sql.CallableStatement.setLong.

Sets the value of a parameter.

public void
setNCharacterStream(String
the parameter name
parameterName
,
Reader
the value
x
,
long
the maximum number of characters
length
)

Implements java.sql.CallableStatement.setNCharacterStream.

Sets the value of a parameter as a character stream.

public void
setNCharacterStream(String
the parameter name
parameterName
,
Reader
the value
x
)

Implements java.sql.CallableStatement.setNCharacterStream.

Sets the value of a parameter as a character stream.

public void
setNClob(String
the parameter name
parameterName
,
NClob
the value
x
)

Implements java.sql.CallableStatement.setNClob.

Sets the value of a parameter as a Clob.

public void
setNClob(String
the parameter name
parameterName
,
Reader
the value
x
,
long
the maximum number of characters
length
)

Implements java.sql.CallableStatement.setNClob.

Sets the value of a parameter as a Clob.

public void
setNClob(String
the parameter name
parameterName
,
Reader
the value
x
)

Implements java.sql.CallableStatement.setNClob.

Sets the value of a parameter as a Clob.

public void
setNString(String
the parameter name
parameterName
,
String
the value
x
)

Implements java.sql.CallableStatement.setNString.

Sets the value of a parameter.

public void
setNull(String
the parameter name
parameterName
,
int
the data type (Types.x)
sqlType
,
String
this parameter is ignored
typeName
)

Implements java.sql.CallableStatement.setNull.

Sets a parameter to null.

public void
setNull(String
the parameter name
parameterName
,
int
the data type (Types.x)
sqlType
)

Implements java.sql.CallableStatement.setNull.

Sets a parameter to null.

public void
setObject(String
the parameter name
parameterName
,
Object
the value
x
)

Implements java.sql.CallableStatement.setObject.

Sets the value of a parameter.

public void
setObject(String
the parameter name
parameterName
,
Object
the value, null is allowed
x
,
int
the type as defined in java.sql.Types
targetSqlType
)

Implements java.sql.CallableStatement.setObject.

Sets the value of a parameter.

public void
setObject(String
the parameter name
parameterName
,
Object
the value, null is allowed
x
,
int
the type as defined in java.sql.Types
targetSqlType
,
int
is ignored
scale
)

Implements java.sql.CallableStatement.setObject.

Sets the value of a parameter.

public void
setObject(String
the parameter name
parameterName
,
Object
the value, null is allowed
x
,
SQLType
the type
targetSqlType
)

Overrides default java.sql.CallableStatement.setObject.

Sets the value of a parameter.

public void
setObject(String
the parameter name
parameterName
,
Object
the value, null is allowed
x
,
SQLType
the type
targetSqlType
,
int
is ignored
scaleOrLength
)

Overrides default java.sql.CallableStatement.setObject.

Sets the value of a parameter.

public void
setRowId(String
the name of the parameter
parameterName
,
RowId
the parameter value
x
)

Implements java.sql.CallableStatement.setRowId.

[Not supported] Sets the value of a parameter as a row id.

public void
setShort(String
the parameter name
parameterName
,
short
the value
x
)

Implements java.sql.CallableStatement.setShort.

Sets the value of a parameter.

public void
setSQLXML(String
the parameter name
parameterName
,
SQLXML
the value
x
)

Implements java.sql.CallableStatement.setSQLXML.

Sets the value of a parameter as a SQLXML object.

public void
setString(String
the parameter name
parameterName
,
String
the value
x
)

Implements java.sql.CallableStatement.setString.

Sets the value of a parameter.

public void
setTime(String
the parameter name
parameterName
,
Time
the value
x
,
Calendar
the calendar
cal
)

Implements java.sql.CallableStatement.setTime.

Sets the time using a specified time zone.

public void
setTime(String
the parameter name
parameterName
,
Time
the value
x
)

Implements java.sql.CallableStatement.setTime.

Sets the time using a specified time zone.

public void
setTimestamp(String
the parameter name
parameterName
,
Timestamp
the value
x
,
Calendar
the calendar
cal
)

Implements java.sql.CallableStatement.setTimestamp.

Sets the timestamp using a specified time zone.

public void
setTimestamp(String
the parameter name
parameterName
,
Timestamp
the value
x
)

Implements java.sql.CallableStatement.setTimestamp.

Sets the value of a parameter.

public void
setURL(String
the name of the parameter
parameterName
,
URL
the parameter value
val
)

Implements java.sql.CallableStatement.setURL.

[Not supported]

public boolean

Returns:

true if the last column accessed was null
wasNull
()

Implements java.sql.CallableStatement.wasNull.

Returns whether the last column accessed was null.

Inherited from org.h2.jdbc.JdbcPreparedStatement:
addBatchaddBatchclearBatchclearParameterscloseexecuteexecuteBatchexecuteLargeBatchexecuteQueryexecuteQuerygetMetaDatagetParameterMetaDatasetArraysetAsciiStreamsetAsciiStreamsetAsciiStreamsetBigDecimalsetBinaryStreamsetBinaryStreamsetBinaryStreamsetBlobsetBlobsetBlobsetBooleansetBytesetBytessetCachedColumnLabelMapsetCharacterStreamsetCharacterStreamsetCharacterStreamsetClobsetClobsetClobsetDatesetDatesetDoublesetFloatsetIntsetLongsetNCharacterStreamsetNCharacterStreamsetNClobsetNClobsetNClobsetNStringsetNullsetNullsetObjectsetObjectsetObjectsetObjectsetObjectsetRefsetRowIdsetShortsetSQLXMLsetStringsetTimesetTimesetTimestampsetTimestampsetUnicodeStreamsetURLtoString