The idea behind the logical prepared statement is to allow reuse of the
physical callable statement. In general the logical entity will forward all
calls to the physical entity. A few methods have special implementations, the
most important one being close. Each method will check that the
logical statement is still open before the call is forwarded to the
underlying physical statement.
LogicalStatementEntity
| Access | Constructor and Description |
|---|---|
| public | LogicalCallableStatement(CallableStatement
underlying physical statement physicalCs, StatementKey key for the physical statement stmtKey, StatementCacheInteractor creating statement cache interactor cacheInteractor)Creates a new logical callable statement. |
| Modifier and Type | Method and Description |
|---|---|
| public Array | getArray(int
the first parameter is 1, the second is 2, and
so on i)Implements java. ARRAY parameter as an
java.sql.Array object in the Java programming language.
|
| public Array | getArray(String
the name of the parameter parameterName)Implements java. ARRAY parameter as an
java.sql.Array object in the Java programming language.
|
| public BigDecimal | getBigDecimal(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. NUMERIC parameter as a
java.math.BigDecimal object with as many digits to the
right of the decimal point as the value contains.
|
| public BigDecimal | getBigDecimal(int
the first parameter is 1, the second is 2,
and so on parameterIndex, int the number of digits to the right of the decimal point scale)Implements java.
Deprecated
Retrieves the value of the designated JDBC NUMERIC parameter as a
java.math.BigDecimal object with scale digits to
the right of the decimal point.
|
| public BigDecimal | getBigDecimal(String
the name of the parameter parameterName)Implements java. NUMERIC parameter as a
java.math.BigDecimal object with as many digits to the
right of the decimal point as the value contains.
|
| public Blob | getBlob(int
the first parameter is 1, the second is 2, and so on i)Implements java. BLOB parameter as a
java.sql.Blob object in the Java programming language.
|
| public Blob | getBlob(String
the name of the parameter parameterName)Implements java. BLOB parameter as a
java.sql.Blob object in the Java programming language.
|
| public boolean | getBoolean(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. BIT
or BOOLEAN parameter as a
boolean in the Java programming language.
|
| public boolean | getBoolean(String
the name of the parameter parameterName)Implements java. BIT or BOOLEAN
parameter as a
boolean in the Java programming language.
|
| public byte | getByte(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. TINYINT parameter
as a byte in the Java programming language.
|
| public byte | getByte(String
the name of the parameter parameterName)Implements java. TINYINT parameter as a byte
in the Java programming language.
|
| public byte[] | getBytes(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. BINARY or
VARBINARY parameter as an array of byte
values in the Java programming language.
|
| public byte[] | getBytes(String
the name of the parameter parameterName)Implements java. BINARY or VARBINARY
parameter as an array of byte values in the Java
programming language.
|
| public Reader | getCharacterStream(int
the first parameter is 1, the second is 2, ... arg0)Implements java. java.io.Reader object in the Java programming language.
|
| public Reader | getCharacterStream(String
the name of the parameter arg0)Implements java. java.io.Reader object in the Java programming language.
|
| public Clob | getClob(int
the first parameter is 1, the second is 2, and
so on i)Implements java. CLOB parameter as a
java.sql.Clob object in the Java programming language.
|
| public Clob | getClob(String
the name of the parameter parameterName)Implements java. CLOB parameter as a
java.sql.Clob object in the Java programming language.
|
| public Date | getDate(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. DATE parameter as a
java.sql.Date object.
|
| public Date | getDate(String
the name of the parameter parameterName)Implements java. DATE parameter as a
java.sql.Date object.
|
| public Date | getDate(int
the first parameter is 1, the second is 2,
and so on parameterIndex, Calendar the cal)Calendar object the driver will use
to construct the dateImplements java. DATE parameter as a
java.sql.Date object, using
the given Calendar object
to construct the date.
|
| public Date | getDate(String
the name of the parameter parameterName, Calendar the cal)Calendar object the driver will use
to construct the dateImplements java. DATE parameter as a
java.sql.Date object, using
the given Calendar object
to construct the date.
|
| public double | getDouble(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. DOUBLE parameter as a double
in the Java programming language.
|
| public double | getDouble(String
the name of the parameter parameterName)Implements java. DOUBLE parameter as a double
in the Java programming language.
|
| public float | getFloat(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. FLOAT parameter
as a float in the Java programming language.
|
| public float | getFloat(String
the name of the parameter parameterName)Implements java. FLOAT parameter as a float
in the Java programming language.
|
| public int | getInt(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. INTEGER parameter
as an int in the Java programming language.
|
| public int | getInt(String
the name of the parameter parameterName)Implements java. INTEGER parameter as an int
in the Java programming language.
|
| public long | getLong(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. BIGINT parameter
as a long in the Java programming language.
|
| public long | getLong(String
the name of the parameter parameterName)Implements java. BIGINT parameter as a long
in the Java programming language.
|
| public Reader | getNCharacterStream(int
the first parameter is 1, the second is 2, ... arg0)Implements java. java.io.Reader object in the Java programming language.
|
| public Reader | getNCharacterStream(String
the name of the parameter arg0)Implements java. java.io.Reader object in the Java programming language.
|
| public NClob | getNClob(int
the first parameter is 1, the second is 2, and
so on arg0)Implements java. NCLOB parameter as a
java.sql.NClob object in the Java programming language.
|
| public NClob | getNClob(String
the name of the parameter arg0)Implements java. NCLOB parameter as a
java.sql.NClob object in the Java programming language.
|
| public String | getNString(int
index of the first parameter is 1, the second is 2, ... arg0)Implements java. NCHAR,
NVARCHAR
or LONGNVARCHAR parameter as
a String in the Java programming language.
|
| public String | getNString(String
the name of the parameter arg0)Implements java. NCHAR,
NVARCHAR
or LONGNVARCHAR parameter as
a String in the Java programming language.
|
| public Object | getObject(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. Object
in the Java programming language.
|
| public Object | getObject(String
the name of the parameter parameterName)Implements java. Object in the Java
programming language.
|
| public Object | getObject(int
the first parameter is 1, the second is 2, and so on i, Map<String, Class<?>> the mapping from SQL type names to Java classes map)Implements java. parameterIndex and uses map for the custom
mapping of the parameter value.
|
| 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. parameterName and uses map for the custom
mapping of the parameter value.
|
| public <T> T | getObject(int
the first parameter is 1, the second is 2, and so on parameterIndex, Class<T> Class representing the Java data type to convert the
designated parameter to. type)Implements java. parameterIndex and will convert from the
SQL type of the parameter to the requested Java data type, if the
conversion is supported.
|
| public <T> T | getObject(String
the name of the parameter parameterName, Class<T> Class representing the Java data type to convert
the designated parameter to. type)Implements java. parameterName and will convert from the
SQL type of the parameter to the requested Java data type, if the
conversion is supported.
|
| public Ref | getRef(int
the first parameter is 1, the second is 2,
and so on i)Implements java. REF(<structured-type>)
parameter as a java.sql.Ref object in the Java programming language.
|
| public Ref | getRef(String
the name of the parameter parameterName)Implements java. REF(<structured-type>)
parameter as a java.sql.Ref object in the Java programming language.
|
| public RowId | getRowId(int
the first parameter is 1, the second is 2,... arg0)Implements java. ROWID parameter as a
java.sql.RowId object.
|
| public RowId | getRowId(String
the name of the parameter arg0)Implements java. ROWID parameter as a
java.sql.RowId object.
|
| public short | getShort(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. SMALLINT parameter
as a short in the Java programming language.
|
| public short | getShort(String
the name of the parameter parameterName)Implements java. SMALLINT parameter as a short
in the Java programming language.
|
| public SQLXML | getSQLXML(int
index of the first parameter is 1, the second is 2, ... arg0)Implements java. SQL XML parameter as a
java.sql.SQLXML object in the Java programming language.
|
| public SQLXML | getSQLXML(String
the name of the parameter arg0)Implements java. SQL XML parameter as a
java.sql.SQLXML object in the Java programming language.
|
| public String | getString(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. CHAR,
VARCHAR, or LONGVARCHAR parameter as a
String in the Java programming language.
|
| public String | getString(String
the name of the parameter parameterName)Implements java. CHAR, VARCHAR,
or LONGVARCHAR parameter as a String in
the Java programming language.
|
| public Time | getTime(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. TIME parameter as a
java.sql.Time object.
|
| public Time | getTime(String
the name of the parameter parameterName)Implements java. TIME parameter as a
java.sql.Time object.
|
| public Time | getTime(int
the first parameter is 1, the second is 2,
and so on parameterIndex, Calendar the cal)Calendar object the driver will use
to construct the timeImplements java. TIME parameter as a
java.sql.Time object, using
the given Calendar object
to construct the time.
|
| public Time | getTime(String
the name of the parameter parameterName, Calendar the cal)Calendar object the driver will use
to construct the timeImplements java. TIME parameter as a
java.sql.Time object, using
the given Calendar object
to construct the time.
|
| public Timestamp | getTimestamp(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. TIMESTAMP parameter as a
java.sql.Timestamp object.
|
| public Timestamp | getTimestamp(String
the name of the parameter parameterName)Implements java. TIMESTAMP parameter as a
java.sql.Timestamp object.
|
| public Timestamp | getTimestamp(int
the first parameter is 1, the second is 2,
and so on parameterIndex, Calendar the cal)Calendar object the driver will use
to construct the timestampImplements java. TIMESTAMP parameter as a
java.sql.Timestamp object, using
the given Calendar object to construct
the Timestamp object.
|
| public Timestamp | getTimestamp(String
the name of the parameter parameterName, Calendar the cal)Calendar object the driver will use
to construct the timestampImplements java. TIMESTAMP parameter as a
java.sql.Timestamp object, using
the given Calendar object to construct
the Timestamp object.
|
| public URL | getURL(int
the first parameter is 1, the second is 2,... parameterIndex)Implements java. DATALINK parameter as a
java.net.URL object.
|
| public URL | getURL(String
the name of the parameter parameterName)Implements java. DATALINK parameter as a
java.net.URL object.
|
| public void | registerOutParameter(int
the first parameter is 1, the second is 2,
and so on parameterIndex, int the JDBC type code defined by sqlType)java.sql.Types.
If the parameter is of JDBC type NUMERIC
or DECIMAL, the version of
registerOutParameter that accepts a scale value
should be used.Implements java. parameterIndex to the JDBC type
sqlType.
|
| public void | registerOutParameter(int
the first parameter is 1, the second is 2,
and so on parameterIndex, int the SQL type code defined by sqlType, int java.sql.Types.the desired number of digits to the right of the
decimal point. It must be greater than or equal to zero. scale)Implements java. parameterIndex to be of JDBC type
sqlType.
|
| public void | registerOutParameter(int
the first parameter is 1, the second is 2,... paramIndex, int a value from sqlType, String java.sql.Typesthe fully-qualified name of an SQL structured type typeName)Implements java. |
| public void | registerOutParameter(String
the name of the parameter parameterName, int the JDBC type code defined by sqlType)java.sql.Types.
If the parameter is of JDBC type NUMERIC
or DECIMAL, the version of
registerOutParameter that accepts a scale value
should be used.Implements java. parameterName to the JDBC type
sqlType.
|
| public void | registerOutParameter(String
the name of the parameter parameterName, int SQL type code defined by sqlType, int java.sql.Types.the desired number of digits to the right of the
decimal point. It must be greater than or equal to zero. scale)Implements java. parameterName to be of JDBC type
sqlType.
|
| public void | registerOutParameter(String
the name of the parameter parameterName, int a value from sqlType, String java.sql.Typesthe fully-qualified name of an SQL structured type typeName)Implements java. |
| public void | setAsciiStream(String
the name of the parameter parameterName, InputStream the Java input stream that contains the ASCII parameter value x, int the number of bytes in the stream length)Implements java. |
| public void | setAsciiStream(String
the name of the parameter arg0, InputStream the Java input stream that contains the ASCII parameter value arg1, long the number of bytes in the stream arg2)Implements java. |
| public void | setAsciiStream(String
the name of the parameter arg0, InputStream the Java input stream that contains the ASCII parameter value arg1)Implements java. |
| public void | setBigDecimal(String
the name of the parameter parameterName, BigDecimal the parameter value x)Implements java. java.math.BigDecimal value.
|
| public void | setBinaryStream(String
the name of the parameter parameterName, InputStream the java input stream which contains the binary parameter value x, int the number of bytes in the stream length)Implements java. |
| public void | setBinaryStream(String
the name of the parameter arg0, InputStream the java input stream which contains the binary parameter value arg1, long the number of bytes in the stream arg2)Implements java. |
| public void | setBinaryStream(String
the name of the parameter arg0, InputStream the java input stream which contains the binary parameter value arg1)Implements java. |
| public void | setBlob(String
the name of the parameter to be set
the second is 2, ... arg0, InputStream An object that contains the data to set the parameter
value to. arg1, long the number of bytes in the parameter data. arg2)Implements java. InputStream object.
|
| public void | setBlob(String
the name of the parameter arg0, Blob a arg1)Blob object that maps an SQL BLOB valueImplements java. java.sql.Blob object.
|
| public void | setBlob(String
the name of the parameter arg0, InputStream An object that contains the data to set the parameter
value to. arg1)Implements java. InputStream object.
|
| public void | setBoolean(String
the name of the parameter parameterName, boolean the parameter value x)Implements java. boolean value.
|
| public void | setByte(String
the name of the parameter parameterName, byte the parameter value x)Implements java. byte value.
|
| public void | setBytes(String
the name of the parameter parameterName, byte[] the parameter value x)Implements java. |
| public void | setCharacterStream(String
the name of the parameter parameterName, Reader the reader, int java.io.Reader object that
contains the UNICODE data used as the designated parameterthe number of characters in the stream length)Implements java. Reader
object, which is the given number of characters long.
|
| public void | setCharacterStream(String
the name of the parameter arg0, Reader the arg1, long java.io.Reader object that
contains the UNICODE data used as the designated parameterthe number of characters in the stream arg2)Implements java. Reader
object, which is the given number of characters long.
|
| public void | setCharacterStream(String
the name of the parameter arg0, Reader the arg1)java.io.Reader object that contains the
Unicode dataImplements java. Reader
object.
|
| public void | setClob(String
the name of the parameter to be set arg0, Reader An object that contains the data to set the parameter value to. arg1, long the number of characters in the parameter data. arg2)Implements java. Reader object.
|
| public void | setClob(String
the name of the parameter arg0, Clob a arg1)Clob object that maps an SQL CLOB valueImplements java. java.sql.Clob object.
|
| public void | setClob(String
the name of the parameter arg0, Reader An object that contains the data to set the parameter value to. arg1)Implements java. Reader object.
|
| public void | setDate(String
the name of the parameter parameterName, Date the parameter value x)Implements java. java.sql.Date value
using the default time zone of the virtual machine that is running
the application.
|
| public void | setDate(String
the name of the parameter parameterName, Date the parameter value x, Calendar the cal)Calendar object the driver will use
to construct the dateImplements java. java.sql.Date value,
using the given Calendar object.
|
| public void | setDouble(String
the name of the parameter parameterName, double the parameter value x)Implements java. double value.
|
| public void | setFloat(String
the name of the parameter parameterName, float the parameter value x)Implements java. float value.
|
| public void | setInt(String
the name of the parameter parameterName, int the parameter value x)Implements java. int value.
|
| public void | setLong(String
the name of the parameter parameterName, long the parameter value x)Implements java. long value.
|
| public void | setNCharacterStream(String
the name of the parameter to be set arg0, Reader the parameter value arg1, long the number of characters in the parameter data. arg2)Implements java. Reader object.
|
| public void | setNCharacterStream(String
the name of the parameter arg0, Reader the parameter value arg1)Implements java. Reader object.
|
| public void | setNClob(String
the name of the parameter to be set arg0, NClob the parameter value arg1)Implements java. java.sql.NClob object.
|
| public void | setNClob(String
the name of the parameter to be set arg0, Reader An object that contains the data to set the parameter value to. arg1, long the number of characters in the parameter data. arg2)Implements java. Reader object.
|
| public void | setNClob(String
the name of the parameter arg0, Reader An object that contains the data to set the parameter value to. arg1)Implements java. Reader object.
|
| public void | setNString(String
the name of the parameter to be set arg0, String the parameter value arg1)Implements java. String object.
|
| public void | setNull(String
the name of the parameter parameterName, int the SQL type code defined in sqlType)java.sql.TypesImplements java. NULL.
|
| public void | setNull(String
the name of the parameter parameterName, int a value from sqlType, String java.sql.Typesthe fully-qualified name of an SQL user-defined type;
ignored if the parameter is not a user-defined type or
SQL typeName)REF valueImplements java. NULL.
|
| public void | setObject(String
the name of the parameter parameterName, Object the object containing the input parameter value x)Implements java. |
| public void | setObject(String
the name of the parameter parameterName, Object the object containing the input parameter value x, int the SQL type (as defined in java.sql.Types) to be
sent to the database targetSqlType)Implements java. |
| public void | setObject(String
the name of the parameter parameterName, Object the object containing the input parameter value x, int the SQL type (as defined in java.sql.Types) to be
sent to the database. The scale argument may further qualify this type. targetSqlType, int 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. scale)Implements java. |
| public void | setRowId(String
the name of the parameter arg0, RowId the parameter value arg1)Implements java. java.sql.RowId object.
|
| public void | setShort(String
the name of the parameter parameterName, short the parameter value x)Implements java. short value.
|
| public void | setSQLXML(String
the name of the parameter arg0, SQLXML a arg1)SQLXML object that maps an SQL XML valueImplements java. java.sql.SQLXML object.
|
| public void | setString(String
the name of the parameter parameterName, String the parameter value x)Implements java. String value.
|
| public void | setTime(String
the name of the parameter parameterName, Time the parameter value x)Implements java. java.sql.Time value.
|
| public void | setTime(String
the name of the parameter parameterName, Time the parameter value x, Calendar the cal)Calendar object the driver will use
to construct the timeImplements java. java.sql.Time value,
using the given Calendar object.
|
| public void | setTimestamp(String
the name of the parameter parameterName, Timestamp the parameter value x)Implements java. java.sql.Timestamp value.
|
| public void | setTimestamp(String
the name of the parameter parameterName, Timestamp the parameter value x, Calendar the cal)Calendar object the driver will use
to construct the timestampImplements java. java.sql.Timestamp value,
using the given Calendar object.
|
| public void | setURL(String
the name of the parameter parameterName, URL the parameter value val)Implements java. java.net.URL object.
|
| public boolean | wasNull()
Implements java. NULL.
|