skip to main content
JDBC support : PreparedStatement
  

Try DataDirect Drivers Now

PreparedStatement

PreparedStatement Methods
Version Introduced
Supported
Comments
void addBatch()
2.0 Core
Yes
 
void clearParameters()
1.0
Yes
 
boolean execute()
1.0
Yes
 
ResultSet executeQuery()
1.0
Yes
 
int executeUpdate()
1.0
Yes
 
ResultSetMetaData getMetaData()
2.0 Core
Yes
 
ParameterMetaData getParameterMetaData()
3.0
Yes
 
boolean isWrapperFor(Class<?> iface)
4.0
Yes
void setArray(int, Array)
2.0 Core
Yes
Supported for the Oracle driver only.
All other drivers throw an "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
When used with Blobs, the DB2 driver only supports with DB2 V8.x and higher for Linux/UNIX/Windows, DB2 for z/OS (all versions), and DB2 for i.
void setBinaryStream(int, InputStream, int)
1.0
Yes
When used with Blobs, the DB2 driver only supports with DB2 V8.x and higher for Linux/UNIX/Windows, DB2 for z/OS (all versions), and DB2 for i.
void setBinaryStream(int, InputStream, long)
4.0
Yes
When used with Blobs, the DB2 driver only supports with DB2 V8.x and higher for Linux/UNIX/Windows, DB2 for z/OS (all versions), and DB2 for i.
void setBlob(int, Blob)
2.0 Core
Yes
The DB2 driver only supports with DB2 V8.x and higher for Linux/UNIX/Windows, DB2 for z/OS (all versions), and DB2 for i.
All other drivers support using with data types that map to the JDBC LONGVARBINARY data type.
void setBlob(int, InputStream)
4.0
Yes
The DB2 driver only supports with DB2 V8.x and higher for Linux/UNIX/Windows, DB2 for z/OS (all versions), and DB2 for i.
All other drivers support using with data types that map to the JDBC LONGVARBINARY data type.
void setBlob(int, InputStream, long)
4.0
Yes
The DB2 driver only supports with DB2 V8.x and higher for Linux/UNIX/Windows, DB2 for z/OS (all versions), and DB2 for i.
All other drivers support using with data types that map to the JDBC LONGVARBINARY data type.
void setBoolean(int, boolean)
1.0
Yes
 
void setByte(int, byte)
1.0
Yes
 
void setBytes(int, byte [])
1.0
Yes
When used with Blobs, the DB2 driver only supports with DB2 V8.x and higher for Linux/UNIX/Windows, DB2 for z/OS (all versions), and DB2 for i.
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
Drivers support using with data types that map to the JDBC LONGVARBINARY data type.
void setClob(int, Reader)
4.0
Yes
Drivers support using with data types that map to the JDBC LONGVARBINARY data type.
void setClob(int, Reader, long)
4.0
Yes
Drivers support using with data types that map to the JDBC LONGVARBINARY data type.
void setDate(int, Date)
1.0
Yes
 
void setDate(int, Date, Calendar)
2.0 Core
Yes
 
void setDouble(int, double)
1.0
Yes
 
void setFloat(int, float)
1.0
Yes
 
void setInt(int, int)
1.0
Yes
 
void setLong(int, long)
1.0
Yes
 
void setNCharacterStream(int, Reader)
4.0
Yes
For the Autonomous REST Connector and the drivers for Aha!, Apache Cassandra, GitHub, Jira, Microsoft Dynamics 365, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce, N methods are identical to their non-N counterparts.
void setNCharacterStream(int, Reader, long)
4.0
Yes
For the Autonomous REST Connector and the drivers for Aha!, Apache Cassandra, GitHub, Jira, Microsoft Dynamics 365, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce, N methods are identical to their non-N counterparts.
void setNClob(int, NClob)
4.0
Yes
For the Autonomous REST Connector and the drivers for Aha!, Apache Cassandra, GitHub, Jira, Microsoft Dynamics 365, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce, N methods are identical to their non-N counterparts.
void setNClob(int, Reader)
4.0
Yes
For the Autonomous REST Connector and the drivers for Aha!, Apache Cassandra, GitHub, Jira, Microsoft Dynamics 365, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce, N methods are identical to their non-N counterparts.
void setNClob(int, Reader, long)
4.0
Yes
For the Autonomous REST Connector and the drivers for Aha!, Apache Cassandra, GitHub, Jira, Microsoft Dynamics 365, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce, N methods are identical to their non-N counterparts.
void setNull(int, int)
1.0
Yes
 
void setNull(int, int, String)
2.0 Core
Yes
 
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
The DB2 driver supports setting a timeout value, in seconds, for a statement with DB2 V8.x and higher for Linux/UNIX/Windows and DB2 V8.1 and higher for z/OS. If the execution of the statement exceeds the timeout value, the statement is timed out by the database server, and the driver throws an exception indicating that the statement was timed out. The DB2 driver throws an "unsupported method" exception with other DB2 versions.
The Informix driver throws an "unsupported method" exception.
The Autonomous REST Connector and the drivers for Aha!, GitHub, Jira, Microsoft Dynamics 365, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce ignore any value set using this method. Use the WSTimeout connection property to set a timeout value.
The drivers for Apache Cassandra and MongoDB ignore any value set using this method.
All other drivers support setting a timeout value, in seconds, for a statement. If the execution of the statement exceeds the timeout value, the statement is timed out by the database server, and the driver throws an exception indicating that the statement was timed out.
void setRef(int, Ref)
2.0 Core
No
All drivers throw "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
No
This method was deprecated in JDBC 2.0. All drivers throw "unsupported method" exception.
<T> T unwrap(Class<T> iface)
4.0
Yes
void setURL(int, URL)
3.0
No
All drivers throw "unsupported method" exception.