Wednesday, February 23, 2005, El Cerrito, CA -- FFE Software, Inc. announced immediate availability of the first public beta for FirstSQL/J Enterprise Edition, Version 3.00 and FirstSQL/J Professional Edition, Version 3.00. The Enterprise and Professional Editions are full featured Object/Relational Database Management Systems (ORDBMSs) written in 100% Java for J2ME, J2SE, J2EE. The 3.00 Beta for products can be obtained through our Download Page. The full release of Version 3.00 is projected for late March, 2005.

Version 3.00 includes the following new features:

• Database Triggers -- a trigger is a user-defined Java method attached to a database table. An insert, update or delete operation on the table fires the trigger method. Trigger methods can validate the change, make corrections and other changes, log the change and can cancel the modification. A trigger can fire before or after the change to the table.
• Sequence Keys -- a sequence key is a special primary key maintained by the ORDBMS. When inserting a new row into a table with a sequence key, the system automatically assigns a unique value for the key. Sequence keys are also known as auto-increment or identity keys.
• Constraint Enhancements --
  • CHECK Constraint: a predicate evaluated for each insert/update to validate the change (similar to a trigger but declarative in nature.)
  • Names for Constraints: used to identify the constraint in exception messages and for drop constraint.
  • Adding and Dropping Constraints for an Existing Table -- an extension to ALTER TABLE.
• ODBC Driver for Enterprise Server -- this is an ODBC 3 driver for the server only. The ODBC driver is available separately from the company.
• Additional Features, Cleanups and Bug Fixes -- these are listed in the readme.txt file installed in the doc folder.