CodeFutures Support Blog

The FireStorm/DAO 2.4 Release Candidate has been updated, fixing a number of minor bugs. The interactive SQL tool in particular has several bug fixes.

http://www.codefutures.com/products/firestorm/download/

Posted by Andy Grove at 05:36 PM | Permalink | Comments (0)

FireStorm/DAO 2.4 Release Candidate 1 has been updated. The new build (build 43) has the following improvements over the previous RC1 build:

- Recognizes SQL Server IDENTITY columns when reverse-engineering
- Interactive SQL feature allows queries to be run directly against databases (useful for previewing Custom DAO code)
- Fixes JDBC issue when connecting to Sybase databases

Click here to download

Posted by Andy Grove at 05:39 PM | Permalink | Comments (0)

Apache Derby is a pure Java embedded database. It is based on the IBM Cloudscape database engine, which was donated to the Apache Software Foundation in August 2004. Apache Derby can be downloaded here:

http://incubator.apache.org/derby/index.html

FireStorm/DAO 2.4 RC1 supports Apache Derby. To configure FireStorm/DAO for Apache Derby, set up the JDBC driver as follows:

JDBC Driver Class: org.apache.derby.jdbc.EmbeddedDriver
Classpath: derby.jar

The JDBC connection should be configured as follows:

JDBC URL: jdbc:derby:/path/database
Username and password should be left blank.

Posted by Andy Grove at 10:36 AM | Permalink | Comments (0)

FireStorm/DAO generates a ResourceManager.java source file which is responsible for connecting the database at runtime.

There are two different ResourceManager templates that ship with FireStorm/DAO - once based on JDBC (located in templates/jdbc) and one based on JNDI (located in templates/j2ee).

Both of these templates can be fully customizable. For example, you can modify the JDBC template to use a connection pooling library.

In the 2.4 GA release we will provide a choice of ResourceManager templates, including examples of connection pooling.

Please note that it is often simpler to use a version of your JDBC driver that already supports connection pooling.

Posted by Andy Grove at 09:49 AM | Permalink | Comments (0)

FireStorm/DAO 2.4 Release Candidate 1 is now available to download from:

http://www.codefutures.com/products/firestorm/download/

FireStorm/DAO 2.4 contains numerous usability enhancements, such as new intuitive wizards for importing database schemas and for generating code.

FireStorm/DAO 2.4 RC1 also includes basic support for Stored Procedures for Oracle, SQL Server, and Sybase. FireStorm/DAO will now generate a Stored Procedure DAO class for each Stored Procedure in the database and will allow the stored procedure to be invoked at runtime by calling an 'execute' method on that DAO and passing in the appropriate parameters. This release candidate does not yet allow the result sets returned by the stored procedure to be mapped to a DTO. This additional functionality will be available in the GA release which will be available later this month.

Posted by Andy Grove at 10:58 PM | Permalink | Comments (2)

FireStorm/DAO 2.3 build 218 is now available to download from:

http://www.codefutures.com/products/firestorm/download/

Changes between 2.3 GA and 2.3 build 218:

• Compatibility problem with MySQL Connector/J 3.1.6 resolved
• Option to enable/disable Session Bean code generation now working
• EJB DAO implementation now contains logging code
• Added icons to Options/Drivers/Databases buttons on toolbar
• Struts code generator now supports boolean types
• Enterprise Edition features now correctly enabled when license key installed

Posted by Andy Grove at 09:09 PM | Permalink | Comments (0)