If you downloaded the SQLite Admin AIR application I posted on Tuesday, make sure you download the last version. The new version fixes a problem where you get the following exception: ‘Error #3115: SQL Error.’, details:’cannot rollback – no transaction is active’, operation:’rollback’. Many thanks to Barry Beattie for reporting the problem.

Follow @ccoenraets

Updated on Feb 8th 2008: If you downloaded this application before this date, make sure you download the new version (AIR file + source code) for the latest bug fixes.

I’m in the process of updating some of the applications I wrote for earlier versions of Flex and AIR. Here is a new version of my AIR-based SQLite Admin application updated for Beta 3. You can use this application to examine the structure of a database, create a new database or open an existing one, execute any type of SQL statement, etc.

An interesting aspect of this new version is that the application itself uses a database (sqladmincache.db) to keep track of the databases you opened and the statements you executed. This is useful if you want to quickly re-open a recently accessed database, or re-execute a recently executed statement.

This version uses synchronous database operations, and uses the schema API to show you the list of tables and columns available in your database.

The UI is still simple, but uses some new AIR and Flex 3 features such as the AdvancedDataGrid and Native Windows.

Click here to install the application.

Click here to download the source code.

Follow @ccoenraets

Last Friday, we posted the BlazeDS Release Candidate on Labs.

If you missed the beta announcement in December, Adobe is open sourcing its Remoting and Messaging technologies (previously available as part of LiveCycle Data Services) under a new open source product named BlazeDS.

Compared to the Beta version, the Release Candidate includes bug fixes, and two new simple sample applications I wrote to make it easier to get started with BlazeDS:

Trader Desktop

With the addition of the new HTTP Streaming channel, BlazeDS now offers several options for building real time applications (HTTP Streaming, polling, long polling). In this new sample application, you can switch between channels in the running application, and experience the performance and latency characteristics of each type of channel. The application also demonstrates how to use the Channel and ChannelSet classes to specify which channel you want to use at the client side (as opposed to relying on the channel configuration from messaging-config.xml that is built into the SWF at compile time).

Inventory Management

The beta version was lacking a straightforward sample showing how to use Remoting to build a CRUD application. The inventory management is a simple database maintenance application that allows you to manage the product inventory in the sample database . The persistence layer is provided by a simple Java service that exposes CRUD methods (create(), update, delete()) that the Flex application can invoke remotely. In this application I reused the skin created for the Salesbuilder AIR app, and applied it to an application running inside a browser.

Download the BlazeDS Release Candidate here.

Follow @ccoenraets