« Data Access Object (DAO) versus Object Relational Mapping (ORM) | Main | Moving to Subversion »

FireStorm/DAO 2.4 GA

FireStorm/DAO 2.4 GA is now available to download:

/products/firestorm/download/

The key new features in FireStorm/DAO 2.4 are:

  • Support for Stored Procedures. In addition to exposing tables, views, and custom SQL statements as Data Access Objects, FireStorm/DAO now exposes Stored Procedures as Data Access Objects, unlocking legacy business logic stored in databases. Initially available for Sybase, Oracle, and SQL Server.
  • Interactive SQL Tool that allows database queries to be tested directly from FireStorm/DAO
  • Database Schema Migration feature that makes it easier to migrate database schemas between different databases. Any SQL data types from the old database not supported by the new target database are automatically changed to the appropriate supported data types.
  • New wizards for importing databases and generating code
  • Improved support for Sybase ASE
  • It is now possible to generate Web Applications using simple JSP
    • pages in addition to generating Web Applications based on Struts and Tiles
  • FireStorm/DAO now uses JDOM 1.0 in place of a proprietary XML
    • parser for reading/writing project files, allowing easier integration for OEM customers.
  • It is now possible to define Table DAO finder methods by defining a full SQL SELECT statement (that can be a multi-table join) instead of just defining the SQL WHERE clause.

In addition, there are numerous extra enhancements, particularly around usability. For example, when defining new columns (or amending existing columns), the usability enhancements include:

  • FireStorm/DAO now provides a combobox for selecting SQL data types rather than a free-form text input, and populates this combobox with the appropriate data types for the selected database platform.
  • The SQL precision and scale fields are now only enabled if a SQL data type is selected that supports precision and/or scale
  • The JDBC type is automatically set based on the SQL data type selected
  • Autofill buttons (represented as small light bulbs next to input fields) are available to set the column's SQL name and SQL type intelligently based on the Java name and Java type.

Product Demonstration Video

A short (6 minute) product demonstration video in Windows Media format is available to view here.

Code Generator

Posted by Andy Grove on March 11, 2005 10:25 AM |

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)