|
PreparedStatement Method
|
Version
Introduced
|
Supported
|
Comments
|
|
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
|
|
|
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.
|
|
int [] executeBatch ()
|
2.0 Core
|
Yes
|
|
|
ResultSet executeQuery ()
|
1.0
|
Yes
|
|
|
ResultSet executeQuery (String)
|
1.0
|
No
|
Throws “invalid method call” exception.
|
|
int executeUpdate ()
|
1.0
|
Yes
|
|
|
int executeUpdate (String)
|
1.0
|
No
|
Throws “invalid method call” exception.
|
|
int executeUpdate (String, int)
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
int executeUpdate (String, int [])
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
int executeUpdate (String, String [])
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
Connection getConnection ()
|
2.0 Core
|
Yes
|
|
|
int getFetchDirection ()
|
2.0 Core
|
Yes
|
|
|
int getFetchSize ()
|
2.0 Core
|
Yes
|
|
|
ParameterMetaData getParameterMetaData()
|
3.0
|
Yes
|
|
|
boolean isWrapperFor(Class<?> iface)
|
4.0
|
Yes
|
|
|
ResultSet getGeneratedKeys ()
|
3.0
|
No
|
Throws “unsupported method” exception.
|
|
int getMaxFieldSize ()
|
1.0
|
Yes
|
|
|
int getMaxRows ()
|
1.0
|
Yes
|
|
|
ResultSetMetaData getMetaData ()
|
2.0 Core
|
Yes
|
|
|
boolean getMoreResults ()
|
1.0
|
Yes
|
|
|
boolean getMoreResults (int)
|
3.0
|
Yes
|
|
|
int getQueryTimeout ()
|
1.0
|
Yes
|
Set the DataSourceQueryTimeout to a value greater than 0.
|
|
ResultSet getResultSet ()
|
1.0
|
Yes
|
|
|
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
|
|
|
SQLWarning getWarnings ()
|
1.0
|
Yes
|
|
|
void setArray (int, Array)
|
2.0 Core
|
No
|
Throws “unsupported method” exception.
|
|
void setAsciiStream(int, InputStream)
|
4.0
|
Yes
|
|
|
void setAsciiStream (int, InputStream, int)
|
1.0
|
Yes
|
|
|
void setAsciiStream(int, InputStream,
long)
|
4.0
|
Yes
|
|
|
void setBigDecimal (int, BigDecimal)
|
1.0
|
Yes
|
|
|
void setBinaryStream(int, InputStream)
|
4.0
|
Yes
|
|
|
void setBinaryStream (int, InputStream, int)
|
1.0
|
Yes
|
|
|
void setBinaryStream(int, InputStream,
long)
|
4.0
|
Yes
|
|
|
void setBlob (int, Blob)
|
2.0 Core
|
Yes
|
|
|
void setBlob(int, InputStream)
|
4.0
|
Yes
|
|
|
void setBlob(int, InputStream, long)
|
4.0
|
Yes
|
|
|
void setBoolean (int, boolean)
|
1.0
|
Yes
|
|
|
void setByte (int, byte)
|
1.0
|
Yes
|
|
|
void setBytes (int, byte [])
|
1.0
|
Yes
|
|
|
void setCharacterStream(int, Reader)
|
4.0
|
Yes
|
|
|
void setCharacterStream (int, Reader, int)
|
2.0 Core
|
Yes
|
|
|
void setCharacterStream(int, Reader, long)
|
4.0
|
Yes
|
|
|
void setClob (int, Clob)
|
2.0 Core
|
Yes
|
|
|
void setClob(int, Reader)
|
4.0
|
Yes
|
|
|
void setClob(int, Reader, long)
|
4.0
|
Yes
|
|
|
void setCursorName (String)
|
1.0
|
No
|
|
|
void setDate (int, Date)
|
1.0
|
Yes
|
|
|
void setDate (int, Date, Calendar)
|
2.0 Core
|
Yes
|
|
|
void setDouble (int, double)
|
1.0
|
Yes
|
|
|
void setEscapeProcessing (boolean)
|
1.0
|
Yes
|
Ignored.
|
|
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 setInt (int, int)
|
1.0
|
Yes
|
|
|
void setLong (int, long)
|
1.0
|
Yes
|
|
|
void setMaxFieldSize (int)
|
1.0
|
Yes
|
|
|
void setMaxRows (int)
|
1.0
|
Yes
|
|
|
void setNCharacterStream(int, Reader, long)
|
4.0
|
Yes
|
|
|
void setNClob(int, NClob)
|
4.0
|
Yes
|
|
|
void setNClob(int, Reader)
|
4.0
|
Yes
|
|
|
void setNClob(int, Reader, long)
|
4.0
|
Yes
|
|
|
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 setNString(int, String)
|
4.0
|
Yes
|
|
|
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 setQueryTimeout (int)
|
1.0
|
Yes
|
Set the DataSourceQueryTimeout service attribute to a value greater than 0.
|
|
void setRef (int, Ref)
|
2.0 Core
|
No
|
Throws “unsupported method” exception.
|
|
void setShort (int, short)
|
1.0
|
Yes
|
|
|
void setSQLXML(int, SQLXML)
|
4.0
|
Yes
|
|
|
void setString (int, String)
|
1.0
|
Yes
|
|
|
void setTime (int, Time)
|
1.0
|
Yes
|
|
|
void setTime (int, Time, Calendar)
|
2.0 Core
|
Yes
|
|
|
void setTimestamp (int, Timestamp)
|
1.0
|
Yes
|
|
|
void setTimestamp (int, Timestamp, Calendar)
|
2.0 Core
|
Yes
|
|
|
void setUnicodeStream (int, InputStream, int)
|
1.0
|
Yes
|
Throws “unsupported method” exception. This method was 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.
|
|
boolean wasNull ()
|
1.0
|
Yes
|
|