| Modifier and Type | Field and Description |
|---|---|
| public MaterialPreparedStatement | |
| private static final int | |
| private static final int | |
| private static final int | |
| private int |
| Access | Constructor and Description |
|---|---|
| public | ClientCallableStatement(Agent
The instance of NetAgent associated with this
CallableStatement object. agent, ClientConnection The connection object associated with this
PreparedStatement Object. connection, String A String object that is the SQL statement to be sent
to the database. sql, int One of the ResultSet type constants type, int One of the ResultSet concurrency constants concurrency, int One of the ResultSet holdability constants holdability, ClientPooledConnection The PooledConnection object that will be used to
notify the PooledConnection reference of the Error
Occurred and the Close events. cpc)Common constructor for jdbc 2 callable statements with scroll attributes. |
| Modifier and Type | Method and Description |
|---|---|
| private void | |
| private void | |
| public void | clearParameters()
Overrides org. Implements java. |
| public void | completeExecuteCall(Sqlca sqlca, Cursor singletonParams)
Overrides org. Implements org. |
| protected void | finalize()
Overrides org. |
| public Array | getArray(int
the first parameter is 1, the second is 2, and
so on parameterIndex)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, 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(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(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 parameterIndex)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.
|
| pack-priv byte[] | |
| public Reader | getCharacterStream(int
the first parameter is 1, the second is 2, ... parameterIndex)Implements java. java.io.Reader object in the Java programming language.
|
| public Reader | getCharacterStream(String
the name of the parameter parameterName)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 parameterIndex)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, 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(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(String
the name of the parameter parameterName, Calendar the calendar)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.
|
| pack-priv int | |
| protected String | Returns: name of java.sql interfaceOverrides org. |
| 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.
|
| pack-priv long | |
| public Reader | getNCharacterStream(int
the first parameter is 1, the second is 2, ... parameterIndex)Implements java. java.io.Reader object in the Java programming language.
|
| public Reader | getNCharacterStream(String
the name of the parameter parameterName)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 i)Implements java. NCLOB parameter as a
java.sql.NClob object in the Java programming language.
|
| public NClob | getNClob(String
the name of the parameter parameterName)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, ... parameterIndex)Implements java. NCHAR,
NVARCHAR
or LONGNVARCHAR parameter as
a String in the Java programming language.
|
| public String | getNString(String
the name of the parameter parameterIndex)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(int
the first parameter is 1, the second is 2, and so on parameterIndex, Map<K, V> 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)Implements java. Object in the Java
programming language.
|
| public Object | getObject(String
the name of the parameter parameterName, Map<K, V> 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 parameterIndex)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,... parameterIndex)Implements java. ROWID parameter as a
java.sql.RowId object.
|
| public RowId | getRowId(String
the name of the parameter parameterName)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, ... parameterIndex)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 parametername)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.
|
| pack-priv String | |
| 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(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(String
the name of the parameter parameterName, Calendar the calendar)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, 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(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(String
the name of the parameter parameterName, Calendar the calendar)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.
|
| private void | |
| pack-priv SQLException | |
| private SQLException | |
| public void | registerOutParameter(int
the first parameter is 1, the second is 2,
and so on parameterIndex, int the JDBC type code defined by jdbcType)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 jdbcType, 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,... parameterIndex, int a value from jdbcType, 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. |
| pack-priv void | |
| private void | |
| public void | |
| public void | resetCallableStatement(Agent agent, ClientConnection connection, String sql, int type, int concurrency, int holdability)
|
| 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 final void | setAsciiStream(String
the name of the parameter parameterName, InputStream the Java input stream that contains the ASCII parameter value x, long the number of bytes in the stream length)Implements java. |
| public void | setAsciiStream(String
the name of the parameter parameterName, InputStream the Java input stream that contains the ASCII parameter value x)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 final void | setBinaryStream(String
the name of the parameter parameterName, InputStream the java input stream which contains the binary parameter value x, long the number of bytes in the stream length)Implements java. |
| public void | setBinaryStream(String
the name of the parameter parameterName, InputStream the java input stream which contains the binary parameter value x)Implements java. |
| public void | setBlob(String
the name of the parameter parameterName, Blob a x)Blob object that maps an SQL BLOB valueImplements java. java.sql.Blob object.
|
| public void | setBlob(String
the name of the parameter to be set
the second is 2, ... parameterName, InputStream An object that contains the data to set the parameter
value to. inputStream, long the number of bytes in the parameter data. length)Implements java. InputStream object.
|
| public void | setBlob(String
the name of the parameter parameterName, InputStream An object that contains the data to set the parameter
value to. inputStream)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 final void | setCharacterStream(String
the name of the parameter parameterName, Reader the x, long 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 parameterName, Reader the reader)java.io.Reader object that contains the
Unicode dataImplements java. Reader
object.
|
| public void | setClob(String
the name of the parameter parameterName, Clob a x)Clob object that maps an SQL CLOB valueImplements java. java.sql.Clob object.
|
| public void | setClob(String
the name of the parameter to be set parameterName, Reader An object that contains the data to set the parameter value to. reader, long the number of characters in the parameter data. length)Implements java. Reader object.
|
| public void | setClob(String
the name of the parameter parameterName, Reader An object that contains the data to set the parameter value to. reader)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 calendar)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 parameterName, Reader the parameter value value, long the number of characters in the parameter data. length)Implements java. Reader object.
|
| public void | setNCharacterStream(String
the name of the parameter parameterName, Reader the parameter value value)Implements java. Reader object.
|
| public void | setNClob(String
the name of the parameter to be set parameterName, NClob the parameter value value)Implements java. java.sql.NClob object.
|
| public void | setNClob(String
the name of the parameter to be set parameterName, Reader An object that contains the data to set the parameter value to. reader, long the number of characters in the parameter data. length)Implements java. Reader object.
|
| public void | setNClob(String
the name of the parameter parameterName, Reader An object that contains the data to set the parameter value to. reader)Implements java. Reader object.
|
| public void | setNString(String
the name of the parameter to be set parameterName, String the parameter value value)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, 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 | 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)Implements java. |
| public void | setRowId(String
the name of the parameter parameterName, RowId the parameter value x)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 parameterName, SQLXML a xmlObject)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 calendar)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 calendar)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 x)Implements java. java.net.URL object.
|
| private void | |
| public boolean | wasNull()
Implements java. NULL.
|
| private boolean |