java.sql.Statement interface
Derby Reference Manual
322
· Function metadata - JDBC 4.0 adds new methods for inspecting the arguments
and return types of functions, including user-defined functions. These new methods
are getFunctions and getFunctionColumns. These methods behave similarly to
getProcedures and getProcedureColumns.
· Procedure metadata - The getProcedureColumns method reports additional
information about procedure arguments. For more information, see the
javadoc for this method. The new columns in the ResultSet returned
by getProcedureColumns are: COLUMN_DEF, SQL_DATA_TYPE,
SQL_DATETIME_SUB, CHAR_OCTET_LENGTH, ORDINAL_POSITION,
IS_NULLABLE, and SPECIFIC_NAME.
· Schema metadata - JDBC 4.0 adds a new getSchemas overload, which lets you
look up schemas based on a name pattern.
java.sql.Statement interface: JDBC 4.0 features
Derby's Statements implement the following new metadata methods added by JDBC 4.0.
· Pooling support - JDBC 4.0 adds new methods to help application servers
manage pooled Statements: isPoolable and setPoolable.
· Validity tracking - JDBC 4.0 lets you track the validity of a Statement through the
new isClosed method.
javax.sql.DataSource interface: JDBC 4.0 features
Derby has added new JDBC 4.0-specific DataSources. Use these DataSources if your
application runs on JDK 1.6 or higher.
· org.apache.derby.jdbc.EmbeddedConnectionPoolDataSource40
· org.apache.derby.jdbc.EmbeddedDataSource40
· org.apache.derby.jdbc.EmbeddedXADataSource40
· org.apache.derby.jdbc.ClientConnectionPoolDataSource40
· org.apache.derby.jdbc.ClientDataSource40
· org.apache.derby.jdbc.ClientXADataSource40
java.sql.SQLXML interface
In JDBC 4.0, java.sql.SQLXML is the mapping for the SQL XML data type. However,
Derby defines the XML data type and operators only in the SQL layer. There is no
JDBC-side support for the XML data type and operators
You cannot instantiate a java.sql.SQLXML object in Derby, or bind directly into an XML
value or retrieve an XML value directly from a result set. You must bind and retrieve the
XML data as Java strings or character streams by explicitly specifying the XML operators,
XMLPARSE and XMLSERIALIZE, as part of your SQL queries.
Additionally, Derby does not provide JDBC metatadata support for the XML data type.
JDBC 4.1-only features
JDBC 4.1 adds some functionality to the core API. This section documents the JDBC 4.1
features supported by Derby.
For information on features supported by both JDBC 4.0 and JDBC 4.1, see
.
Note: JDBC 4.1 features are present only in a JDK 7 or higher environment.
java.sql.Connection interface: JDBC 4.1 features
