java.sql.Statement interface

Derby does not implement the setEscapeProcessing method of java.sql.Statement. In addition, the cancel method raises a "Feature not supported" exception.

The following table describes features of Statement methods that are specific to Derby.

Table 1. Implementation notes on Statement methods
Returns Signature Implementation Notes
ResultSet getGeneratedKeys() If the user has indicated that auto-generated keys should be made available, this method returns the same results as a call to the IDENTITY_VAL_LOCAL function. Otherwise this method returns null.
boolean execute(String sql, int [] columnIndexes) Every column index in the array must correlate to an auto-increment column within the target table of the INSERT.
boolean execute(String sql, String [] columnNames) Every column name in the array must designate an auto-increment column within the target table of the INSERT.
int executeUpdate(String sql, int [] columnIndexes) Every column index in the array must correlate to an auto-increment column within the target table of the INSERT.
int executeUpdate(String sql, String [] columnNames) Every column name in the array must designate an auto-increment column within the target table of the INSERT.
Related reference
java.sql.Driver interface
java.sql.DriverManager.getConnection method
java.sql.Connection interface
java.sql.DatabaseMetaData interface
java.sql.CallableStatement interface
java.sql.PreparedStatement interface
java.sql.ResultSet interface
java.sql.ResultSetMetaData interface
java.sql.SQLException class
java.sql.SQLWarning class
java.sql.Savepoint interface
Mapping of java.sql.Types to SQL types
JDBC Package for Connected Device Configuration/Foundation Profile (JSR 169)
Features supported on all JDBC 4 releases
Features supported on JDBC 4.1 and above
JDBC 4.2-only features
JDBC escape syntax