Skip to main content

Lance Andersen

Lance is a Principal Member of Technical Staff at Oracle Corporation. He is also the JDBC specification lead as well as the Java EE technical lead for Java Partner Engineering . Prior to joining Sun in September 2000, Lance worked at Sybase as a senior manager and staff engineer within Product Support Engineering. When he is not burning the midnight oil for Sun, Lance teaches tennis. You can check out his tennis website for more info.


lancea's blog

Java DB provides a great way to try JDBC 4.0 features

Posted by lancea on June 15, 2006 at 10:15 AM PDT

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.

JDBC 4.0 SQLXML Interface

Posted by lancea on May 2, 2006 at 11:09 AM PDT

Since the public draft of the JDBC spec, the JDBC EG has reworked the SQLXML interface completely providing for more flexibility.

JDBC 4.0 RowId Interface

Posted by lancea on March 10, 2006 at 3:32 PM PST

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.

JDBC 4.0 Wrapper Interface

Posted by lancea on February 23, 2006 at 2:46 PM PST

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.

JDBC 4.0 SQLException Enhancements

Posted by lancea on February 21, 2006 at 11:58 AM PST

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 keeps moving forward

Posted by lancea on February 17, 2006 at 9:23 AM PST

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.

Getting Started using Derby with Glassfish and SJSAS 8.2

Posted by lancea on February 7, 2006 at 11:10 AM PST

Glassfish and SJSAS 8.2 introduce two new asadmin commands for starting and stopping the Derby Network Server.

The start-database command may be used to start an instance of the Derby network server:

start-database [––dbhost] [––dbport 1527] [–†   

Exporting Tables from Pointbase to Derby

Posted by lancea on February 6, 2006 at 4:06 PM PST

Brian Leonard has a nice article which shows you how to capture the ddl for a table in pointbase and create the same table in Derby using Netbeans 5.0.

Another option for doing this is by using the commander tool and the 'unload database' command:


New Derby Overview tutorial is available

Posted by lancea on December 9, 2005 at 10:27 AM PST

The new tutorial for Derby, created by Jean Anderson, can be found at "> .

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

JDBC 4.0 Early Draft Review 2 is available

Posted by lancea on October 12, 2005 at 10:31 AM PDT

The latest draft can be downloaded from here.

We look forward to your feedback.