Java DB and Apache Derby have been following the progress of the JDBC 4.0 specification very closely and have implemented many of the JDBC 4.0 features in the 10.2 alpha release.
Since the public draft of the JDBC spec, the JDBC EG has reworked the SQLXML interface completely providing for more flexibility.
The RowID interface was added to JDBC 4.0 in order to support the ROWID datatype which is supported by databases such as Oracle and DB2.
The Wrapper interface provides a mechanism for JDBC users to be able to access an instance of a resource which has been wrapped for architectural reasons.
The following enhancements were made in JDBC 4.0 in order to provide a better developer's experience when dealing with SQLExceptions:
- Support for causal relationships
- For-each loop support
- New SQLException sub-classes
Causal Relationship Support
We have added support for the Java SE chained exception mechanism by adding additional constructors allowing for th
JDBC 4.0 has just completed public draft review and the EG is working on closing the last few issues. One of the interfaces that I expect to change signficantly is the SQLXML interface.
The start-database command may be used to start an instance of the Derby network server:
start-database [â€“â€“dbhost 0.0.0.0] [â€“â€“dbport 1527] [â€“â€
Another option for doing this is by using the commander tool and the 'unload database' command:
The new tutorial for Derby, created by Jean Anderson, can be found at
http://db.apache.org/derby/papers/DerbyTut/index.html ">http://db.apache.org/derby/papers/DerbyTut/index.html .
This tutorial will be useful for Glassfish developers as it gives an overview of using Derby in a Network and Embedded mode and also provides info on how to use the ij tool for executing simple SQL qu
The latest draft can be downloaded from here.
We look forward to your feedback.