PreparedStatement Object
- Last Updated: May 12, 2026
- 3 minute read
- OpenAccess SDK
- Version 8.1
- Documentation
| 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 |