|
CallableStatement Method
|
Version
Introduced
|
Supported
|
Comments
|
|
Array getArray (int)
|
2.0 Core
|
No
|
Throws “unsupported method” exception.
|
|
Array getArray (String)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
Reader getCharacterStream(int)
|
4.0
|
Yes
|
|
|
Reader getCharacterStream(String)
|
4.0
|
No
|
Throws “unsupported method” exception.
|
|
BigDecimal getBigDecimal (int)
|
2.0 Core
|
Yes
|
|
|
BigDecimal getBigDecimal (int, int)
|
1.0
|
Yes
|
|
|
BigDecimal getBigDecimal (String)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
Blob getBlob (int)
|
2.0 Core
|
Yes
|
Not supported on servers which emulate this functionality over LONGVARBINARY.
|
|
Blob getBlob (String)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
boolean execute ()
|
1.0
|
Yes
|
|
|
boolean execute (String)
|
1.0
|
No
|
Throws “invalid method call” exception.
|
|
boolean execute (String, int)
|
3.0
|
No
|
Throws “invalid method call” exception.
|
|
boolean execute (String, int[])
|
3.0
|
No
|
Throws “invalid method call” exception.
|
|
boolean execute (String, String[])
|
3.0
|
No
|
Throws “invalid method call” exception.
|
|
boolean getBoolean (int)
|
1.0
|
Yes
|
|
|
boolean getBoolean (String)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
boolean getMoreResults ()
|
1.0
|
Yes
|
|
|
boolean getMoreResults (int)
|
3.0
|
Yes
|
|
|
boolean wasNull ()
|
1.0
|
Yes
|
|
|
byte [] getBytes (int)
|
1.0
|
Yes
|
|
|
byte [] getBytes (String)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
byte getByte (int)
|
1.0
|
Yes
|
|
|
byte getByte (String)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
Clob getClob (int)
|
2.0 Core
|
Yes
|
Not supported on servers that emulate this functionality over LONGVARCHAR.
|
|
Clob getClob (String)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
Connection getConnection ()
|
2.0 Core
|
Yes
|
|
|
Date getDate (int)
|
1.0
|
Yes
|
|
|
Date getDate (int, Calendar)
|
2.0 Core
|
Yes
|
|
|
Date getDate (String)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
Date getDate (String, Calendar)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
double getDouble (int)
|
1.0
|
Yes
|
|
|
double getDouble (String)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
float getFloat (int)
|
1.0
|
Yes
|
|
|
float getFloat (String)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
int [] executeBatch ()
|
2.0 Core
|
Yes
|
|
|
int executeUpdate ()
|
1.0
|
Yes
|
|
|
int executeUpdate (String)
|
1.0
|
No
|
Throws “invalid method call” exception.
|
|
int executeUpdate (String, int)
|
3.0
|
No
|
Throws “invalid method call” exception.
|
|
int executeUpdate (String, int[])
|
3.0
|
No
|
Throws “invalid method call” exception.
|
|
int executeUpdate (String, String[])
|
3.0
|
No
|
Throws “invalid method call” exception.
|
|
int getFetchDirection ()
|
2.0 Core
|
Yes
|
|
|
int getFetchSize ()
|
2.0 Core
|
Yes
|
|
|
int getInt (int)
|
1.0
|
Yes
|
|
|
int getInt (String)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
int getMaxFieldSize ()
|
1.0
|
Yes
|
|
|
int getMaxRows ()
|
1.0
|
Yes
|
|
|
int getQueryTimeout ()
|
1.0
|
Yes
|
Set the DataSourceQueryTimeOut service attribute to a value greater than 0.
|
|
int getResultSetConcurrency ()
|
2.0 Core
|
Yes
|
|
|
int getResultSetHoldability ()
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
int getResultSetType ()
|
2.0 Core
|
Yes
|
|
|
int getUpdateCount ()
|
1.0
|
Yes
|
|
|
long getLong (int)
|
1.0
|
Yes
|
|
|
long getLong (String)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
Reader getNCharacterStream(int)
|
4.0
|
Yes
|
|
|
Reader getNCharacterStream(String)
|
4.0
|
No
|
Throws “unsupported method” exception.
|
|
NClob getNClob(int)
|
4.0
|
Yes
|
|
|
NClob getNClob(String)
|
4.0
|
No
|
Throws “unsupported method” exception.
|
|
String getNString(int)
|
4.0
|
Yes
|
|
|
String getNString(String)
|
4.0
|
No
|
Throws “unsupported method” exception.
|
|
Object getObject (int)
|
1.0
|
Yes
|
|
|
Object getObject (int, Map)
|
2.0 Core
|
Yes
|
Map ignored.
|
|
Object getObject (String)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
Object getObject (String, Map)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
ParameterMetaData getParameterMetaData()
|
3.0
|
Yes
|
|
|
Ref getRef (int)
|
2.0 Core
|
No
|
Throws “unsupported method” exception.
|
|
Ref getRef (String)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
ResultSet executeQuery ()
|
1.0
|
Yes
|
|
|
ResultSet executeQuery (String)
|
1.0
|
No
|
Throws “invalid method call” exception.
|
|
ResultSet getGeneratedKeys()
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
ResultSet getResultSet ()
|
1.0
|
Yes
|
|
|
ResultSetMetaData getMetaData ()
|
2.0 Core
|
Yes
|
|
|
short getShort (int)
|
1.0
|
Yes
|
|
|
short getShort (String)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
SQLWarning getWarnings ()
|
1.0
|
Yes
|
|
|
SQLXML getSQLXML(int)
|
4.0
|
Yes
|
|
|
SQLXML getSQLXML(String)
|
4.0
|
No
|
Throws “unsupported method” exception.
|
|
String getString (int)
|
1.0
|
Yes
|
|
|
String getString (String)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
Time getTime (int)
|
1.0
|
Yes
|
|
|
Time getTime (int, Calendar)
|
2.0 Core
|
Yes
|
|
|
Time getTime (String)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
Time getTime (String, Calendar)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
Timestamp getTimestamp (int)
|
1.0
|
Yes
|
|
|
Timestamp getTimestamp (int, Calendar)
|
2.0 Core
|
Yes
|
|
|
Timestamp getTimestamp (String)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
Timestamp getTimestamp (String, Calendar)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
URL getURL (int)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
URL getURL (String)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
boolean isWrapperFor(Class<?> iface)
|
4.0
|
Yes
|
|
|
void addBatch ()
|
2.0 Core
|
Yes
|
|
|
void addBatch (String)
|
2.0 Core
|
No
|
Throws “invalid method call” exception.
|
|
void cancel ()
|
1.0
|
Yes
|
Cancel can be used to cancel a function running synchronously on a statement, using a different thread. Whether Cancel will actually cancel the running function depends on the data store.
|
|
void clearBatch ()
|
2.0 Core
|
Yes
|
|
|
void clearParameters ()
|
1.0
|
Yes
|
|
|
void clearWarnings ()
|
1.0
|
Yes
|
|
|
void close ()
|
1.0
|
Yes
|
|
|
void registerOutParameter (int, int)
|
1.0
|
Yes
|
This method should only be used against data stores supporting output or input-output parameters.
|
|
void registerOutParameter (int, int, int)
|
1.0
|
Yes
|
This method should only be used against data stores supporting output or input-output parameters.
|
|
void registerOutParameter (int, int, String)
|
2.0 Core
|
Yes
|
String/typename ignored. This method should only be used against data stores supporting output or input-output parameters.
|
|
void registerOutParameter (String, int)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
void registerOutParameter (String, int, int)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
void registerOutParameter (String, int, String)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
void setArray (int, Array)
|
2.0 Core
|
No
|
Throws “unsupported method” exception.
|
|
void setAsciiStream(String, InputStream)
|
4.0
|
No
|
Throws “unsupported method” exception.
|
|
void setAsciiStream (int, InputStream, int)
|
1.0
|
Yes
|
|
|
void setAsciiStream (String, InputStream, int)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
void setAsciiStream(String, InputStream, long)
|
4.0
|
No
|
Throws “unsupported method” exception.
|
|
void setBigDecimal (int, BigDecimal)
|
1.0
|
Yes
|
|
|
void setBigDecimal (String, BigDecimal)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
void setBinaryStream(String, InputStream)
|
4.0
|
No
|
Throws “unsupported method” exception.
|
|
void setBinaryStream (int, InputStream, int)
|
1.0
|
Yes
|
|
|
void setBinaryStream (String, InputStream, int)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
void setBinaryStream(String, InputStream)
|
4.0
|
No
|
Throws “unsupported method” exception.
|
|
void setBlob(String, Blob)
|
4.0
|
No
|
Throws “unsupported method” exception.
|
|
void setBlob(String, InputStream)
|
4.0
|
No
|
Throws “unsupported method” exception.
|
|
void setBlob(String, InputStream, long)
|
4.0
|
No
|
Throws “unsupported method” exception.
|
|
void setBlob (int, Blob)
|
2.0 Core
|
Yes
|
|
|
void setBoolean (int, boolean)
|
1.0
|
Yes
|
|
|
void setBoolean (String, boolean)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
void setByte (int, byte)
|
1.0
|
Yes
|
|
|
void setByte (String, byte)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
void setBytes (int, byte [])
|
1.0
|
Yes
|
|
|
void setBytes (String, byte [])
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
void setCharacterStream (int, Reader, int)
|
2.0 Core
|
Yes
|
|
|
void setCharacterStream (String, Reader, int)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
void setCharacterStream(String, InputStream, long)
|
4.0
|
No
|
Throws “unsupported method” exception.
|
|
void setClob(String, Clob)
|
4.0
|
No
|
Throws “unsupported method” exception.
|
|
void setClob(String, Reader)
|
4.0
|
No
|
Throws “unsupported method” exception.
|
|
void setClob(String, Reader, long)
|
4.0
|
No
|
Throws “unsupported method” exception.
|
|
void setClob (int, Clob)
|
2.0 Core
|
Yes
|
|
|
void setCursorName (String)
|
1.0
|
No
|
Throws “unsupported method” exception.
|
|
void setDate (int, Date)
|
1.0
|
Yes
|
|
|
void setDate (int, Date, Calendar)
|
2.0 Core
|
Yes
|
|
|
void setDate (String, Date)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
void setDate (String, Date, Calendar)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
void setDouble (int, double)
|
1.0
|
Yes
|
|
|
void setDouble (String, double)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
void setEscapeProcessing (boolean)
|
1.0
|
Yes
|
|
|
void setFetchDirection (int)
|
2.0 Core
|
Yes
|
OpenAccess SDK supports this method, but will ignore this hint provided by the application.
|
|
void setFetchSize (int)
|
2.0 Core
|
Yes
|
OpenAccess SDK supports this method, but will ignore this hint provided by the application.
|
|
void setFloat (int, float)
|
1.0
|
Yes
|
|
|
void setFloat (String, float)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
void setInt (int, int)
|
1.0
|
Yes
|
|
|
void setInt (String, int)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
void setLong (int, long)
|
1.0
|
Yes
|
|
|
void setLong (String, long)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
void setMaxFieldSize (int)
|
1.0
|
Yes
|
|
|
void setMaxRows (int)
|
1.0
|
Yes
|
|
|
void setNCharacterStream(String, Reader, long)
|
4.0
|
No
|
Throws “unsupported method” exception.
|
|
void setNClob(String, NClob)
|
4.0
|
No
|
Throws “unsupported method” exception.
|
|
void setNClob(String, Reader)
|
4.0
|
No
|
Throws “unsupported method” exception.
|
|
void setNClob(String, Reader, long)
|
4.0
|
No
|
Throws “unsupported method” exception.
|
|
void setNString(String, String)
|
4.0
|
No
|
Throws “unsupported method” exception.
|
|
void setNull (int, int)
|
1.0
|
Yes
|
|
|
void setNull (int, int, String)
|
2.0 Core
|
Yes
|
OpenAccess SDK does not support the Advanced Data Type functionality. This method is always mapped to setNull (i, sqlType).
|
|
void setNull (String, int)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
void setNull (String, int, String)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
void setObject (int, Object)
|
1.0
|
Yes
|
|
|
void setObject (int, Object, int)
|
1.0
|
Yes
|
|
|
void setObject (int, Object, int, int)
|
1.0
|
Yes
|
|
|
void setObject (String, Object)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
void setObject (String, Object, int)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
void setObject (String, Object, int, int)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
void setQueryTimeout (int)
|
1.0
|
Yes
|
Set the DataSourceQueryTimeOut service attribute to a value greater than 0. Refer to the OpenAccess SDK Administrator’s Guide.
|
|
void setRef (int, Ref)
|
2.0 Core
|
No
|
Throws “unsupported method” exception.
|
|
void setShort (int, short)
|
1.0
|
Yes
|
|
|
void setShort (String, short)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
void setSQLXML(String, SQLXML)
|
4.0
|
No
|
Throws “unsupported method” exception.
|
|
void setString (int, String)
|
1.0
|
Yes
|
|
|
void setString (String, String)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
void setTime (int, Time)
|
1.0
|
Yes
|
|
|
void setTime (int, Time, Calendar)
|
2.0 Core
|
Yes
|
|
|
void setTime (String, Time)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
void setTime (String, Time, Calendar)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
void setTimestamp (int, Timestamp)
|
1.0
|
Yes
|
|
|
void setTimestamp (int, Timestamp, Calendar)
|
2.0 Core
|
Yes
|
|
|
void setTimestamp (String, Timestamp)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
void setTimestamp (String, Timestamp, Calendar)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
void setUnicodeStream (int, InputStream, int)
|
1.0
|
Yes
|
Supported by OpenAccess SDK. This method has been deprecated in the JDBC 2.0 specification.
|
|
<T> T unwrap(Class<T> iface)
|
4.0
|
Yes
|
|
|
void setURL (int, URL)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
void setURL (String, URL)
|
3.0
|
No
|
Throws “unsupported method” exception.
|