To obtain a connection using JSR 169, use the
org.apache.derby.jdbc.EmbeddedSimpleDataSource class.
This class is identical in implementation to the org.apache.derby.jdbc.EmbeddedDataSource class.
See the for information
on using the properties of the org.apache.derby.jdbc.EmbeddedDataSource class.
JSR 169 and its
implementation have the following limitations:
- Applications must get and set DECIMAL values using alternate
JDBC getXXX and setXXX methods, such as getString() and setString().
Any alternate method that works against a DECIMAL type with JDBC 3.0
will work in JSR 169.
- The XML data type is not supported, but an application can retrieve, update,
query, or otherwise access an XML data value if it has classes for a JAXP parser
and for Xalan in the classpath.
issues an error if
either the parser or Xalan is not found)
JSR 169 and its
implementation do not support the following:
- Java functions and procedures that use server-side JDBC, that is, routines
declared with CONTAINS SQL, READS SQL DATA,
or MODIFIES SQL DATA clauses
- The DriverManager interface (this means that you cannot use
the DriverManager.getConnection method to obtain
a connection but must use the
org.apache.derby.jdbc.EmbeddedSimpleDataSource class instead)
- The standard URL used to obtain a connection,
jdbc:default:connection (a runtime error may occur if the
routine tries to obtain a connection using
jdbc:default:connection)
- Diagnostic tables
- Triggers
- Encrypted databases
- Non-blocking I/O
- Java EE resource manager support, including distributed transactions
- Principal-based security
- LDAP-based authentication
- SSL/TLS encryption
- Replication