Top Description Fields Constructors Methods
org.hsqldb.jdbc

public 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, .StringReader, java.math.BigDecimal, .RoundingMode, java.sql.Array, .Blob, .CallableStatement, .Clob, .Date, .JDBCType, .NClob, .Ref, .ResultSet, .RowId, .SQLException, .SQLFeatureNotSupportedException, .SQLType, .SQLXML, .Time, .Timestamp, java.time.Duration, .Period, java.util.Calendar, .Locale, .Map, org.hsqldb.HsqlException, .SchemaObject, org.hsqldb.error.ErrorCode, org.hsqldb.lib.IntValueHashMap, org.hsqldb.result.ResultConstants, org.hsqldb.types.BinaryData, .BlobDataID, .ClobDataID, .DateTimeType, .IntervalMonthData, .IntervalSecondData, .JavaObjectData, .TimeData, .TimestampData, .Type, .Types
The interface used to execute SQL stored procedures. The JDBC API provides a stored procedure SQL escape syntax that allows stored procedures to be called in a standard way for all RDBMSs. This escape syntax has one form that includes a result parameter and one that does not. If used, the result parameter must be registered as an OUT parameter. The other parameters can be used for input, output or both. Parameters are referred to sequentially, by number, with the first parameter being 1. 
  {?= call <procedure-name>[(<arg1>,<arg2>, ...)]}
  {call <procedure-name>[(<arg1>,<arg2>, ...)]}

IN parameter values are set using the set methods inherited from java.sql.PreparedStatement. The type of all OUT parameters must be registered prior to executing the stored procedure; their values are retrieved after execution via the get methods provided here.

A CallableStatement can return one java.sql.ResultSet object or multiple ResultSet objects. Multiple ResultSet objects are handled using operations inherited from java.sql.Statement.

For maximum portability, a call's ResultSet objects and update counts should be processed prior to getting the values of output parameters.

HSQLDB-Specific Information:

Beyond the XOpen/ODBC extended scalar functions, stored procedures are typically supported in ways that vary greatly from one DBMS implementation to the next. So, it is almost guaranteed that the code for a stored procedure written under a specific DBMS product will not work without at least some modification in the context of another vendor's product or even across a single vendor's product lines. Moving stored procedures from one DBMS product line to another almost invariably involves complex porting issues and often may not be possible at all. Be warned.

One kind of HSQLDB stored procedures and functions is SQL/JRT, Java routines that map directly onto the static methods of compiled Java classes found on the class path of the engine at runtime. The CREATE PROCEDURE or CREATE FUNCTION statements are used in SQL to support the Java methods.

The other kind of HSQLDB stored procedures is SQL/PSM routines that are written entirely in the SQL procedural language. Overloaded methods are supported and resolved according to the type of parameters. With procedures, OUT and IN OUT parameters are also supported.

In addition, HSQLDB stored procedure call mechanism allows the more general HSQLDB SQL expression evaluation mechanism. This extension provides the ability to evaluate simple SQL expressions, possibly containing Java method invocations.

With HSQLDB, executing a CALL statement that produces an opaque (OTHER) or known scalar object reference has virtually the same effect as: 

CREATE TABLE DUAL (dummy VARCHAR);
INSERT INTO DUAL VALUES(NULL);
SELECT <simple-expression> FROM DUAL;
HSQLDB functions can return a single result set. HSQLDB procedures can return one or more result sets. Here is a very simple example of an HSQLDB stored procedure generating a user-defined result set: 
package mypackage;

import java.sql.ResultSet;
import java.sql.SQLException;

class MyLibraryClass {

     public static ResultSet mySp() throws SQLException {
         return ctx.getConnection().createStatement().executeQuery("select * from my_table");
     }
}
(campbell-burnet@users)
Authors
Campbell Burnet (campbell-burnet@users dot sourceforge.net), Fred Toussi (fredt@users dot sourceforge.net)
Since
JDK 1.1, HSQLDB 1.9.0
Version
2.7.4
See Also
JDBCConnection#prepareCall, JDBCResultSet

Field Summary

Modifier and TypeField and Description
private IntValueHashMap<String>
parameterNameMap

parameter name maps to parameter index

private boolean
wasNullValue

Inherited from org.hsqldb.jdbc.JDBCPreparedStatement:
hasLOBsisBatchisResultparameterMetaDataparameterModesparameterSetparameterTypesparameterValuespmdpoolableresultMetaDataresultSetMetaDatasessionsqlstatementIDstatementRetTypestreamLengths

Constructor Summary

AccessConstructor and Description
public
JDBCCallableStatement(JDBCConnection
the connection on which this statement will execute
c, String
the SQL statement this object represents
sql, int
the type of result this statement will produce
resultSetType, int
(updatability)
resultSetConcurrency, int
(validity beyond commit)
resultSetHoldability)

Constructs a new JDBCCallableStatement with the specified connection and result type.

Method Summary

Modifier and TypeMethod and Description
public synchronized void
close()

Overrides org.hsqldb.jdbc.JDBCPreparedStatement.close.

Implements java.sql.Statement.close.

Does the specialized work required to free this object's resources and that of its parent classes.

public void
closeOnCompletion()

Overrides org.hsqldb.jdbc.JDBCStatementBase.closeOnCompletion.

Implements java.sql.Statement.closeOnCompletion.

Specifies that this Statement will be closed when all its dependent result sets are closed.

public synchronized ResultSet

Returns:

a ResultSet object that contains the data produced by the query; never null
executeQuery()

Overrides org.hsqldb.jdbc.JDBCPreparedStatement.executeQuery.

Implements java.sql.PreparedStatement.executeQuery.

Executes the SQL query in this PreparedStatement object and returns the ResultSet object generated by the query.

pack-priv void
fetchResult()

Overrides org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult.

Internal result producer for JDBCStatement (sqlExecDirect mode).

pack-priv int

Returns:

index for name
findParameterIndex(String
to look up
parameterName)

Retrieves the parameter index corresponding to the given parameter name.

public Array

Returns:

the parameter value as an Array object in the Java programming language. If the value was SQL NULL, the value null is returned.
getArray(int
the first parameter is 1, the second is 2, and so on
parameterIndex)

Implements java.sql.CallableStatement.getArray.

Retrieves the value of the designated JDBC ARRAY parameter as an java.sql.Array object in the Java programming language.

public synchronized Array

Returns:

the parameter value as an Array object in Java programming language. If the value was SQL NULL, the value null is returned.
getArray(String
the name of the parameter
parameterName)

Implements java.sql.CallableStatement.getArray.

Retrieves the value of a JDBC ARRAY parameter as an java.sql.Array object in the Java programming language.

public synchronized BigDecimal

Returns:

the parameter value. If the value is SQL NULL, the result is null.
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.sql.CallableStatement.getBigDecimal.

Deprecated use getBigDecimal(int parameterIndex) or getBigDecimal(String parameterName)

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 synchronized BigDecimal

Returns:

the parameter value in full precision. If the value is SQL NULL, the result is null.
getBigDecimal(int
the first parameter is 1, the second is 2, and so on
parameterIndex)

Implements java.sql.CallableStatement.getBigDecimal.

Retrieves the value of the designated JDBC NUMERIC parameter as a java.math.BigDecimal object with as many digits to the right of the decimal point as the value contains.

public synchronized BigDecimal

Returns:

the parameter value in full precision. If the value is SQL NULL, the result is null.
getBigDecimal(String
the name of the parameter
parameterName)

Implements java.sql.CallableStatement.getBigDecimal.

Retrieves the value of a JDBC NUMERIC parameter as a java.math.BigDecimal object with as many digits to the right of the decimal point as the value contains.

public synchronized Blob

Returns:

the parameter value as a Blob object in the Java programming language. If the value was SQL NULL, the value null is returned.
getBlob(int
the first parameter is 1, the second is 2, and so on
parameterIndex)

Implements java.sql.CallableStatement.getBlob.

Retrieves the value of the designated JDBC BLOB parameter as a java.sql.Blob object in the Java programming language.

public synchronized Blob

Returns:

the parameter value as a Blob object in the Java programming language. If the value was SQL NULL, the value null is returned.
getBlob(String
the name of the parameter
parameterName)

Implements java.sql.CallableStatement.getBlob.

Retrieves the value of a JDBC BLOB parameter as a java.sql.Blob object in the Java programming language.

public synchronized boolean

Returns:

the parameter value. If the value is SQL NULL, the result is false.
getBoolean(int
the first parameter is 1, the second is 2, and so on
parameterIndex)

Implements java.sql.CallableStatement.getBoolean.

Retrieves the value of the designated JDBC BIT or BOOLEAN parameter as a boolean in the Java programming language.

public synchronized boolean

Returns:

the parameter value. If the value is SQL NULL, the result is false.
getBoolean(String
the name of the parameter
parameterName)

Implements java.sql.CallableStatement.getBoolean.

Retrieves the value of a JDBC BIT or BOOLEAN parameter as a boolean in the Java programming language.

public synchronized byte

Returns:

the parameter value. If the value is SQL NULL, the result is 0.
getByte(int
the first parameter is 1, the second is 2, and so on
parameterIndex)

Implements java.sql.CallableStatement.getByte.

Retrieves the value of the designated JDBC TINYINT parameter as a byte in the Java programming language.

public synchronized byte

Returns:

the parameter value. If the value is SQL NULL, the result is 0.
getByte(String
the name of the parameter
parameterName)

Implements java.sql.CallableStatement.getByte.

Retrieves the value of a JDBC TINYINT parameter as a byte in the Java programming language.

public synchronized byte[]

Returns:

the parameter value. If the value is SQL NULL, the result is null.
getBytes(int
the first parameter is 1, the second is 2, and so on
parameterIndex)

Implements java.sql.CallableStatement.getBytes.

Retrieves the value of the designated JDBC BINARY or VARBINARY parameter as an array of byte values in the Java programming language.

public synchronized byte[]

Returns:

the parameter value. If the value is SQL NULL, the result is null.
getBytes(String
the name of the parameter
parameterName)

Implements java.sql.CallableStatement.getBytes.

Retrieves the value of a JDBC BINARY or VARBINARY parameter as an array of byte values in the Java programming language.

public Reader

Returns:

a java.io.Reader object that contains the parameter value; if the value is SQL NULL, the value returned is null in the Java programming language.
getCharacterStream(int
the first parameter is 1, the second is 2, ...
parameterIndex)

Implements java.sql.CallableStatement.getCharacterStream.

Retrieves the value of the designated parameter as a java.io.Reader object in the Java programming language.

public synchronized Reader

Returns:

a java.io.Reader object that contains the parameter value; if the value is SQL NULL, the value returned is null in the Java programming language
getCharacterStream(String
the name of the parameter
parameterName)

Implements java.sql.CallableStatement.getCharacterStream.

Retrieves the value of the designated parameter as a java.io.Reader object in the Java programming language.

public synchronized Clob

Returns:

the parameter value as a Clob object in the Java programming language. If the value was SQL NULL, the value null is returned.
getClob(int
the first parameter is 1, the second is 2, and so on
parameterIndex)

Implements java.sql.CallableStatement.getClob.

Retrieves the value of the designated JDBC CLOB parameter as a java.sql.Clob object in the Java programming language.

public synchronized Clob

Returns:

the parameter value as a Clob object in the Java programming language. If the value was SQL NULL, the value null is returned.
getClob(String
the name of the parameter
parameterName)

Implements java.sql.CallableStatement.getClob.

Retrieves the value of a JDBC CLOB parameter as a java.sql.Clob object in the Java programming language.

private Object

Returns:

an Object of the requested targetType, representing the value of the specified column
getColumnInType(int
of the column value for which to perform the conversion
columnIndex, Type
the org.hsqldb.types.Type object for targetType
targetType)

Internal value converter.

protected Object
getColumnValue(int columnIndex)

Internal get value.

public synchronized Date

Returns:

the parameter value. If the value is SQL NULL, the result is null.
getDate(int
the first parameter is 1, the second is 2, and so on
parameterIndex)

Implements java.sql.CallableStatement.getDate.

Retrieves the value of the designated JDBC DATE parameter as a java.sql.Date object.

public synchronized Date

Returns:

the parameter value. If the value is SQL NULL, the result is null.
getDate(int
the first parameter is 1, the second is 2, and so on
parameterIndex, Calendar
the Calendar object the driver will use to construct the date
cal)

Implements java.sql.CallableStatement.getDate.

Retrieves the value of the designated JDBC DATE parameter as a java.sql.Date object, using the given Calendar object to construct the date.

public synchronized Date

Returns:

the parameter value. If the value is SQL NULL, the result is null.
getDate(String
the name of the parameter
parameterName)

Implements java.sql.CallableStatement.getDate.

Retrieves the value of a JDBC DATE parameter as a java.sql.Date object.

public synchronized Date

Returns:

the parameter value. If the value is SQL NULL, the result is null.
getDate(String
the name of the parameter
parameterName, Calendar
the Calendar object the driver will use to construct the date
cal)

Implements java.sql.CallableStatement.getDate.

Retrieves the value of a JDBC DATE parameter as a java.sql.Date object, using the given Calendar object to construct the date.

public synchronized double

Returns:

the parameter value. If the value is SQL NULL, the result is 0.
getDouble(int
the first parameter is 1, the second is 2, and so on
parameterIndex)

Implements java.sql.CallableStatement.getDouble.

Retrieves the value of the designated JDBC DOUBLE parameter as a double in the Java programming language.

public synchronized double

Returns:

the parameter value. If the value is SQL NULL, the result is 0.
getDouble(String
the name of the parameter
parameterName)

Implements java.sql.CallableStatement.getDouble.

Retrieves the value of a JDBC DOUBLE parameter as a double in the Java programming language.

public synchronized float

Returns:

the parameter value. If the value is SQL NULL, the result is 0.
getFloat(int
the first parameter is 1, the second is 2, and so on
parameterIndex)

Implements java.sql.CallableStatement.getFloat.

Retrieves the value of the designated JDBC FLOAT parameter as a float in the Java programming language.

public synchronized float

Returns:

the parameter value. If the value is SQL NULL, the result is 0.
getFloat(String
the name of the parameter
parameterName)

Implements java.sql.CallableStatement.getFloat.

Retrieves the value of a JDBC FLOAT parameter as a float in the Java programming language.

public synchronized int

Returns:

the parameter value. If the value is SQL NULL, the result is 0.
getInt(int
the first parameter is 1, the second is 2, and so on
parameterIndex)

Implements java.sql.CallableStatement.getInt.

Retrieves the value of the designated JDBC INTEGER parameter as an int in the Java programming language.

public synchronized int

Returns:

the parameter value. If the value is SQL NULL, the result is 0.
getInt(String
the name of the parameter
parameterName)

Implements java.sql.CallableStatement.getInt.

Retrieves the value of a JDBC INTEGER parameter as an int in the Java programming language.

public synchronized long

Returns:

the parameter value. If the value is SQL NULL, the result is 0.
getLong(int
the first parameter is 1, the second is 2, and so on
parameterIndex)

Implements java.sql.CallableStatement.getLong.

Retrieves the value of the designated JDBC BIGINT parameter as a long in the Java programming language.

public synchronized long

Returns:

the parameter value. If the value is SQL NULL, the result is 0.
getLong(String
the name of the parameter
parameterName)

Implements java.sql.CallableStatement.getLong.

Retrieves the value of a JDBC BIGINT parameter as a long in the Java programming language.

public Reader

Returns:

a java.io.Reader object that contains the parameter value; if the value is SQL NULL, the value returned is null in the Java programming language.
getNCharacterStream(int
the first parameter is 1, the second is 2, ...
parameterIndex)

Implements java.sql.CallableStatement.getNCharacterStream.

Retrieves the value of the designated parameter as a java.io.Reader object in the Java programming language.

public synchronized Reader

Returns:

a java.io.Reader object that contains the parameter value; if the value is SQL NULL, the value returned is null in the Java programming language
getNCharacterStream(String
the name of the parameter
parameterName)

Implements java.sql.CallableStatement.getNCharacterStream.

Retrieves the value of the designated parameter as a java.io.Reader object in the Java programming language.

public NClob

Returns:

the parameter value as a NClob object in the Java programming language. If the value was SQL NULL, the value null is returned.
getNClob(int
the first parameter is 1, the second is 2, and so on
parameterIndex)

Implements java.sql.CallableStatement.getNClob.

Retrieves the value of the designated JDBC NCLOB parameter as a java.sql.NClob object in the Java programming language.

public synchronized NClob

Returns:

the parameter value as a NClob object in the Java programming language. If the value was SQL NULL, the value null is returned.
getNClob(String
the name of the parameter
parameterName)

Implements java.sql.CallableStatement.getNClob.

Retrieves the value of a JDBC NCLOB parameter as a java.sql.NClob object in the Java programming language.

public String

Returns:

a String object that maps an NCHAR, NVARCHAR or LONGNVARCHAR value
getNString(int
index of the first parameter is 1, the second is 2, ...
parameterIndex)

Implements java.sql.CallableStatement.getNString.

Retrieves the value of the designated NCHAR, NVARCHAR or LONGNVARCHAR parameter as a String in the Java programming language.

public synchronized String

Returns:

a String object that maps an NCHAR, NVARCHAR or LONGNVARCHAR value
getNString(String
the name of the parameter
parameterName)

Implements java.sql.CallableStatement.getNString.

Retrieves the value of the designated NCHAR, NVARCHAR or LONGNVARCHAR parameter as a String in the Java programming language.

public synchronized Object

Returns:

A java.lang.Object holding the OUT parameter value
getObject(int
the first parameter is 1, the second is 2, and so on
parameterIndex)

Implements java.sql.CallableStatement.getObject.

Retrieves the value of the designated parameter as an Object in the Java programming language.

public Object

Returns:

a java.lang.Object holding the OUT parameter value
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.

Returns an object representing the value of OUT parameter parameterIndex and uses map for the custom mapping of the parameter value.

public synchronized Object

Returns:

A java.lang.Object holding the OUT parameter value.
getObject(String
the name of the parameter
parameterName)

Implements java.sql.CallableStatement.getObject.

Retrieves the value of a parameter as an Object in the Java programming language.

public synchronized Object

Returns:

a java.lang.Object holding the OUT parameter value
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.

Returns an object representing the value of OUT parameter parameterName and uses map for the custom mapping of the parameter value.

public <
the type of the class modeled by this Class object
T> T

Returns:

an instance of type holding the OUT parameter value
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.sql.CallableStatement.getObject.

Returns an object representing the value of OUT parameter parameterIndex and will convert from the SQL type of the parameter to the requested Java data type, if the conversion is supported.

public <
the type of the class modeled by this Class object
T> T

Returns:

an instance of type holding the OUT parameter value
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.sql.CallableStatement.getObject.

Returns an object representing the value of OUT parameter parameterName and will convert from the SQL type of the parameter to the requested Java data type, if the conversion is supported.

public Ref

Returns:

the parameter value as a Ref object in the Java programming language. If the value was SQL NULL, the value null is returned.
getRef(int
the first parameter is 1, the second is 2, and so on
parameterIndex)

Implements java.sql.CallableStatement.getRef.

Retrieves the value of the designated JDBC REF(<structured-type>) parameter as a java.sql.Ref object in the Java programming language.

public synchronized Ref

Returns:

the parameter value as a Ref object in the Java programming language. If the value was SQL NULL, the value null is returned.
getRef(String
the name of the parameter
parameterName)

Implements java.sql.CallableStatement.getRef.

Retrieves the value of a JDBC REF(<structured-type>) parameter as a java.sql.Ref object in the Java programming language.

public ResultSet
getResultSet()

Overrides org.hsqldb.jdbc.JDBCPreparedStatement.getResultSet.

Implements java.sql.Statement.getResultSet.

Retrieves the current result as a ResultSet object.

public RowId

Returns:

a RowId object that represents the JDBC ROWID value is used as the designated parameter. If the parameter contains a SQL NULL, then a null value is returned.
getRowId(int
the first parameter is 1, the second is 2,...
parameterIndex)

Implements java.sql.CallableStatement.getRowId.

Retrieves the value of the designated JDBC ROWID parameter as a java.sql.RowId object.

public synchronized RowId

Returns:

a RowId object that represents the JDBC ROWID value is used as the designated parameter. If the parameter contains a SQL NULL, then a null value is returned.
getRowId(String
the name of the parameter
parameterName)

Implements java.sql.CallableStatement.getRowId.

Retrieves the value of the designated JDBC ROWID parameter as a java.sql.RowId object.

public synchronized short

Returns:

the parameter value. If the value is SQL NULL, the result is 0.
getShort(int
the first parameter is 1, the second is 2, and so on
parameterIndex)

Implements java.sql.CallableStatement.getShort.

Retrieves the value of the designated JDBC SMALLINT parameter as a short in the Java programming language.

public synchronized short

Returns:

the parameter value. If the value is SQL NULL, the result is 0.
getShort(String
the name of the parameter
parameterName)

Implements java.sql.CallableStatement.getShort.

Retrieves the value of a JDBC SMALLINT parameter as a short in the Java programming language.

public SQLXML

Returns:

a SQLXML object that maps an SQL XML value
getSQLXML(int
index of the first parameter is 1, the second is 2, ...
parameterIndex)

Implements java.sql.CallableStatement.getSQLXML.

Retrieves the value of the designated SQL XML parameter as a java.sql.SQLXML object in the Java programming language.

public synchronized SQLXML

Returns:

a SQLXML object that maps an SQL XML value
getSQLXML(String
the name of the parameter
parameterName)

Implements java.sql.CallableStatement.getSQLXML.

Retrieves the value of the designated SQL XML parameter as a java.sql.SQLXML object in the Java programming language.

public synchronized String

Returns:

the parameter value. If the value is SQL NULL, the result is null.
getString(int
the first parameter is 1, the second is 2, and so on
parameterIndex)

Implements java.sql.CallableStatement.getString.

Retrieves the value of the designated JDBC CHAR, VARCHAR, or LONGVARCHAR parameter as a String in the Java programming language.

public synchronized String

Returns:

the parameter value. If the value is SQL NULL, the result is null.
getString(String
the name of the parameter
parameterName)

Implements java.sql.CallableStatement.getString.

Retrieves the value of a JDBC CHAR, VARCHAR, or LONGVARCHAR parameter as a String in the Java programming language.

public synchronized Time

Returns:

the parameter value. If the value is SQL NULL, the result is null.
getTime(int
the first parameter is 1, the second is 2, and so on
parameterIndex)

Implements java.sql.CallableStatement.getTime.

Retrieves the value of the designated JDBC TIME parameter as a java.sql.Time object.

public synchronized Time

Returns:

the parameter value; if the value is SQL NULL, the result is null.
getTime(int
the first parameter is 1, the second is 2, and so on
parameterIndex, Calendar
the Calendar object the driver will use to construct the time
cal)

Implements java.sql.CallableStatement.getTime.

Retrieves the value of the designated JDBC TIME parameter as a java.sql.Time object, using the given Calendar object to construct the time.

public synchronized Time

Returns:

the parameter value. If the value is SQL NULL, the result is null.
getTime(String
the name of the parameter
parameterName)

Implements java.sql.CallableStatement.getTime.

Retrieves the value of a JDBC TIME parameter as a java.sql.Time object.

public synchronized Time

Returns:

the parameter value; if the value is SQL NULL, the result is null.
getTime(String
the name of the parameter
parameterName, Calendar
the Calendar object the driver will use to construct the time
cal)

Implements java.sql.CallableStatement.getTime.

Retrieves the value of a JDBC TIME parameter as a java.sql.Time object, using the given Calendar object to construct the time.

public synchronized Timestamp

Returns:

the parameter value. If the value is SQL NULL, the result is null.
getTimestamp(int
the first parameter is 1, the second is 2, and so on
parameterIndex)

Implements java.sql.CallableStatement.getTimestamp.

Retrieves the value of the designated JDBC TIMESTAMP parameter as a java.sql.Timestamp object.

public synchronized Timestamp

Returns:

the parameter value. If the value is SQL NULL, the result is null.
getTimestamp(int
the first parameter is 1, the second is 2, and so on
parameterIndex, Calendar
the Calendar object the driver will use to construct the timestamp
cal)

Implements java.sql.CallableStatement.getTimestamp.

Retrieves the value of the designated JDBC TIMESTAMP parameter as a java.sql.Timestamp object, using the given Calendar object to construct the Timestamp object.

public synchronized Timestamp

Returns:

the parameter value. If the value is SQL NULL, the result is null.
getTimestamp(String
the name of the parameter
parameterName)

Implements java.sql.CallableStatement.getTimestamp.

Retrieves the value of a JDBC TIMESTAMP parameter as a java.sql.Timestamp object.

public synchronized Timestamp

Returns:

the parameter value. If the value is SQL NULL, the result is null.
getTimestamp(String
the name of the parameter
parameterName, Calendar
the Calendar object the driver will use to construct the timestamp
cal)

Implements java.sql.CallableStatement.getTimestamp.

Retrieves the value of a JDBC TIMESTAMP parameter as a java.sql.Timestamp object, using the given Calendar object to construct the Timestamp object.

private Object
getTimestampWithZone(int columnIndex)

private Object
getTimeWithZone(int columnIndex)

public URL

Returns:

a java.net.URL object that represents the JDBC DATALINK value used as the designated parameter
getURL(int
the first parameter is 1, the second is 2,...
parameterIndex)

Implements java.sql.CallableStatement.getURL.

Retrieves the value of the designated JDBC DATALINK parameter as a java.net.URL object.

public URL

Returns:

the parameter value as a java.net.URL object in the Java programming language. If the value was SQL NULL, the value null is returned.
getURL(String
the name of the parameter
parameterName)

Implements java.sql.CallableStatement.getURL.

Retrieves the value of a JDBC DATALINK parameter as a java.net.URL object.

public boolean
isCloseOnCompletion()

Overrides org.hsqldb.jdbc.JDBCStatementBase.isCloseOnCompletion.

Implements java.sql.Statement.isCloseOnCompletion.

Returns a value indicating whether this Statement will be closed when all its dependent result sets are closed.

public synchronized void
registerOutParameter(int
the first parameter is 1, the second is 2, and so on
parameterIndex, int
the JDBC type code defined by 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.
sqlType)

Implements java.sql.CallableStatement.registerOutParameter.

Registers the OUT parameter in ordinal position parameterIndex to the JDBC type sqlType.

public synchronized void
registerOutParameter(int
the first parameter is 1, the second is 2, and so on
parameterIndex, int
the SQL type code defined by java.sql.Types.
sqlType, int
the desired number of digits to the right of the decimal point. It must be greater than or equal to zero.
scale)

Implements java.sql.CallableStatement.registerOutParameter.

Registers the parameter in ordinal position parameterIndex to be of JDBC type sqlType.

public synchronized void
registerOutParameter(int
the first parameter is 1, the second is 2,...
parameterIndex, int
a value from java.sql.Types
sqlType, String
the fully-qualified name of an SQL structured type
typeName)

Implements java.sql.CallableStatement.registerOutParameter.

Registers the designated output parameter.

public synchronized void
registerOutParameter(String
the name of the parameter
parameterName, int
the JDBC type code defined by 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.
sqlType)

Implements java.sql.CallableStatement.registerOutParameter.

Registers the OUT parameter named parameterName to the JDBC type sqlType.

public synchronized void
registerOutParameter(String
the name of the parameter
parameterName, int
SQL type code defined by java.sql.Types.
sqlType, int
the desired number of digits to the right of the decimal point. It must be greater than or equal to zero.
scale)

Implements java.sql.CallableStatement.registerOutParameter.

Registers the parameter named parameterName to be of JDBC type sqlType.

public synchronized void
registerOutParameter(String
the name of the parameter
parameterName, int
a value from java.sql.Types
sqlType, String
the fully-qualified name of an SQL structured type
typeName)

Implements java.sql.CallableStatement.registerOutParameter.

Registers the designated output parameter.

public void
registerOutParameter(int
the first parameter is 1, the second is 2, and so on
parameterIndex, SQLType
the JDBC type code defined by SQLType to use to register the OUT Parameter. If the parameter is of JDBC type JDBCType.NUMERIC or JDBCType.DECIMAL, the version of registerOutParameter that accepts a scale value should be used.
sqlType)

Overrides default java.sql.CallableStatement.registerOutParameter.

Registers the OUT parameter in ordinal position parameterIndex to the JDBC type sqlType.

public void
registerOutParameter(int
the first parameter is 1, the second is 2, and so on
parameterIndex, SQLType
the JDBC type code defined by SQLType to use to register the OUT Parameter.
sqlType, int
the desired number of digits to the right of the decimal point. It must be greater than or equal to zero.
scale)

Overrides default java.sql.CallableStatement.registerOutParameter.

Registers the parameter in ordinal position parameterIndex to be of JDBC type sqlType.

public void
registerOutParameter(int
the first parameter is 1, the second is 2,...
parameterIndex, SQLType
the JDBC type code defined by SQLType to use to register the OUT Parameter.
sqlType, String
the fully-qualified name of an SQL structured type
typeName)

Overrides default java.sql.CallableStatement.registerOutParameter.

Registers the designated output parameter.

public void
registerOutParameter(String
the name of the parameter
parameterName, SQLType
the JDBC type code defined by SQLType to use to register the OUT Parameter. If the parameter is of JDBC type JDBCType.NUMERIC or JDBCType.DECIMAL, the version of registerOutParameter that accepts a scale value should be used.
sqlType)

Overrides default java.sql.CallableStatement.registerOutParameter.

Registers the OUT parameter named parameterName to the JDBC type sqlType.

public void
registerOutParameter(String
the name of the parameter
parameterName, SQLType
the JDBC type code defined by SQLType to use to register the OUT Parameter.
sqlType, int
the desired number of digits to the right of the decimal point. It must be greater than or equal to zero.
scale)

Overrides default java.sql.CallableStatement.registerOutParameter.

Registers the parameter named parameterName to be of JDBC type sqlType.

public void
registerOutParameter(String
the name of the parameter
parameterName, SQLType
the JDBC type code defined by SQLType to use to register the OUT Parameter.
sqlType, String
the fully-qualified name of an SQL structured type
typeName)

Overrides default java.sql.CallableStatement.registerOutParameter.

Registers the designated output parameter.

public synchronized 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.sql.CallableStatement.setAsciiStream.

Sets the designated parameter to the given input stream, which will have the specified number of bytes.

public synchronized 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.sql.CallableStatement.setAsciiStream.

Sets the designated parameter to the given input stream, which will have the specified number of bytes.

public synchronized void
setAsciiStream(String
the name of the parameter
parameterName, InputStream
the Java input stream that contains the ASCII parameter value
x)

Implements java.sql.CallableStatement.setAsciiStream.

Sets the designated parameter to the given input stream.

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

Implements java.sql.CallableStatement.setBigDecimal.

Sets the designated parameter to the given java.math.BigDecimal value.

public synchronized 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.sql.CallableStatement.setBinaryStream.

Sets the designated parameter to the given input stream, which will have the specified number of bytes.

public synchronized 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.sql.CallableStatement.setBinaryStream.

Sets the designated parameter to the given input stream, which will have the specified number of bytes.

public synchronized void
setBinaryStream(String
the name of the parameter
parameterName, InputStream
the java input stream which contains the binary parameter value
x)

Implements java.sql.CallableStatement.setBinaryStream.

Sets the designated parameter to the given input stream.

public synchronized 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.sql.CallableStatement.setBlob.

Sets the designated parameter to a InputStream object.

public synchronized void
setBlob(String
the name of the parameter
parameterName, Blob
a Blob object that maps an SQL BLOB value
x)

Implements java.sql.CallableStatement.setBlob.

Sets the designated parameter to the given java.sql.Blob object.

public synchronized 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.sql.CallableStatement.setBlob.

Sets the designated parameter to an InputStream object.

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

Implements java.sql.CallableStatement.setBoolean.

Sets the designated parameter to the given Java boolean value.

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

Implements java.sql.CallableStatement.setByte.

Sets the designated parameter to the given Java byte value.

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

Implements java.sql.CallableStatement.setBytes.

Sets the designated parameter to the given Java array of bytes.

public synchronized void
setCharacterStream(String
the name of the parameter
parameterName, Reader
the java.io.Reader object that contains the UNICODE data used as the designated parameter
reader, int
the number of characters in the stream
length)

Implements java.sql.CallableStatement.setCharacterStream.

Sets the designated parameter to the given Reader object, which is the given number of characters long.

public synchronized void
setCharacterStream(String
the name of the parameter
parameterName, Reader
the java.io.Reader object that contains the UNICODE data used as the designated parameter
reader, long
the number of characters in the stream
length)

Implements java.sql.CallableStatement.setCharacterStream.

Sets the designated parameter to the given Reader object, which is the given number of characters long.

public synchronized void
setCharacterStream(String
the name of the parameter
parameterName, Reader
the java.io.Reader object that contains the Unicode data
reader)

Implements java.sql.CallableStatement.setCharacterStream.

Sets the designated parameter to the given Reader object.

public synchronized 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.sql.CallableStatement.setClob.

Sets the designated parameter to a Reader object.

public synchronized void
setClob(String
the name of the parameter
parameterName, Clob
a Clob object that maps an SQL CLOB value
x)

Implements java.sql.CallableStatement.setClob.

Sets the designated parameter to the given java.sql.Clob object.

public synchronized 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.sql.CallableStatement.setClob.

Sets the designated parameter to a Reader object.

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

Implements java.sql.CallableStatement.setDate.

Sets the designated parameter to the given java.sql.Date value using the default time zone of the virtual machine that is running the application.

public synchronized void
setDate(String
the name of the parameter
parameterName, Date
the parameter value
x, Calendar
the Calendar object the driver will use to construct the date
cal)

Implements java.sql.CallableStatement.setDate.

Sets the designated parameter to the given java.sql.Date value, using the given Calendar object.

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

Implements java.sql.CallableStatement.setDouble.

Sets the designated parameter to the given Java double value.

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

Implements java.sql.CallableStatement.setFloat.

Sets the designated parameter to the given Java float value.

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

Implements java.sql.CallableStatement.setInt.

Sets the designated parameter to the given Java int value.

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

Implements java.sql.CallableStatement.setLong.

Sets the designated parameter to the given Java long value.

public synchronized 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.sql.CallableStatement.setNCharacterStream.

Sets the designated parameter to a Reader object.

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

Implements java.sql.CallableStatement.setNCharacterStream.

Sets the designated parameter to a Reader object.

public synchronized void
setNClob(String
the name of the parameter to be set
parameterName, NClob
the parameter value
value)

Implements java.sql.CallableStatement.setNClob.

Sets the designated parameter to a java.sql.NClob object.

public synchronized 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.sql.CallableStatement.setNClob.

Sets the designated parameter to a Reader object.

public synchronized 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.sql.CallableStatement.setNClob.

Sets the designated parameter to a Reader object.

public synchronized void
setNString(String
the name of the parameter to be set
parameterName, String
the parameter value
value)

Implements java.sql.CallableStatement.setNString.

Sets the designated parameter to the given String object.

public synchronized void
setNull(String
the name of the parameter
parameterName, int
the SQL type code defined in java.sql.Types
sqlType)

Implements java.sql.CallableStatement.setNull.

Sets the designated parameter to SQL NULL.

public synchronized void
setNull(String
the name of the parameter
parameterName, int
a value from java.sql.Types
sqlType, String
the fully-qualified name of an SQL user-defined type; ignored if the parameter is not a user-defined type or SQL REF value
typeName)

Implements java.sql.CallableStatement.setNull.

Sets the designated parameter to SQL NULL.

public synchronized 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.sql.CallableStatement.setObject.

Sets the value of the designated parameter with the given object.

public synchronized 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.sql.CallableStatement.setObject.

Sets the value of the designated parameter with the given object.

public synchronized void
setObject(String
the name of the parameter
parameterName, Object
the object containing the input parameter value
x)

Implements java.sql.CallableStatement.setObject.

Sets the value of the designated parameter with the given object.

public void
setObject(String
the name of the parameter
parameterName, Object
the object containing the input parameter value
x, SQLType
the SQL type to be sent to the database. The scale argument may further qualify this type.
targetSqlType, int
for java.sql.JDBCType.DECIMAL or java.sql.JDBCType.NUMERIC types, this is the number of digits after the decimal point. For Java Object types InputStream and Reader, this is the length of the data in the stream or reader. For all other types, this value will be ignored.
scaleOrLength)

Overrides default java.sql.CallableStatement.setObject.

Sets the value of the designated parameter with the given object.

public void
setObject(String
the name of the parameter
parameterName, Object
the object containing the input parameter value
x, SQLType
the SQL type to be sent to the database
targetSqlType)

Overrides default java.sql.CallableStatement.setObject.

Sets the value of the designated parameter with the given object.

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

Implements java.sql.CallableStatement.setRowId.

Sets the designated parameter to the given java.sql.RowId object.

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

Implements java.sql.CallableStatement.setShort.

Sets the designated parameter to the given Java short value.

public synchronized void
setSQLXML(String
the name of the parameter
parameterName, SQLXML
a SQLXML object that maps an SQL XML value
xmlObject)

Implements java.sql.CallableStatement.setSQLXML.

Sets the designated parameter to the given java.sql.SQLXML object.

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

Implements java.sql.CallableStatement.setString.

Sets the designated parameter to the given Java String value.

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

Implements java.sql.CallableStatement.setTime.

Sets the designated parameter to the given java.sql.Time value.

public synchronized void
setTime(String
the name of the parameter
parameterName, Time
the parameter value
x, Calendar
the Calendar object the driver will use to construct the time
cal)

Implements java.sql.CallableStatement.setTime.

Sets the designated parameter to the given java.sql.Time value, using the given Calendar object.

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

Implements java.sql.CallableStatement.setTimestamp.

Sets the designated parameter to the given java.sql.Timestamp value.

public synchronized void
setTimestamp(String
the name of the parameter
parameterName, Timestamp
the parameter value
x, Calendar
the Calendar object the driver will use to construct the timestamp
cal)

Implements java.sql.CallableStatement.setTimestamp.

Sets the designated parameter to the given 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.sql.CallableStatement.setURL.

Sets the designated parameter to the given java.net.URL object.

private boolean
trackNull(Object o)

public synchronized boolean

Returns:

true if the last parameter read was SQL NULL; false otherwise
wasNull()

Implements java.sql.CallableStatement.wasNull.

Retrieves whether the last OUT parameter read had the value of SQL NULL.

Inherited from org.hsqldb.jdbc.JDBCPreparedStatement:
addBatchaddBatchcancelcheckGetParameterIndexcheckParameterIndexcheckSetParameterIndexcheckStatementTypeclearBatchclearParametersclearWarningsexecuteexecuteexecuteexecuteexecuteexecuteBatchexecuteLargeBatchexecuteLargeUpdateexecuteQueryexecuteUpdateexecuteUpdateexecuteUpdateexecuteUpdateexecuteUpdategetConnectiongetFetchDirectiongetFetchSizegetGeneratedKeysgetLargeMaxRowsgetLargeUpdateCountgetMaxFieldSizegetMaxRowsgetMetaDatagetMoreResultsgetMoreResultsgetParameterMetaDatagetParameterMetaDataDirectgetQueryTimeoutgetResultSetConcurrencygetResultSetHoldabilitygetResultSetMetaDatagetResultSetTypegetSQLgetStatementIDgetUpdateCountgetWarningsisClosedisPoolableisRowCountisWrapperForperformPostExecutesetArraysetAsciiStreamsetAsciiStreamsetAsciiStreamsetAscStreamsetBigDecimalsetBinaryStreamsetBinaryStreamsetBinaryStreamsetBlobsetBlobsetBlobsetBlobParametersetBlobParametersetBooleansetBytesetBytessetCharacterStreamsetCharacterStreamsetCharacterStreamsetClobsetClobsetClobsetClobParametersetClobParametersetCursorNamesetDatesetDatesetDoublesetEscapeProcessingsetFetchDirectionsetFetchSizesetFloatsetIntsetIntParametersetLargeMaxRowssetLongsetLongParametersetMaxFieldSizesetMaxRowssetNCharacterStreamsetNCharacterStreamsetNClobsetNClobsetNClobsetNStringsetNullsetNullsetObjectsetObjectsetObjectsetObjectsetObjectsetParametersetPoolablesetQueryTimeoutsetRefsetRowIdsetShortsetSQLXMLsetStringsetTimesetTimesetTimestampsetTimestampsetUnicodeStreamsetURLtoStringunwrap