UltraLite User's Guide
  Developing UltraLite Java Applications
    UltraLite API reference

JDBC features in UltraLite

The following are features and limitations specific to the development of JDBC UltraLite applications.

The UltraLite API is modeled on JDBC 1.2, with the addition of the following ResultSet methods from JDBC 2.0:

• absolute( ),

• afterLast( ),

• beforeFirst( ),

• first( ),

• isAfterLast( ),

• isBeforeFirst( ),

• isFirst( ),

• isLast( ),

• last( ),

• previous( ),

• relative( )

The following features are incompatible with the UltraLite development model and are not supported by UltraLite.

• There is only limited support for metadata access (system table access). Therefore, you cannot use the DatabaseMetaData Interface. Metadata access is limited to the number and type of columns.

• Java objects cannot be stored in the database

• There is no support for stored procedures or stored functions.

• Only static SQL statements are supported and they must be added to the database so that the UltraLite generator can generate them.