Prev Class | Next Class | Frames | No Frames |
Summary: Nested | Field | Method | Constr | Detail: Nested | Field | Method | Constr |
java.lang.Object
org.hsqldb.jdbc.jdbcStatement
org.hsqldb.jdbc.jdbcPreparedStatement
org.hsqldb.jdbc.jdbcCallableStatement
{?= call <procedure-name>[<arg1>,<arg2>, ...]} {call <procedure-name>[<arg1>,<arg2>, ...]}IN parameter values are set using the
set
methods inherited from
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 ResultSet
object or
multiple ResultSet
objects. Multiple
ResultSet
objects are handled using operations
inherited from Statement
.
For maximum portability, a call's ResultSet
objects and
update counts should be processed prior to getting the values of output
parameters.
<!-- end generic documentation -->
<!-- start Release-specific documentation -->
jdbcPreparedStatment
.
GRANT ALL ON CLASS "package.class" TO [<user-name> | PUBLIC] CREATE ALIAS <call-alias> FOR "package.class.method" -- optionalThis has the effect of allowing the specified user(s) to access the set of uniquely named public static methods of the specified class, in either the role of SQL functions or stored procedures. For example:
CONNECT <admin-user> PASSWORD <admin-user-password>; GRANT ALL ON CLASS "org.myorg.MyClass" TO PUBLIC; CREATE ALIAS sp_my_method FOR "org.myorg.MyClass.myMethod" CONNECT <any-user> PASSWORD <any-user-password>; SELECT "org.myorg.MyClass.myMethod"(column_1) FROM table_1; SELECT sp_my_method(column_1) FROM table_1; CALL 2 + "org.myorg.MyClass.myMethod"(-5); CALL 2 + sp_my_method(-5);Please note the use of the term "uniquely named" above. Including 1.7.2, no support is provided to deterministically resolve overloaded method names, and there can be issues with inherited methods as well; currently, it is strongly recommended that developers creating stored procedure library classes for HSQLDB simply avoid designs such that SQL stored procedure calls attempt to resolve to:
OUT
and IN OUT
parameters
are not yet supported due to some unresolved low level support issues.
Including 1.7.2, the HSQLDB stored procedure call mechanism is essentially a
thin wrap of the HSQLDB SQL function call mechanism, extended to include the
more general HSQLDB SQL expression evaluation mechanism. In addition to
stored procedure calls that resolve directly to Java method invocations, the
extention provides the ability to evaluate simple SQL expressions, possibly
containing Java method invocations, outside any INSERT
,
UPDATE
, DELETE
or SELECT
statement
context.
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;As a transitional measure, HSQLDB provides the ability to materialize a general result set in response to stored procedure execution. In this case, the stored procedure's Java method descriptor must specify a return type of java.lang.Object for external use (although at any point in the devlopment cycle, other, proprietary return types may accepted internally for engine development purposes). When HSQLDB detects that the runtime class of the resulting Object is elligible, an automatic internal unwrapping is performed to correctly expose the underlying result set to the client, whether local or remote. Additionally, HSQLDB automatically detects if java.sql.Connection is the class of the first argument of any underlying Java method(s). If so, then the engine transparently supplies the internal Connection object corresponding to the Session executing the call, adjusting the positions of other arguments to suite the SQL context. The features above are not intended to be permanent. Rather, the intention is to offer more general and powerful mechanisms in a future release; it is recommend to use them only as a temporary convenience. For instance, one might be well advised to future-proof by writing HSQLDB-specific adapter methods that in turn call the real logic of an underlying generalized JDBC stored procedure library. Here is a very simple example of an HSQLDB stored procedure generating a user-defined result set:
package mypackage; class MyClass { public static Object mySp(Connection conn) throws SQLException { return conn.createStatement().executeQuery("select * from my_table"); } }Here is a refinement demonstrating no more than the bare essence of the idea behind a more portable style:
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"); } } //-- package myadaptorpackage; import java.sql.Connection; import java.sql.SQLException; class MyAdaptorClass { public static Object mySp(Connection conn) throws SQLException { MyLibraryClass.getCtx().setConnection(conn); return MyLibraryClass.mySp(); } }In a future release, it is intended to provided some new features that will support writing fairly portable JDBC-based stored procedure code:
jdbcConnection.prepareCall
, jdbcResultSet
Constructor Summary | |
|
Method Summary | |
void |
|
Array |
|
Array |
|
BigDecimal |
|
BigDecimal |
|
BigDecimal |
|
Blob |
|
Blob |
|
boolean |
|
boolean |
|
byte |
|
byte |
|
byte[] |
|
byte[] |
|
Clob |
|
Clob |
|
Date |
|
Date |
|
Date |
|
Date |
|
double |
|
double |
|
float |
|
float |
|
int |
|
int |
|
long |
|
long |
|
Object |
|
Object |
|
Object |
|
Object |
|
Ref |
|
Ref |
|
short |
|
short |
|
String |
|
String |
|
Time |
|
Time |
|
Time |
|
Time |
|
Timestamp |
|
Timestamp |
|
Timestamp |
|
Timestamp |
|
java.net.URL |
|
java.net.URL |
|
void |
|
void |
|
void |
|
void |
|
void |
|
void |
|
void |
|
void |
|
void |
|
void |
|
void |
|
void |
|
void |
|
void |
|
void |
|
void |
|
void |
|
void |
|
void |
|
void |
|
void |
|
void |
|
void |
|
void |
|
void |
|
void |
|
void |
|
void |
|
void |
|
void |
|
void |
|
boolean |
|
Methods inherited from class org.hsqldb.jdbc.jdbcPreparedStatement | |
addBatch , addBatch , clearParameters , close , execute , execute , executeBatch , executeQuery , executeQuery , executeUpdate , executeUpdate , getMetaData , getParameterMetaData , setArray , setAsciiStream , setBigDecimal , setBinaryStream , setBlob , setBoolean , setByte , setBytes , setCharacterStream , setClob , setDate , setDate , setDouble , setEscapeProcessing , setFloat , setInt , setLong , setNull , setNull , setObject , setObject , setObject , setRef , setShort , setString , setTime , setTime , setTimestamp , setTimestamp , setURL , setUnicodeStream , toString |
public jdbcCallableStatement(jdbcConnection c, String sql, int type) throws org.hsqldb.HsqlException, SQLException
Constructs a new jdbcCallableStatement with the specified connection and result type.
- Parameters:
c
- the connection on which this statement will executesql
- the SQL statement this object representstype
- the type of result this statement will produce
- Throws:
org.hsqldb.HsqlException
- if the statement is not accepted by the database
public void close() throws SQLException
Does the specialized work required to free this object's resources and that of it's parent classes.
- Overrides:
- close in interface jdbcPreparedStatement
public Array getArray(String parameterName) throws SQLException
<!-- start generic documentation --> Retrieves the value of a JDBCARRAY
parameter as anArray
object in the Java programming language. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterName
- the name of the parameter
- Returns:
- the parameter value as an
Array
object in Java programming language. If the value was SQLNULL
, the valuenull
is returned.
- Since:
- JDK 1.4, HSQLDB 1.7.0
public Array getArray(int parameterIndex) throws SQLException
<!-- start generic documentation --> Retrieves the value of the designated JDBCARRAY
parameter as anjava.sql.Array
object in the Java programming language. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so on
- Returns:
- the parameter value as an
Array
object in the Java programming language. If the value was SQLNULL
, the valuenull
is returned.
- Since:
- JDK 1.2 (JDK 1.1.x developers: read the new overview for jdbcPreparedStatement)
public BigDecimal getBigDecimal(String parameterName) throws SQLException
<!-- start generic documentation --> Retrieves the value of a JDBCNUMERIC
parameter as ajava.math.BigDecimal
object with as many digits to the right of the decimal point as the value contains. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterName
- the name of the parameter
- Returns:
- the parameter value in full precision. If the value is SQL
NULL
, the result isnull
.
- Since:
- JDK 1.4, HSQLDB 1.7.0
- See Also:
setBigDecimal(String,BigDecimal)
public BigDecimal getBigDecimal(int parameterIndex) throws SQLException
<!-- start generic documentation --> Retrieves the value of the designated JDBCNUMERIC
parameter as ajava.math.BigDecimal
object with as many digits to the right of the decimal point as the value contains. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so on
- Returns:
- the parameter value in full precision. If the value is SQL
NULL
, the result isnull
.
- Since:
- JDK 1.2 (JDK 1.1.x developers: read the new overview for jdbcPreparedStatement)
- See Also:
setBigDecimal(String,BigDecimal)
public BigDecimal getBigDecimal(int parameterIndex, int scale) throws SQLException
Deprecated. use
getBigDecimal(int parameterIndex)
orgetBigDecimal(String parameterName)
<!-- start generic documentation --> Retrieves the value of the designated JDBCNUMERIC
parameter as ajava.math.BigDecimal
object with scale digits to the right of the decimal point. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so onscale
- the number of digits to the right of the decimal point
- Returns:
- the parameter value. If the value is SQL
NULL
, the result isnull
.
- See Also:
setBigDecimal(String,BigDecimal)
public Blob getBlob(String parameterName) throws SQLException
<!-- start generic documentation --> Retrieves the value of a JDBCBLOB
parameter as ajava.sql.Blob
object in the Java programming language. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterName
- the name of the parameter
- Returns:
- the parameter value as a
Blob
object in the Java programming language. If the value was SQLNULL
, the valuenull
is returned.
- Since:
- JDK 1.4, HSQLDB 1.7.0
public Blob getBlob(int parameterIndex) throws SQLException
<!-- start generic documentation --> Retrieves the value of the designated JDBCBLOB
parameter as ajava.sql.Blob
object in the Java programming language. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so on
- Returns:
- the parameter value as a
Blob
object in the Java programming language. If the value was SQLNULL
, the valuenull
is returned.
- Since:
- JDK 1.2 (JDK 1.1.x developers: read the new overview for jdbcPreparedStatement)
public boolean getBoolean(String parameterName) throws SQLException
<!-- start generic documentation --> (JDBC4 modified:) Retrieves the value of a JDBCBIT
orBOOLEAN
parameter as aboolean
in the Java programming language. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterName
- the name of the parameter
- Returns:
- the parameter value. If the value is SQL
NULL
, the result isfalse
.
- Since:
- JDK 1.4, HSQLDB 1.7.0
- See Also:
setBoolean(String,boolean)
public boolean getBoolean(int parameterIndex) throws SQLException
<!-- start generic documentation --> Retrieves the value of the designated JDBCBIT
parameter as aboolean
in the Java programming language. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so on
- Returns:
- the parameter value. If the value is SQL
NULL
, the result isfalse
.
- See Also:
setBoolean(String,boolean)
public byte getByte(String parameterName) throws SQLException
<!-- start generic documentation --> Retrieves the value of a JDBCTINYINT
parameter as abyte
in the Java programming language. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterName
- the name of the parameter
- Returns:
- the parameter value. If the value is SQL
NULL
, the result is0
.
- Since:
- JDK 1.4, HSQLDB 1.7.0
- See Also:
setByte(String,byte)
public byte getByte(int parameterIndex) throws SQLException
<!-- start generic documentation --> Retrieves the value of the designated JDBCTINYINT
parameter as abyte
in the Java programming language. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so on
- Returns:
- the parameter value. If the value is SQL
NULL
, the result is0
.
- See Also:
setByte(String,byte)
public byte[] getBytes(String parameterName) throws SQLException
<!-- start generic documentation --> Retrieves the value of a JDBCBINARY
orVARBINARY
parameter as an array ofbyte
values in the Java programming language. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterName
- the name of the parameter
- Returns:
- the parameter value. If the value is SQL
NULL
, the result isnull
.
- Since:
- JDK 1.4, HSQLDB 1.7.0
- See Also:
setBytes(String,byte[])
public byte[] getBytes(int parameterIndex) throws SQLException
<!-- start generic documentation --> Retrieves the value of the designated JDBCBINARY
orVARBINARY
parameter as an array ofbyte
values in the Java programming language. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so on
- Returns:
- the parameter value. If the value is SQL
NULL
, the result isnull
.
- See Also:
setBytes(String,byte[])
public Clob getClob(String parameterName) throws SQLException
<!-- start generic documentation --> Retrieves the value of a JDBCCLOB
parameter as ajava.sql.Clob
object in the Java programming language. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterName
- the name of the parameter
- Returns:
- the parameter value as a
Clob
object in the Java programming language. If the value was SQLNULL
, the valuenull
is returned.
- Since:
- JDK 1.4, HSQLDB 1.7.0
public Clob getClob(int parameterIndex) throws SQLException
<!-- start generic documentation --> Retrieves the value of the designated JDBCCLOB
parameter as ajava.sql.Clob
object in the Java programming language. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so on
- Returns:
- the parameter value as a
Clob
object in the Java programming language. If the value was SQLNULL
, the valuenull
is returned.
- Since:
- JDK 1.2 (JDK 1.1.x developers: read the new overview for jdbcPreparedStatement)
public Date getDate(String parameterName) throws SQLException
<!-- start generic documentation --> Retrieves the value of a JDBCDATE
parameter as ajava.sql.Date
object. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterName
- the name of the parameter
- Returns:
- the parameter value. If the value is SQL
NULL
, the result isnull
.
- Since:
- JDK 1.4, HSQLDB 1.7.0
- See Also:
setDate
public Date getDate(String parameterName, Calendar cal) throws SQLException
<!-- start generic documentation --> Retrieves the value of a JDBCDATE
parameter as ajava.sql.Date
object, using the givenCalendar
object to construct the date. With aCalendar
object, the driver can calculate the date taking into account a custom timezone and locale. If noCalendar
object is specified, the d river uses the default timezone and locale. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterName
- the name of the parametercal
- theCalendar
object the driver will use to construct the date
- Returns:
- the parameter value. If the value is SQL
NULL
, the result isnull
.
- Since:
- JDK 1.4, HSQLDB 1.7.0
- See Also:
setDate
public Date getDate(int parameterIndex) throws SQLException
<!-- start generic documentation --> Retrieves the value of the designated JDBCDATE
parameter as ajava.sql.Date
object. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so on
- Returns:
- the parameter value. If the value is SQL
NULL
, the result isnull
.
- See Also:
setDate
public Date getDate(int parameterIndex, Calendar cal) throws SQLException
<!-- start generic documentation --> Retrieves the value of the designated JDBCDATE
parameter as ajava.sql.Date
object, using the givenCalendar
object to construct the date. With aCalendar
object, the driver can calculate the date taking into account a custom timezone and locale. If noCalendar
object is specified, the driver uses the default timezone and locale. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so oncal
- theCalendar
object the driver will use to construct the date
- Returns:
- the parameter value. If the value is SQL
NULL
, the result isnull
.
- Since:
- JDK 1.2 (JDK 1.1.x developers: read the new overview for jdbcPreparedStatement)
- See Also:
setDate
public double getDouble(String parameterName) throws SQLException
<!-- start generic documentation --> Retrieves the value of a JDBCDOUBLE
parameter as adouble
in the Java programming language. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterName
- the name of the parameter
- Returns:
- the parameter value. If the value is SQL
NULL
, the result is0
.
- Since:
- JDK 1.4, HSQLDB 1.7.0
- See Also:
setDouble(String,double)
public double getDouble(int parameterIndex) throws SQLException
<!-- start generic documentation --> Retrieves the value of the designated JDBCDOUBLE
parameter as adouble
in the Java programming language. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so on
- Returns:
- the parameter value. If the value is SQL
NULL
, the result is0
.
- See Also:
setDouble(String,double)
public float getFloat(String parameterName) throws SQLException
<!-- start generic documentation --> Retrieves the value of a JDBCFLOAT
parameter as afloat
in the Java programming language. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterName
- the name of the parameter
- Returns:
- the parameter value. If the value is SQL
NULL
, the result is0
.
- Since:
- JDK 1.4, HSQLDB 1.7.0
- See Also:
setFloat(String,float)
public float getFloat(int parameterIndex) throws SQLException
<!-- start generic documentation --> Retrieves the value of the designated JDBCFLOAT
parameter as afloat
in the Java programming language. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so on
- Returns:
- the parameter value. If the value is SQL
NULL
, the result is0
.
- See Also:
setFloat(String,float)
public int getInt(String parameterName) throws SQLException
<!-- start generic documentation --> Retrieves the value of a JDBCINTEGER
parameter as anint
in the Java programming language. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterName
- the name of the parameter
- Returns:
- the parameter value. If the value is SQL
NULL
, the result is0
.
- Since:
- JDK 1.4, HSQLDB 1.7.0
- See Also:
setInt(String,int)
public int getInt(int parameterIndex) throws SQLException
<!-- start generic documentation --> Retrieves the value of the designated JDBCINTEGER
parameter as anint
in the Java programming language. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so on
- Returns:
- the parameter value. If the value is SQL
NULL
, the result is0
.
- See Also:
setInt(String,int)
public long getLong(String parameterName) throws SQLException
<!-- start generic documentation --> Retrieves the value of a JDBCBIGINT
parameter as along
in the Java programming language. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterName
- the name of the parameter
- Returns:
- the parameter value. If the value is SQL
NULL
, the result is0
.
- Since:
- JDK 1.4, HSQLDB 1.7.0
- See Also:
setLong(String,long)
public long getLong(int parameterIndex) throws SQLException
<!-- start generic documentation --> Retrieves the value of the designated JDBCBIGINT
parameter as along
in the Java programming language. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so on
- Returns:
- the parameter value. If the value is SQL
NULL
, the result is0
.
- See Also:
setLong(String,long)
public Object getObject(String parameterName) throws SQLException
<!-- start generic documentation --> Retrieves the value of a parameter as anObject
in the Java programming language. If the value is an SQLNULL
, the driver returns a Javanull
. This method returns a Java object whose type corresponds to the JDBC type that was registered for this parameter using the methodregisterOutParameter
. By registering the target JDBC type asjava.sql.Types.OTHER
, this method can be used to read database-specific abstract data types. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterName
- the name of the parameter
- Returns:
- A
java.lang.Object
holding the OUT parameter value.
- Since:
- JDK 1.4, HSQLDB 1.7.0
- See Also:
java.sql.Types
,setObject
public Object getObject(String parameterName, Map map) throws SQLException
<!-- start generic documentation --> Returns an object representing the value of OUT parameterparameterName
and usesmap
for the custom mapping of the parameter value. This method returns a Java object whose type corresponds to the JDBC type that was registered for this parameter using the methodregisterOutParameter
. By registering the target JDBC type asjava.sql.Types.OTHER
, this method can be used to read database-specific abstract data types. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterName
- the name of the parametermap
- the mapping from SQL type names to Java classes
- Returns:
- a
java.lang.Object
holding the OUT parameter value
- Since:
- JDK 1.4, HSQLDB 1.7.0
- See Also:
setObject
public Object getObject(int parameterIndex) throws SQLException
<!-- start generic documentation --> Retrieves the value of the designated parameter as anObject
in the Java programming language. If the value is an SQLNULL
, the driver returns a Javanull
. This method returns a Java object whose type corresponds to the JDBC type that was registered for this parameter using the methodregisterOutParameter
. By registering the target JDBC type asjava.sql.Types.OTHER
, this method can be used to read database-specific abstract data types. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so on
- Returns:
- A
java.lang.Object
holding the OUT parameter value
- See Also:
java.sql.Types
,setObject
public Object getObject(int parameterIndex, Map map) throws SQLException
<!-- start generic documentation --> Returns an object representing the value of OUT parameterparameterIndex
and usesmap
for the custom mapping of the parameter value. This method returns a Java object whose type corresponds to the JDBC type that was registered for this parameter using the methodregisterOutParameter
. By registering the target JDBC type asjava.sql.Types.OTHER
, this method can be used to read database-specific abstract data types. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so onmap
- the mapping from SQL type names to Java classes
- Returns:
- a
java.lang.Object
holding the OUT parameter value
- Since:
- JDK 1.2 (JDK 1.1.x developers: read the new overview for jdbcPreparedStatement)
- See Also:
setObject
public Ref getRef(String parameterName) throws SQLException
<!-- start generic documentation --> Retrieves the value of a JDBCREF(<structured-type>)
parameter as aRef
object in the Java programming language. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterName
- the name of the parameter
- Returns:
- the parameter value as a
Ref
object in the Java programming language. If the value was SQLNULL
, the valuenull
is returned.
- Since:
- JDK 1.4, HSQLDB 1.7.0
public Ref getRef(int parameterIndex) throws SQLException
<!-- start generic documentation --> Retrieves the value of the designated JDBCREF(<structured-type>)
parameter as ajava.sql.Ref
object in the Java programming language. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so on
- Returns:
- the parameter value as a
Ref
object in the Java programming language. If the value was SQLNULL
, the valuenull
is returned.
- Since:
- JDK 1.2 (JDK 1.1.x developers: read the new overview for jdbcPreparedStatement)
public short getShort(String parameterName) throws SQLException
<!-- start generic documentation --> Retrieves the value of a JDBCSMALLINT
parameter as ashort
in the Java programming language. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterName
- the name of the parameter
- Returns:
- the parameter value. If the value is SQL
NULL
, the result is0
.
- Since:
- JDK 1.4, HSQLDB 1.7.0
- See Also:
setShort(String,short)
public short getShort(int parameterIndex) throws SQLException
<!-- start generic documentation --> Retrieves the value of the designated JDBCSMALLINT
parameter as ashort
in the Java programming language. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so on
- Returns:
- the parameter value. If the value is SQL
NULL
, the result is0
.
- See Also:
setShort(String,short)
public String getString(String parameterName) throws SQLException
<!-- start generic documentation --> Retrieves the value of a JDBCCHAR
,VARCHAR
, orLONGVARCHAR
parameter as aString
in the Java programming language. For the fixed-length type JDBCCHAR
, theString
object returned has exactly the same value the (JDBC4 clarification:) SQLCHAR
value had in the database, including any padding added by the database. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterName
- the name of the parameter
- Returns:
- the parameter value. If the value is SQL
NULL
, the result isnull
.
- Since:
- JDK 1.4, HSQLDB 1.7.0
- See Also:
setString(String,String)
public String getString(int parameterIndex) throws SQLException
<!-- start generic documentation --> Retrieves the value of the designated JDBCCHAR
,VARCHAR
, orLONGVARCHAR
parameter as aString
in the Java programming language. For the fixed-length type JDBCCHAR
, theString
object returned has exactly the same value the (JDBC4 clarification:) SQLCHAR
value had in the database, including any padding added by the database. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so on
- Returns:
- the parameter value. If the value is SQL
NULL
, the result isnull
.
- See Also:
setString(String,String)
public Time getTime(String parameterName) throws SQLException
<!-- start generic documentation --> Retrieves the value of a JDBCTIME
parameter as ajava.sql.Time
object. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterName
- the name of the parameter
- Returns:
- the parameter value. If the value is SQL
NULL
, the result isnull
.
- Since:
- JDK 1.4, HSQLDB 1.7.0
- See Also:
setTime
public Time getTime(String parameterName, Calendar cal) throws SQLException
<!-- start generic documentation --> Retrieves the value of a JDBCTIME
parameter as ajava.sql.Time
object, using the givenCalendar
object to construct the time. With aCalendar
object, the driver can calculate the time taking into account a custom timezone and locale. If noCalendar
object is specified, the driver uses the default timezone and locale. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterName
- the name of the parametercal
- theCalendar
object the driver will use to construct the time
- Returns:
- the parameter value; if the value is SQL
NULL
, the result isnull
.
- Since:
- JDK 1.4, HSQLDB 1.7.0
- See Also:
setTime
public Time getTime(int parameterIndex) throws SQLException
<!-- start generic documentation --> Retrieves the value of the designated JDBCTIME
parameter as ajava.sql.Time
object. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so on
- Returns:
- the parameter value. If the value is SQL
NULL
, the result isnull
.
- See Also:
setTime
public Time getTime(int parameterIndex, Calendar cal) throws SQLException
<!-- start generic documentation --> Retrieves the value of the designated JDBCTIME
parameter as ajava.sql.Time
object, using the givenCalendar
object to construct the time. With aCalendar
object, the driver can calculate the time taking into account a custom timezone and locale. If noCalendar
object is specified, the driver uses the default timezone and locale. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so oncal
- theCalendar
object the driver will use to construct the time
- Returns:
- the parameter value; if the value is SQL
NULL
, the result isnull
.
- Since:
- JDK 1.2 (JDK 1.1.x developers: read the new overview for jdbcPreparedStatement)
- See Also:
setTime
public Timestamp getTimestamp(String parameterName) throws SQLException
<!-- start generic documentation --> Retrieves the value of a JDBCTIMESTAMP
parameter as ajava.sql.Timestamp
object. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterName
- the name of the parameter
- Returns:
- the parameter value. If the value is SQL
NULL
, the result isnull
.
- Since:
- JDK 1.4, HSQLDB 1.7.0
- See Also:
setTimestamp
public Timestamp getTimestamp(String parameterName, Calendar cal) throws SQLException
<!-- start generic documentation --> Retrieves the value of a JDBCTIMESTAMP
parameter as ajava.sql.Timestamp
object, using the givenCalendar
object to construct theTimestamp
object. With aCalendar
object, the driver can calculate the timestamp taking into account a custom timezone and locale. If noCalendar
object is specified, the driver uses the default timezone and locale. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterName
- the name of the parametercal
- theCalendar
object the driver will use to construct the timestamp
- Returns:
- the parameter value. If the value is SQL
NULL
, the result isnull
.
- Since:
- JDK 1.4, HSQLDB 1.7.0
- See Also:
setTimestamp
public Timestamp getTimestamp(int parameterIndex) throws SQLException
<!-- start generic documentation --> Retrieves the value of the designated JDBCTIMESTAMP
parameter as ajava.sql.Timestamp
object. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so on
- Returns:
- the parameter value. If the value is SQL
NULL
, the result isnull
.
- See Also:
setTimestamp
public Timestamp getTimestamp(int parameterIndex, Calendar cal) throws SQLException
<!-- start generic documentation --> Retrieves the value of the designated JDBCTIMESTAMP
parameter as ajava.sql.Timestamp
object, using the givenCalendar
object to construct theTimestamp
object. With aCalendar
object, the driver can calculate the timestamp taking into account a custom timezone and locale. If noCalendar
object is specified, the driver uses the default timezone and locale. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so oncal
- theCalendar
object the driver will use to construct the timestamp
- Returns:
- the parameter value. If the value is SQL
NULL
, the result isnull
.
- Since:
- JDK 1.2 (JDK 1.1.x developers: read the new overview for jdbcPreparedStatement)
- See Also:
setTimestamp
public java.net.URL getURL(String parameterName) throws SQLException
<!-- start generic documentation --> Retrieves the value of a JDBCDATALINK
parameter as ajava.net.URL
object. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterName
- the name of the parameter
- Returns:
- the parameter value as a
java.net.URL
object in the Java programming language. If the value was SQLNULL
, the valuenull
is returned.
- Since:
- JDK 1.4, HSQLDB 1.7.0
- See Also:
setURL(String,URL)
public java.net.URL getURL(int parameterIndex) throws SQLException
<!-- start generic documentation --> Retrieves the value of the designated JDBCDATALINK
parameter as ajava.net.URL
object. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2,...
- Returns:
- a
java.net.URL
object that represents the JDBCDATALINK
value used as the designated parameter
- Since:
- JDK 1.4, HSQLDB 1.7.0
- See Also:
setURL(String,URL)
public void registerOutParameter(String parameterName, int sqlType) throws SQLException
<!-- start generic documentation --> Registers the OUT parameter namedparameterName
to the JDBC typesqlType
. All OUT parameters must be registered before a stored procedure is executed. The JDBC type specified bysqlType
for an OUT parameter determines the Java type that must be used in theget
method to read the value of that parameter. If the JDBC type expected to be returned to this output parameter is specific to this particular database,sqlType
should bejava.sql.Types.OTHER
. The methodgetObject
retrieves the value. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterName
- the name of the parametersqlType
- the JDBC type code defined byjava.sql.Types
. If the parameter is of JDBC typeNUMERIC
orDECIMAL
, the version ofregisterOutParameter
that accepts a scale value should be used.
- Since:
- JDK 1.4, HSQL 1.7.0
- See Also:
java.sql.Types
public void registerOutParameter(String parameterName, int sqlType, String typeName) throws SQLException
<!-- start generic documentation --> Registers the designated output parameter. This version of the methodregisterOutParameter
should be used for a user-named or REF output parameter. Examples of user-named types include: STRUCT, DISTINCT, JAVA_OBJECT, and named array types. (JDBC4 clarification:) All OUT parameters must be registered before a stored procedure is executed. For a user-named parameter the fully-qualified SQL type name of the parameter should also be given, while a REF parameter requires that the fully-qualified type name of the referenced type be given. A JDBC driver that does not need the type code and type name information may ignore it. To be portable, however, applications should always provide these values for user-named and REF parameters. Although it is intended for user-named and REF parameters, this method may be used to register a parameter of any JDBC type. If the parameter does not have a user-named or REF type, the typeName parameter is ignored. Note: When reading the value of an out parameter, you must use thegetXXX
method whose Java type XXX corresponds to the parameter's registered SQL type. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterName
- the name of the parametersqlType
- a value fromjava.sql.Types
typeName
- the fully-qualified name of an SQL structured type
- Since:
- JDK 1.4, HSQL 1.7.0
- See Also:
java.sql.Types
public void registerOutParameter(String parameterName, int sqlType, int scale) throws SQLException
<!-- start generic documentation --> Registers the parameter namedparameterName
to be of JDBC typesqlType
. (JDBC4 clarification:) All OUT parameters must be registered before a stored procedure is executed. The JDBC type specified bysqlType
for an OUT parameter determines the Java type that must be used in theget
method to read the value of that parameter. This version ofregisterOutParameter
should be used when the parameter is of JDBC typeNUMERIC
orDECIMAL
. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterName
- the name of the parametersqlType
- SQL type code defined byjava.sql.Types
.scale
- the desired number of digits to the right of the decimal point. It must be greater than or equal to zero.
- Since:
- JDK 1.4, HSQLDB 1.7.0
- See Also:
java.sql.Types
public void registerOutParameter(int parameterIndex, int sqlType) throws SQLException
<!-- start generic documentation --> Registers the OUT parameter in ordinal positionparameterIndex
to the JDBC typesqlType
. All OUT parameters must be registered before a stored procedure is executed. The JDBC type specified bysqlType
for an OUT parameter determines the Java type that must be used in theget
method to read the value of that parameter. If the JDBC type expected to be returned to this output parameter is specific to this particular database,sqlType
should bejava.sql.Types.OTHER
. The methodgetObject
retrieves the value. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so onsqlType
- the JDBC type code defined byjava.sql.Types
. If the parameter is of JDBC typeNUMERIC
orDECIMAL
, the version ofregisterOutParameter
that accepts a scale value should be used.
- See Also:
java.sql.Types
public void registerOutParameter(int parameterIndex, int sqlType, String typeName) throws SQLException
<!-- start generic documentation --> Registers the designated output parameter. This version of the methodregisterOutParameter
should be used for a user-defined orREF
output parameter. Examples of user-defined types include:STRUCT
,DISTINCT
,JAVA_OBJECT
, and named array types. (JDBC4 claraification:) All OUT parameters must be registered before a stored procedure is executed. For a user-defined parameter, the fully-qualified SQL type name of the parameter should also be given, while aREF
parameter requires that the fully-qualified type name of the referenced type be given. A JDBC driver that does not need the type code and type name information may ignore it. To be portable, however, applications should always provide these values for user-defined andREF
parameters. Although it is intended for user-defined andREF
parameters, this method may be used to register a parameter of any JDBC type. If the parameter does not have a user-defined orREF
type, the typeName parameter is ignored. Note: When reading the value of an out parameter, you must use the getter method whose Java type corresponds to the parameter's registered SQL type. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2,...sqlType
- a value fromjava.sql.Types
typeName
- the fully-qualified name of an SQL structured type
- Since:
- JDK 1.2 (JDK 1.1.x developers: read the new overview for jdbcPreparedStatement)
- See Also:
java.sql.Types
public void registerOutParameter(int parameterIndex, int sqlType, int scale) throws SQLException
<!-- start generic documentation --> Registers the parameter in ordinal positionparameterIndex
to be of JDBC typesqlType
. This method must be called before a stored procedure is executed. The JDBC type specified bysqlType
for an OUT parameter determines the Java type that must be used in theget
method to read the value of that parameter. This version ofregisterOutParameter
should be used when the parameter is of JDBC typeNUMERIC
orDECIMAL
. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, and so onsqlType
- the SQL type code defined byjava.sql.Types
.scale
- the desired number of digits to the right of the decimal point. It must be greater than or equal to zero.
- See Also:
java.sql.Types
public void setAsciiStream(String parameterName, java.io.InputStream x, int length) throws SQLException
<!-- start generic documentation --> Sets the designated parameter to the given input stream, which will have the specified number of bytes. When a very large ASCII value is input to aLONGVARCHAR
parameter, it may be more practical to send it via ajava.io.InputStream
. Data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from ASCII to the database char format. Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
Starting with 1.7.2, HSLQDB supports this.
- Parameters:
parameterName
- the name of the parameterx
- the Java input stream that contains the ASCII parameter valuelength
- the number of bytes in the stream
- Since:
- JDK 1.4, HSQLDB 1.7.0
public void setBigDecimal(String parameterName, BigDecimal x) throws SQLException
<!-- start generic documentation --> Sets the designated parameter to the givenjava.math.BigDecimal
value. The driver converts this to an SQLNUMERIC
value when it sends it to the database. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
Starting with 1.7.2, HSLQDB supports this.
- Parameters:
parameterName
- the name of the parameterx
- the parameter value
- Since:
- JDK 1.4, HSQLDB 1.7.0
- See Also:
getBigDecimal
public void setBinaryStream(String parameterName, java.io.InputStream x, int length) throws SQLException
<!-- start generic documentation --> Sets the designated parameter to the given input stream, which will have the specified number of bytes. When a very large binary value is input to aLONGVARBINARY
parameter, it may be more practical to send it via ajava.io.InputStream
object. The data will be read from the stream as needed until end-of-file is reached. Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
Starting with 1.7.2, HSLQDB supports this.
- Parameters:
parameterName
- the name of the parameterx
- the java input stream which contains the binary parameter valuelength
- the number of bytes in the stream
- Since:
- JDK 1.4, HSQLDB 1.7.0
public void setBoolean(String parameterName, boolean x) throws SQLException
<!-- start generic documentation --> Sets the designated parameter to the given Javaboolean
value. (JDBC4 clarification:) The driver converts this to an SQLBIT
orBOOLEAN
value when it sends it to the database. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
Starting with 1.7.2, HSLQDB supports this.
- Parameters:
parameterName
- the name of the parameterx
- the parameter value
- Since:
- JDK 1.4, HSQLDB 1.7.0
- See Also:
getBoolean
public void setByte(String parameterName, byte x) throws SQLException
<!-- start generic documentation --> Sets the designated parameter to the given Javabyte
value. The driver converts this to an SQLTINYINT
value when it sends it to the database. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
Starting with 1.7.2, HSLQDB supports this.
- Parameters:
parameterName
- the name of the parameterx
- the parameter value
- Since:
- JDK 1.4, HSQLDB 1.7.0
- See Also:
getByte
public void setBytes(String parameterName, byte[] x) throws SQLException
<!-- start generic documentation --> Sets the designated parameter to the given Java array of bytes. The driver converts this to an SQLVARBINARY
orLONGVARBINARY
(depending on the argument's size relative to the driver's limits onVARBINARY
values) when it sends it to the database. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
Starting with 1.7.2, HSLQDB supports this.
- Parameters:
parameterName
- the name of the parameterx
- the parameter value
- Since:
- JDK 1.4, HSQLDB 1.7.0
- See Also:
getBytes
public void setCharacterStream(String parameterName, java.io.Reader reader, int length) throws SQLException
<!-- start generic documentation --> Sets the designated parameter to the givenReader
object, which is the given number of characters long. When a very large UNICODE value is input to aLONGVARCHAR
parameter, it may be more practical to send it via ajava.io.Reader
object. The data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from UNICODE to the database char format. Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
Starting with 1.7.2, HSLQDB supports this.
- Parameters:
parameterName
- the name of the parameterreader
- thejava.io.Reader
object that contains the UNICODE data used as the designated parameterlength
- the number of characters in the stream
- Since:
- JDK 1.4, HSQLDB 1.7.0
public void setDate(String parameterName, Date x) throws SQLException
<!-- start generic documentation --> (JDBC4 clarification:) Sets the designated parameter to the givenjava.sql.Date
value using the default time zone of the virtual machine that is running the application. The driver converts this to an SQLDATE
value when it sends it to the database. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
Starting with 1.7.2, HSLQDB supports this.
- Parameters:
parameterName
- the name of the parameterx
- the parameter value
- Since:
- JDK 1.4, HSQLDB 1.7.0
- See Also:
getDate
public void setDate(String parameterName, Date x, Calendar cal) throws SQLException
<!-- start generic documentation --> Sets the designated parameter to the givenjava.sql.Date
value, using the givenCalendar
object. The driver uses theCalendar
object to construct an SQLDATE
value, which the driver then sends to the database. With a aCalendar
object, the driver can calculate the date taking into account a custom timezone. If noCalendar
object is specified, the driver uses the default timezone, which is that of the virtual machine running the application. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
Starting with 1.7.2, HSLQDB supports this.
- Parameters:
parameterName
- the name of the parameterx
- the parameter valuecal
- theCalendar
object the driver will use to construct the date
- Since:
- JDK 1.4, HSQLDB 1.7.0
- See Also:
getDate
public void setDouble(String parameterName, double x) throws SQLException
<!-- start generic documentation --> Sets the designated parameter to the given Javadouble
value. The driver converts this to an SQLDOUBLE
value when it sends it to the database. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
Starting with 1.7.2, HSLQDB supports this.
- Parameters:
parameterName
- the name of the parameterx
- the parameter value
- Since:
- JDK 1.4, HSQLDB 1.7.0
- See Also:
getDouble
public void setFloat(String parameterName, float x) throws SQLException
<!-- start generic documentation --> Sets the designated parameter to the given Javafloat
value. The driver converts this to an SQLFLOAT
value when it sends it to the database. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
Starting with 1.7.2, HSLQDB supports this.
- Parameters:
parameterName
- the name of the parameterx
- the parameter value
- Since:
- JDK 1.4, HSQLDB 1.7.0
- See Also:
getFloat
public void setInt(String parameterName, int x) throws SQLException
<!-- start generic documentation --> Sets the designated parameter to the given Javaint
value. The driver converts this to an SQLINTEGER
value when it sends it to the database. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
Starting with 1.7.2, HSLQDB supports this.
- Parameters:
parameterName
- the name of the parameterx
- the parameter value
- Since:
- JDK 1.4, HSQLDB 1.7.0
- See Also:
getInt
public void setLong(String parameterName, long x) throws SQLException
<!-- start generic documentation --> Sets the designated parameter to the given Javalong
value. The driver converts this to an SQLBIGINT
value when it sends it to the database. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
Starting with 1.7.2, HSLQDB supports this.
- Parameters:
parameterName
- the name of the parameterx
- the parameter value
- Since:
- JDK 1.4, HSQLDB 1.7.0
- See Also:
getLong
public void setNull(String parameterName, int sqlType) throws SQLException
<!-- start generic documentation --> Sets the designated parameter to SQLNULL
. Note: You must specify the parameter's SQL type. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
Starting with 1.7.2, HSLQDB supports this.
- Parameters:
parameterName
- the name of the parametersqlType
- the SQL type code defined injava.sql.Types
- Since:
- JDK 1.4, HSQLDB 1.7.0
public void setNull(String parameterName, int sqlType, String typeName) throws SQLException
<!-- start generic documentation --> Sets the designated parameter to SQLNULL
. This version of the methodsetNull
should be used for user-defined types andREF
type parameters. Examples of user-defined types include:STRUCT
,DISTINCT
,JAVA_OBJECT
, and named array types. Note: To be portable, applications must give the SQL type code and the fully-qualified SQL type name when specifying aNULL
user-defined orREF
parameter. In the case of a user-defined type the name is the type name of the parameter itself. For aREF
parameter, the name is the type name of the referenced type. If a JDBC driver does not need the type code or type name information, it may ignore it. Although it is intended for user-defined andRef
parameters, this method may be used to set a null parameter of any JDBC type. If the parameter does not have a user-defined orREF
type, the giventypeName
is ignored. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
Starting with 1.7.2, HSLQDB supports this.
- Parameters:
parameterName
- the name of the parametersqlType
- a value fromjava.sql.Types
typeName
- the fully-qualified name of an SQL user-defined type; ignored if the parameter is not a user-defined type or SQLREF
value
- Since:
- JDK 1.4, HSQLDB 1.7.0
public void setObject(String parameterName, Object x) throws SQLException
<!-- start generic documentation --> Sets the value of the designated parameter with the given object. The second parameter must be of typeObject
; therefore, thejava.lang
equivalent objects should be used for built-in types. The JDBC specification specifies a standard mapping from JavaObject
types to SQL types. The given argument will be converted to the corresponding SQL type before being sent to the database. Note that this method may be used to pass datatabase- specific abstract data types, by using a driver-specific Java type. If the object is of a class implementing the interfaceSQLData
, the JDBC driver should call the methodSQLData.writeSQL
to write it to the SQL data stream. If, on the other hand, the object is of a class implementingRef
,Blob
,Clob
,Struct
, orArray
, the driver should pass it to the database as a value of the corresponding SQL type. This method throws an exception if there is an ambiguity, for example, if the object is of a class implementing more than one of the interfaces named above. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
Starting with 1.7.2, HSLQDB supports this.
- Parameters:
parameterName
- the name of the parameterx
- the object containing the input parameter value
- Since:
- JDK 1.4, HSQLDB 1.7.0
- See Also:
getObject
public void setObject(String parameterName, Object x, int targetSqlType) throws SQLException
<!-- start generic documentation --> Sets the value of the designated parameter with the given object. This method is like the methodsetObject
above, except that it assumes a scale of zero. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
Starting with 1.7.2, HSLQDB supports this.
- Parameters:
parameterName
- the name of the parameterx
- the object containing the input parameter valuetargetSqlType
- the SQL type (as defined in java.sql.Types) to be sent to the database
- Since:
- JDK 1.4, HSQLDB 1.7.0
- See Also:
getObject
public void setObject(String parameterName, Object x, int targetSqlType, int scale) throws SQLException
<!-- start generic documentation --> Sets the value of the designated parameter with the given object. The second argument must be an object type; for integral values, thejava.lang
equivalent objects should be used. The given Java object will be converted to the given targetSqlType before being sent to the database. If the object has a custom mapping (is of a class implementing the interfaceSQLData
), the JDBC driver should call the methodSQLData.writeSQL
to write it to the SQL data stream. If, on the other hand, the object is of a class implementingRef
,Blob
,Clob
,Struct
, orArray
, the driver should pass it to the database as a value of the corresponding SQL type. Note that this method may be used to pass datatabase- specific abstract data types. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
Starting with 1.7.2, HSLQDB supports this.
- Parameters:
parameterName
- the name of the parameterx
- the object containing the input parameter valuetargetSqlType
- the SQL type (as defined in java.sql.Types) to be sent to the database. The scale argument may further qualify this type.scale
- 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.
- Since:
- JDK 1.4, HSQLDB 1.7.0
- See Also:
java.sql.Types
,getObject
public void setShort(String parameterName, short x) throws SQLException
<!-- start generic documentation --> Sets the designated parameter to the given Javashort
value. The driver converts this to an SQLSMALLINT
value when it sends it to the database. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
Starting with 1.7.2, HSLQDB supports this.
- Parameters:
parameterName
- the name of the parameterx
- the parameter value
- Since:
- JDK 1.4, HSQLDB 1.7.0
- See Also:
getShort
public void setString(String parameterName, String x) throws SQLException
<!-- start generic documentation --> Sets the designated parameter to the given JavaString
value. The driver converts this to an SQLVARCHAR
orLONGVARCHAR
value (depending on the argument's size relative to the driver's limits onVARCHAR
values) when it sends it to the database. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
Starting with 1.7.2, HSLQDB supports this.
- Parameters:
parameterName
- the name of the parameterx
- the parameter value
- Since:
- JDK 1.4, HSQLDB 1.7.0
- See Also:
getString
public void setTime(String parameterName, Time x) throws SQLException
<!-- start generic documentation --> Sets the designated parameter to the givenjava.sql.Time
value. The driver converts this to an SQLTIME
value when it sends it to the database. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
Starting with 1.7.2, HSLQDB supports this.
- Parameters:
parameterName
- the name of the parameterx
- the parameter value
- Since:
- JDK 1.4, HSQLDB 1.7.0
- See Also:
getTime
public void setTime(String parameterName, Time x, Calendar cal) throws SQLException
<!-- start generic documentation --> Sets the designated parameter to the givenjava.sql.Time
value, using the givenCalendar
object. The driver uses theCalendar
object to construct an SQLTIME
value, which the driver then sends to the database. With a aCalendar
object, the driver can calculate the time taking into account a custom timezone. If noCalendar
object is specified, the driver uses the default timezone, which is that of the virtual machine running the application. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
Starting with 1.7.2, HSLQDB supports this.
- Parameters:
parameterName
- the name of the parameterx
- the parameter valuecal
- theCalendar
object the driver will use to construct the time
- Since:
- JDK 1.4, HSQLDB 1.7.0
- See Also:
getTime
public void setTimestamp(String parameterName, Timestamp x) throws SQLException
<!-- start generic documentation --> Sets the designated parameter to the givenjava.sql.Timestamp
value. The driver converts this to an SQLTIMESTAMP
value when it sends it to the database. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
Starting with 1.7.2, HSLQDB supports this.
- Parameters:
parameterName
- the name of the parameterx
- the parameter value
- Since:
- JDK 1.4, HSQLDB 1.7.0
- See Also:
getTimestamp
public void setTimestamp(String parameterName, Timestamp x, Calendar cal) throws SQLException
<!-- start generic documentation --> Sets the designated parameter to the givenjava.sql.Timestamp
value, using the givenCalendar
object. The driver uses theCalendar
object to construct an SQLTIMESTAMP
value, which the driver then sends to the database. With aCalendar
object, the driver can calculate the timestamp taking into account a custom timezone. If noCalendar
object is specified, the driver uses the default timezone, which is that of the virtual machine running the application. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
Starting with 1.7.2, HSLQDB supports this.
- Parameters:
parameterName
- the name of the parameterx
- the parameter valuecal
- theCalendar
object the driver will use to construct the timestamp
- Since:
- JDK 1.4, HSQLDB 1.7.0
- See Also:
getTimestamp
public void setURL(String parameterName, java.net.URL val) throws SQLException
<!-- start generic documentation --> Sets the designated parameter to the givenjava.net.URL
object. The driver converts this to an SQLDATALINK
value when it sends it to the database. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Parameters:
parameterName
- the name of the parameterval
- the parameter value
- Since:
- JDK 1.4, HSQLDB 1.7.0
- See Also:
getURL
public boolean wasNull() throws SQLException
<!-- start generic documentation --> Retrieves whether the last OUT parameter read had the value of SQLNULL
. Note that this method should be called only after calling a getter method; otherwise, there is no value to use in determining whether it isnull
or not. <!-- end generic documentation --> <!-- start release-specific documentation --><!-- end release-specific documentation -->HSQLDB-Specific Information:
HSQLDB 1.7.2 does not support this feature. Calling this method always throws anSQLException
.
- Returns:
true
if the last parameter read was SQLNULL
;false
otherwise