FirstSQL/J v2.50 Overview
Download the latest release v2.5 from the Download Section.
New In Release 2.50 -
+ Recursive Queries (CONNECT BY) -- the new CONNECT BY construct
supports recursive queries. A recursive query traverses a tree
structure to produce a flat result set.
+ Enterprise Server only - Fault Recovery and Replication Enhancements:
- Increased reliability and bug fixes (see below),
- stay.active startup option for master server, to avoid a
single point of failure for fault recovery situations, and
- Arbiter server for improved control of fault recovery and
+ Rollback Log Improvements -- significantly reduced disk space
requirements for the system rollback log (log00001.log).
+ Capability to Expand the Execution Sandbox for Database
Objects -- the list of built-in packages and classes that are
accessible from database methods can be expanded. The Maint
utilities provide this functionality. This powerful capability
enhances the flexibility and range of FirstSQL/J applications.
Examples from expanding internal methods can include new classes
for communication with external devices, other databases, email,
and storage of XML data.
+ Improved Maint Command-line Utility -- The command-line
utility, Maint, now provides better support for batch
operation, when taking commands from a file.
+ Various Bug fixes.