Step 3 - Get to know the existing sample HSQLDB database

Once you have started your Livecycle Data Services (LCDS) and HSQLDB database agent (more here), you can explore the two Flex applications contected to the product sample database. Open the following in two different browser windows, do some changes in the Admin page, and see the changes imidiately in the shop.

• The admin page: http://localhost:8400/lcds-samples/sqlassembler/index_inv.html
• The shop: http://localhost:8400/lcds-samples/sqlassembler/index_store.html

The database, HSQLDB, is a built-in, mature open source database engine.

Our sample

...uses only one table, 'PRODUCT'. This table and all other data, table definitions, user rigts etc of the database, are simply defined in a text file:

C:\Adobe_lcds\sampledb\flexdemodb\flexdemodb.script.

This file contains the product data well as date for the Employee and Cencus applications. Therefore there will be more data than what you rcognise, right away. Don't worry about it. Just consentrate about the lines containing 'PRODUCT'.

Altering the database

You can add your own tables, rows, users just by editing the text file, and restert the database agent.

Add 'CREATE TABLE' statements for your own tables, and 'INSERT INTO's for your data. Just follow the concept as the existing tables use.

In flexdemo.script you can also change the SA password, but don't do that unless you also changes the password in your LCDS!

Database setup

The HSQLDB that comes with LCDS is set up with two databases: FlexDemoDB and SalesBuilderDB. This is configured in: C:\Adobe_lcds\sampledb\server.properties.

Change to server.silent=false and server.trace=true if you need more debugging info.

[Main article] [Next] [Previous]