vFabric SQLFire 1.0 Release Notes

vFabric SQLFire 1.0.1 | 24 JAN 2012
vFabric SQLFire 1.0.0 | 14 DEC 2011

Last Document Update: 24 JAN 2012

What's in the Release Notes

Note: To upgrade from vFabric SQLFire 1.0.0 to the current version, see Installing or Upgrading vFabric SQLFire.

The release notes cover the following topics:

What's New in SQLFire 1.0.1

The 1.0.1 release of vFabric SQLFire includes the following changes and enhancements:

Basic Features of SQLFire 1.0.0

VMware® vFabric™ SQLFire is a memory-optimized, distributed database management system designed for applications that have demanding scalability and availability requirements. Applications can manage database tables entirely in memory, or they can overflow table data from memory to disk. A SQLFire distributed system can be easily scaled out using commodity hardware.

SQLFire provides the following basic features:

See the SQLFire User's Guide for more information.

Changes for SQLFire 1.0 Beta Participants

This section highlights some of the key changes made to the SQLFire product since the Beta release.

  • gemfire.jar not required in classpath

    The sqlfire.jar file now incorporates all of the classes that are necessary from the vFabric GemFire core engine. The gemfire.jar file is no longer required in the CLASSPATH for SQLFire members or client applications.

  • JAR file installation

    You can now install JAR file classes directly into a SQLFire system using either the install_jar procedure or the SYS.JARS table.

  • User-defined type support

    A user-defined type is a serializable Java class whose instances are stored in columns. User-defined functions can be defined on columns of user-defined types. You can also use these types can as argument types for stored procedures. User-defined types are managed using the CREATE TYPE and DROP TYPE statements.

  • Improved performance

    SQLFire includes many performance enhancements, including an enhanced query optimizer tha makes better use of indexes, batching support from thin clients, and faster execution for unprepared queries.

  • Reduced memory footprint for table and index data

Resolved Issues

Issues Resolved in 1.0.1

For information about published issues that were resolved in the VMware bug tracking system, see BugsFixedSQLFire101.html.

Known Issues

This section highlights certain known issues in vFabric SQLFire and its supported platforms. See BugNotesSQLFire10.html for issues that have been registered as bugs in the VMWare bug tracking system.

vFabric License Server Limitation

If you are installing SQLFire in a vSphere virtual machine as part of the vFabric Cloud Application Platform, you can either use the vFabric License Server to install your SQLFire licenses, or you can install the licenses locally within the SQLFire installation. However, you cannot use the vFabric License Server to manage licenses on physical machines, or with standalone SQLFire licenses such as vFabric SQLFire Enterprise.

See vFabric SQLFire Licensing.