com.ibm.websphere.rsadapter
Interface WSRdbRecord
- public interface WSRdbRecord
- extends javax.resource.cci.Record
This interface extends from javax.resource.cci.Record. An implementation of this interface serves as a Record.
The WSRdbRecord is a record from which users can access the ResultSet object and retrieve the out parameters of the CallableStatement.
One typical usage of this interface is that users call getMoreResults() and getResultSet() to get the result sets. After retrieving all the result sets, users can call getXXX() to get the out parameter values of the CallableStatement.
Here is one example:
In FunctionSet class, users write the following code:
cstmt = prepareCall(obj, "{call transfer{?,?,?,?)}"); cstmt.setString(1, fromAccountNumber); cstmt.setString(2, toAccountNumber); cstmt.setDouble(3, amount); cstmt.registerOutParameter(4, java.sql.Types.DATE); cstmt.execute(); return createCCIRecord(obj, cstmt);
In the above code, createCCIRecord(obj, cstmt) creates a WSRdbRecord object. We only allow users call execute to the CallableStatement. Users will get method unsupported exceptions if users call other executeXXX() methods.
In the CMP bean BusinessMethodExtractor class, users can access the result sets by calling WSRdbRecord.getMoreResults() and WSRdbRecord.getResultSet(), and access the out parameter values of the CallableStatement by calling WSRdbRecord.getXXX() methods.
WSRdbRecord record = (WSRdbRecord) indexedRecord; while (record.getMoreResults()) { java.sql.ResultSet rs = record.getResultSet(); // access the results. ... } // Get the out parameter values record.getDate(4);
Currently, we don't support multiple open result sets.
Method Summary
Modifier and Type | Method and Description |
---|---|
|
getArray(int i)
Retrieves the value of the designated JDBC ARRAY parameter as an Array object in
the Java programming language.
|
|
getArray(java.lang.String parameterName)
Retrieves the value of the designated JDBC ARRAY parameter as an Array object in
the Java programming language.
|
|
getBigDecimal(int parameterIndex)
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.
|
|
getBigDecimal(int parameterIndex,int scale)
Deprecated. use getBigDecimal(int parameterIndex) or getBigDecimal(String parameterName)
|
|
getBigDecimal(java.lang.String parameterName)
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.
|
|
getBlob(int i)
Retrieves the value of the designated JDBC BLOB parameter as a Blob object in the
Java programming language.
|
|
getBlob(java.lang.String parameterName)
Retrieves the value of a JDBC BLOB parameter as a Blob object in the Java programming
language.
|
|
getBoolean(int parameterIndex)
Retrieves the value of the designated JDBC BIT parameter as a boolean in the Java programming
language.
|
|
getBoolean(java.lang.String parameterName)
Retrieves the value of a JDBC BIT parameter as a boolean in the Java programming language.
|
|
getByte(int parameterIndex)
Retrieves the value of the designated JDBC TINYINT parameter as a byte in the Java
programming language.
|
|
getByte(java.lang.String parameterName)
Retrieves the value of a JDBC TINYINT parameter as a byte in the Java programming
language.
|
|
getBytes(int parameterIndex)
Retrieves the value of the designated JDBC BINARY or VARBINARY parameter as an
array of byte values in the Java programming language.
|
|
getBytes(java.lang.String parameterName)
Retrieves the value of a JDBC BINARY or VARBINARY parameter as an array of byte
values in the Java programming language.
|
|
getClob(int i)
Retrieves the value of the designated JDBC CLOB parameter as a Clob object in
the Java programming language.
|
|
getClob(java.lang.String parameterName)
Retrieves the value of a JDBC CLOB parameter as a Clob object in the Java
programming language.
|
|
getDate(int parameterIndex)
Retrieves the value of the designated JDBC DATE parameter as a java.sql.Date
object.
|
|
getDate(int parameterIndex,java.util.Calendar cal)
Retrieves the value of the designated JDBC DATE parameter as a java.sql.Date object,
using the given Calendar object to construct the date.
|
|
getDate(java.lang.String parameterName)
Retrieves the value of a JDBC DATE parameter as a java.sql.Date object.
|
|
getDate(java.lang.String parameterName,java.util.Calendar cal)
Retrieves the value of a JDBC DATE parameter as a java.sql.Date object, using the
given Calendar object to construct the date.
|
|
getDouble(int parameterIndex)
Retrieves the value of the designated JDBC DOUBLE parameter as a double in
the Java programming language.
|
|
getDouble(java.lang.String parameterName)
Retrieves the value of a JDBC DOUBLE parameter as a double in the Java
programming language.
|
|
getFloat(int parameterIndex)
Retrieves the value of the designated JDBC FLOAT parameter as a float in
the Java programming language.
|
|
getFloat(java.lang.String parameterName)
Retrieves the value of a JDBC FLOAT parameter as a float in the Java programming
language.
|
|
getInt(int parameterIndex)
Retrieves the value of the designated JDBC INTEGER parameter as an int in the
Java programming language.
|
|
getInt(java.lang.String parameterName)
Retrieves the value of a JDBC INTEGER parameter as an int in the Java
programming language.
|
|
getLong(int parameterIndex)
Retrieves the value of the designated JDBC BIGINT parameter as a long in
the Java programming language.
|
|
getLong(java.lang.String parameterName)
Retrieves the value of a JDBC BIGINT parameter as a long in the Java
programming language.
|
|
getMoreResults()
Moves to this Record object's next result, returns true if it is a
ResultSet object, and implicitly closes any current ResultSet object(s)
obtained with the method getResultSet.
|
|
getObject(int parameterIndex)
Retrieves the value of the designated parameter as an Object in the Java
programming language.
|
|
getObject(int i,java.util.Map map)
Returns an object representing the value of OUT parameter i and uses map for
the custom mapping of the parameter value.
|
|
getObject(java.lang.String parameterName)
Retrieves the value of a parameter as an Object in the Java programming
language.
|
|
getObject(java.lang.String parameterName,java.util.Map map)
Returns an object representing the value of OUT parameter i and uses map for
the custom mapping of the parameter value.
|
|
getRef(int i)
Retrieves the value of the designated JDBC REF(
|
|
getRef(java.lang.String parameterName)
Retrieves the value of a JDBC REF(
|
|
getResultSet()
Retrieves the current result as a ResultSet object.
|
|
getShort(int parameterIndex)
Retrieves the value of the designated JDBC SMALLINT parameter as a short
in the Java programming language.
|
|
getShort(java.lang.String parameterName)
Retrieves the value of a JDBC SMALLINT parameter as a short in the Java
programming language.
|
|
getString(int parameterIndex)
Retrieves the value of the designated JDBC CHAR, VARCHAR, or LONGVARCHAR
parameter as a String in the Java programming language.
|
|
getString(java.lang.String parameterName)
Retrieves the value of a JDBC CHAR, VARCHAR, or LONGVARCHAR parameter as a
String in the Java programming language.
|
|
getTime(int parameterIndex)
Retrieves the value of the designated JDBC TIME parameter as a java.sql.Time
object.
|
|
getTime(int parameterIndex,java.util.Calendar cal)
Retrieves the value of the designated JDBC TIME parameter as a java.sql.Time object,
using the given Calendar object to construct the time.
|
|
getTime(java.lang.String parameterName)
Retrieves the value of a JDBC TIME parameter as a java.sql.Time object.
|
|
getTime(java.lang.String parameterName,java.util.Calendar cal)
Retrieves the value of a JDBC TIME parameter as a java.sql.Time object,
using the given Calendar object to construct the time.
|
|
getTimestamp(int parameterIndex)
Retrieves the value of the designated JDBC TIMESTAMP parameter as a
java.sql.Timestamp object.
|
|
getTimestamp(int parameterIndex,java.util.Calendar cal)
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.
|
|
getTimestamp(java.lang.String parameterName)
Retrieves the value of the designated JDBC TIMESTAMP parameter as a
java.sql.Timestamp object.
|
|
getTimestamp(java.lang.String parameterName,java.util.Calendar cal)
Retrieves the value of a JDBC TIMESTAMP parameter as a java.sql.Timestamp
object, using the given Calendar object to construct the Timestamp object.
|
|
getUpdateCount()
Retrieves the current result as an update count; if the result is a
ResultSet object or there are no more results, -1 is returned.
|
|
getURL(int parameterIndex)
Retrieves the value of the designated JDBC DATALINK parameter as a java.net.URL
object.
|
|
getURL(java.lang.String parameterName)
Retrieves the value of a JDBC DATALINK parameter as a java.net.URL object.
|
|
wasNull()
Retrieves whether the last OUT parameter read had the value of SQL NULL.
|
Methods inherited from interface javax.resource.cci.Record |
---|
clone, equals, getRecordName, getRecordShortDescription, hashCode, setRecordName, setRecordShortDescription |
Method Detail
getResultSet
- java.sql.ResultSet getResultSet( )
- throws java.sql.SQLException
java.sql.SQLException
- if a database access error occurs getUpdateCount
- int getUpdateCount()
- throws java.sql.SQLException
Retrieves the current result as an update count; if the result is a ResultSet object or there are no more results, -1 is returned. This method should be called only once per result.
java.sql.SQLException
- if a database access error occurs getMoreResults
- boolean getMoreResults()
- throws java.sql.SQLException
Moves to this Record object's next result, returns true if it is a ResultSet object, and implicitly closes any current ResultSet object(s) obtained with the method getResultSet.
There are no more results when the following is true:
(!getMoreResults() && (getUpdateCount() == -1)
java.sql.SQLException
- if a database access error occurs getArray
- java.sql.Array getArray(int i)
- throws java.sql.SQLException
Retrieves the value of the designated JDBC ARRAY parameter as an Array object in the Java programming language.
i
- the first parameter is 1, the second is 2, and so on java.sql.SQLException
- if a database access error occurs. getArray
- java.sql.Array getArray(java.lang.String parameterName)
- throws java.sql.SQLException
Retrieves the value of the designated JDBC ARRAY parameter as an Array object in the Java programming language.
java.sql.SQLException
- if a database access error occurs getBigDecimal
- java.math.BigDecimal getBigDecimal( int parameterIndex)
- throws java.sql.SQLException
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.
parameterIndex
- the first parameter is 1, the second is 2, and so on java.sql.SQLException
- if a database access error occurs getBigDecimal
- java.math.BigDecimal getBigDecimal( int parameterIndex,
- int scale)
- throws java.sql.SQLException
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.
parameterIndex
- the first parameter is 1, the second is 2, and so on scale
- the number of digits to the right of the decimal point java.sql.SQLException
- if a database access error occurs getBigDecimal
- java.math.BigDecimal getBigDecimal( java.lang.String parameterName)
- throws java.sql.SQLException
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.
parameterName
- the name of the parameter java.sql.SQLException
- if a database access error occurs getBlob
- java.sql.Blob getBlob(int i)
- throws java.sql.SQLException
Retrieves the value of the designated JDBC BLOB parameter as a Blob object in the Java programming language.
i
- the first parameter is 1, the second is 2, and so on java.sql.SQLException
- if a database access error occurs getBlob
- java.sql.Blob getBlob(java.lang.String parameterName)
- throws java.sql.SQLException
Retrieves the value of a JDBC BLOB parameter as a Blob object in the Java programming language.
parameterName
- the name of the parameter java.sql.SQLException
- if a database access error occurs getBoolean
- boolean getBoolean(int parameterIndex)
- throws java.sql.SQLException
Retrieves the value of the designated JDBC BIT parameter as a boolean in the Java programming language.
parameterIndex
- the first parameter is 1, the second is 2, and so on java.sql.SQLException
- if a database access error occurs getBoolean
- boolean getBoolean(java.lang.String parameterName)
- throws java.sql.SQLException
Retrieves the value of a JDBC BIT parameter as a boolean in the Java programming language.
parameterName
- the name of the parameter java.sql.SQLException
- if a database access error occurs getByte
- byte getByte(int parameterIndex)
- throws java.sql.SQLException
Retrieves the value of the designated JDBC TINYINT parameter as a byte in the Java programming language.
parameterIndex
- the first parameter is 1, the second is 2, and so on java.sql.SQLException
- if a database access error occurs getByte
- byte getByte(java.lang.String parameterName)
- throws java.sql.SQLException
Retrieves the value of a JDBC TINYINT parameter as a byte in the Java programming language.
parameterName
- the name of the parameter java.sql.SQLException
- if a database access error occurs getBytes
- byte[] getBytes(int parameterIndex)
- throws java.sql.SQLException
Retrieves the value of the designated JDBC BINARY or VARBINARY parameter as an array of byte values in the Java programming language.
parameterIndex
- the first parameter is 1, the second is 2, and so on java.sql.SQLException
- if a database access error occurs getBytes
- byte[] getBytes(java.lang.String parameterName)
- throws java.sql.SQLException
Retrieves the value of a JDBC BINARY or VARBINARY parameter as an array of byte values in the Java programming language.
parameterName
- the name of the parameter java.sql.SQLException
- if a database access error occurs getClob
- java.sql.Clob getClob(int i)
- throws java.sql.SQLException
Retrieves the value of the designated JDBC CLOB parameter as a Clob object in the Java programming language.
i
- the first parameter is 1, the second is 2, and so on java.sql.SQLException
- if a database access error occurs getClob
- java.sql.Clob getClob(java.lang.String parameterName)
- throws java.sql.SQLException
Retrieves the value of a JDBC CLOB parameter as a Clob object in the Java programming language.
parameterName
- the name of the parameter java.sql.SQLException
- if a database access error occurs getDate
- java.sql.Date getDate(int parameterIndex)
- throws java.sql.SQLException
Retrieves the value of the designated JDBC DATE parameter as a java.sql.Date object.
parameterIndex
- the first parameter is 1, the second is 2, and so on java.sql.SQLException
- if a database access error occurs getDate
- java.sql.Date getDate(int parameterIndex,
- java.util.Calendar cal)
- throws java.sql.SQLException
Retrieves the value of the designated JDBC DATE parameter as a java.sql.Date object, using the given Calendar object to construct the date. With a Calendar object, the driver can calculate the date taking into account a custom timezone and locale. If no Calendar object is specified, the driver uses the default timezone and locale.
parameterIndex
- the first parameter is 1, the second is 2, and so on cal
- the Calendar object the driver will use to construct the date java.sql.SQLException
- if a database access error occurs getDate
- java.sql.Date getDate(java.lang.String parameterName)
- throws java.sql.SQLException
Retrieves the value of a JDBC DATE parameter as a java.sql.Date object.
parameterName
- the name of the parameter java.sql.SQLException
- if a database access error occurs getDate
- java.sql.Date getDate(java.lang.String parameterName,
- java.util.Calendar cal)
- throws java.sql.SQLException
Retrieves the value of a JDBC DATE parameter as a java.sql.Date object, using the given Calendar object to construct the date. With a Calendar object, the driver can calculate the date taking into account a custom timezone and locale. If no Calendar object is specified, the driver uses the default timezone and locale.
parameterName
- the name of the parameter cal
- the Calendar object the driver will use to construct the date java.sql.SQLException
- if a database access error occurs getDouble
- double getDouble(int parameterIndex)
- throws java.sql.SQLException
Retrieves the value of the designated JDBC DOUBLE parameter as a double in the Java programming language.
parameterIndex
- the first parameter is 1, the second is 2, and so on java.sql.SQLException
- if a database access error occurs getDouble
- double getDouble(java.lang.String parameterName)
- throws java.sql.SQLException
Retrieves the value of a JDBC DOUBLE parameter as a double in the Java programming language.
parameterName
- the name of the parameter java.sql.SQLException
- if a database access error occurs getFloat
- float getFloat(int parameterIndex)
- throws java.sql.SQLException
Retrieves the value of the designated JDBC FLOAT parameter as a float in the Java programming language.
parameterIndex
- the first parameter is 1, the second is 2, and so on java.sql.SQLException
- if a database access error occurs getFloat
- float getFloat(java.lang.String parameterName)
- throws java.sql.SQLException
Retrieves the value of a JDBC FLOAT parameter as a float in the Java programming language.
parameterName
- the name of the parameter java.sql.SQLException
- if a database access error occurs getInt
- int getInt(int parameterIndex)
- throws java.sql.SQLException
Retrieves the value of the designated JDBC INTEGER parameter as an int in the Java programming language.
parameterIndex
- the first parameter is 1, the second is 2, and so on java.sql.SQLException
- if a database access error occurs getInt
- int getInt(java.lang.String parameterName)
- throws java.sql.SQLException
Retrieves the value of a JDBC INTEGER parameter as an int in the Java programming language.
parameterName
- the name of the parameter java.sql.SQLException
- if a database access error occurs getLong
- long getLong(int parameterIndex)
- throws java.sql.SQLException
Retrieves the value of the designated JDBC BIGINT parameter as a long in the Java programming language.
parameterIndex
- the first parameter is 1, the second is 2, and so on java.sql.SQLException
- if a database access error occurs getLong
- long getLong(java.lang.String parameterName)
- throws java.sql.SQLException
Retrieves the value of a JDBC BIGINT parameter as a long in the Java programming language.
parameterName
- the name of the parameter java.sql.SQLException
- if a database access error occurs getObject
- java.lang.Object getObject(int parameterIndex)
- throws java.sql.SQLException
Retrieves the value of the designated parameter as an Object in the Java programming language. If the value is an SQL NULL, the driver returns a Java null.
This method returns a Java object whose type corresponds to the JDBC type that was registered for this parameter using the method registerOutParameter. By registering the target JDBC type as java.sql.Types.OTHER, this method can be used to read database-specific abstract data types.
parameterIndex
- the first parameter is 1, the second is 2, and so on java.sql.SQLException
- if a database access error occurs getObject
- java.lang.Object getObject(int i,
- java.util.Map map)
- throws java.sql.SQLException
Returns an object representing the value of OUT parameter i and uses map 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 method registerOutParameter. By registering the target JDBC type as java.sql.Types.OTHER, this method can be used to read database-specific abstract data types.
i
- the first parameter is 1, the second is 2, and so on map
- the mapping from SQL type names to Java classes java.sql.SQLException
- if a database access error occurs getObject
- java.lang.Object getObject(java.lang.String parameterName)
- throws java.sql.SQLException
Retrieves the value of a parameter as an Object in the Java programming language. If the value is an SQL NULL, the driver returns a Java null.
This method returns a Java object whose type corresponds to the JDBC type that was registered for this parameter using the method registerOutParameter. By registering the target JDBC type as java.sql.Types.OTHER, this method can be used to read database-specific abstract data types.
parameterName
- the name of the parameter java.sql.SQLException
- if a database access error occurs getObject
- java.lang.Object getObject(java.lang.String parameterName,
- java.util.Map map)
- throws java.sql.SQLException
Returns an object representing the value of OUT parameter i and uses map 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 method registerOutParameter. By registering the target JDBC type as java.sql.Types.OTHER, this method can be used to read database-specific abstract data types.
parameterName
- the name of the parameter map
- the mapping from SQL type names to Java classes java.sql.SQLException
- if a database access error occurs getRef
- java.sql.Ref getRef(int i)
- throws java.sql.SQLException
Retrieves the value of the designated JDBC REF(
i
- the first parameter is 1, the second is 2, and so on java.sql.SQLException
- if a database access error occurs getRef
- java.sql.Ref getRef(java.lang.String parameterName)
- throws java.sql.SQLException
Retrieves the value of a JDBC REF(
parameterName
- the name of the parameter java.sql.SQLException
- if a database access error occurs getShort
- short getShort(int parameterIndex)
- throws java.sql.SQLException
Retrieves the value of the designated JDBC SMALLINT parameter as a short in the Java programming language.
parameterIndex
- the first parameter is 1, the second is 2, and so on java.sql.SQLException
- if a database access error occurs getShort
- short getShort(java.lang.String parameterName)
- throws java.sql.SQLException
Retrieves the value of a JDBC SMALLINT parameter as a short in the Java programming language.
parameterName
- the name of the parameter java.sql.SQLException
- if a database access error occurs getString
- java.lang.String getString(int parameterIndex)
- throws java.sql.SQLException
Retrieves the value of the designated JDBC CHAR, VARCHAR, or LONGVARCHAR parameter as a String in the Java programming language.
For the fixed-length type JDBC CHAR, the String object returned has exactly the same value the JDBC CHAR value had in the database, including any padding added by the database.
parameterIndex
- the first parameter is 1, the second is 2, and so on java.sql.SQLException
- if a database access error occurs getString
- java.lang.String getString(java.lang.String parameterName)
- throws java.sql.SQLException
Retrieves the value of a JDBC CHAR, VARCHAR, or LONGVARCHAR parameter as a String in the Java programming language.
For the fixed-length type JDBC CHAR, the String object returned has exactly the same value the JDBC CHAR value had in the database, including any padding added by the database.
parameterName
- - the name of the parameter java.sql.SQLException
- if a database access error occurs getTime
- java.sql.Time getTime(int parameterIndex)
- throws java.sql.SQLException
Retrieves the value of the designated JDBC TIME parameter as a java.sql.Time object.
parameterIndex
- the first parameter is 1, the second is 2, and so on java.sql.SQLException
- if a database access error occurs getTime
- java.sql.Time getTime(int parameterIndex,
- java.util.Calendar cal)
- throws java.sql.SQLException
Retrieves the value of the designated JDBC TIME parameter as a java.sql.Time object, using the given Calendar object to construct the time. With a Calendar object, the driver can calculate the time taking into account a custom timezone and locale. If no Calendar object is specified, the driver uses the default timezone and locale.
parameterIndex
- the first parameter is 1, the second is 2, and so on cal
- the Calendar object the driver will use to construct the time java.sql.SQLException
- if a database access error occurs getTime
- java.sql.Time getTime(java.lang.String parameterName)
- throws java.sql.SQLException
Retrieves the value of a JDBC TIME parameter as a java.sql.Time object.
parameterName
- the name of the parameter java.sql.SQLException
- if a database access error occurs getTime
- java.sql.Time getTime(java.lang.String parameterName,
- java.util.Calendar cal)
- throws java.sql.SQLException
Retrieves the value of a JDBC TIME parameter as a java.sql.Time object, using the given Calendar object to construct the time. With a Calendar object, the driver can calculate the time taking into account a custom timezone and locale. If no Calendar object is specified, the driver uses the default timezone and locale.
parameterName
- the name of the parameter cal
- the Calendar object the driver will use to construct the time java.sql.SQLException
- - if a database access error occurs getTimestamp
- java.sql.Timestamp getTimestamp( int parameterIndex)
- throws java.sql.SQLException
Retrieves the value of the designated JDBC TIMESTAMP parameter as a java.sql.Timestamp object.
parameterIndex
- the first parameter is 1, the second is 2, and so on java.sql.SQLException
- if a database access error occurs getTimestamp
- java.sql.Timestamp getTimestamp( int parameterIndex,
- java.util.Calendar cal)
- throws java.sql.SQLException
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. With a Calendar object, the driver can calculate the timestamp taking into account a custom timezone and locale. If no Calendar object is specified, the driver uses the default timezone and locale.
parameterIndex
- the first parameter is 1, the second is 2, and so on cal
- the Calendar object the driver will use to construct the timestamp java.sql.SQLException
- if a database access error occurs getTimestamp
- java.sql.Timestamp getTimestamp( java.lang.String parameterName)
- throws java.sql.SQLException
Retrieves the value of the designated JDBC TIMESTAMP parameter as a java.sql.Timestamp object.
parameterName
- the name of the parameter java.sql.SQLException
- if a database access error occurs getTimestamp
- java.sql.Timestamp getTimestamp( java.lang.String parameterName,
- java.util.Calendar cal)
- throws java.sql.SQLException
Retrieves the value of a JDBC TIMESTAMP parameter as a java.sql.Timestamp object, using the given Calendar object to construct the Timestamp object. With a Calendar object, the driver can calculate the timestamp taking into account a custom timezone and locale. If no Calendar object is specified, the driver uses the default timezone and locale.
cal
- the Calendar object the driver will use to construct the timestamp java.sql.SQLException
- if a database access error occurs getURL
- java.net.URL getURL(int parameterIndex)
- throws java.sql.SQLException
Retrieves the value of the designated JDBC DATALINK parameter as a java.net.URL object.
parameterIndex
- the first parameter is 1, the second is 2,... java.sql.SQLException
- if a database access error occurs, or if the URL being
returned is not a valid URL on the Java platform getURL
- java.net.URL getURL(java.lang.String parameterName)
- throws java.sql.SQLException
Retrieves the value of a JDBC DATALINK parameter as a java.net.URL object.
parameterName
- the name of the parameter java.sql.SQLException
- if a database access error occurs, or if there is a problem
with the URL wasNull
- boolean wasNull()
- throws java.sql.SQLException
Retrieves whether the last OUT parameter read had the value of SQL NULL. Note that this method should be called only after calling a getter method; otherwise, there is no value to use in determining whether it is null or not.
java.sql.SQLException
- if a database access error occurs
Retrieves the current result as a ResultSet object. This method should be called only once per result.