Completing Phonebook Prerequisites

Procedure

  1. In TIBCO Business Studio, create a distributed application archive (DAA) by following the instructions in the How to Create and Package the Phonebook Application using the TIBCO Business Studio cheat sheet, or extract jv.phonebook.soa/Deployment Artifacts/jv.phonebook.soa.daa from phonebook.zip.
  2. Download HyperSQL Database Engine version 1.8.1.2 from http://sourceforge.net/.
  3. In TIBCO Silver Center:
    1. Upload hsqldb-1.8.1.2.zip to /root.
    2. Upload jv.hsqldb.jv/feature/hsqldb_build.xml, jv.hsqldb.jv/feature/hsqldb_data.xml, and jv.hsqldb.jv/feature/hsqldb.daa files to /root.
  4. Unpack hsqldb-1.8.1.2.zip.
  5. Change to the server directory: cd hsqldb/bin.
  6. Start the HyperSQL database server: java -cp ../lib/hsqldb.jar org.hsqldb.Server.
    The server outputs: 
    > java -cp ../lib/hsqldb.jar org.hsqldb.Server
[Server@83cc67]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@83cc67]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@83cc67]: Startup sequence initiated from main() method
[Server@83cc67]: Loaded properties from [C:\Documents and Settings\sbodoff\Desktop\hsqldb\hsqldb\bin\server.properties]
[Server@83cc67]: Initiating startup sequence...
[Server@83cc67]: Server socket opened successfully in 78 ms.
[Server@83cc67]: Database [index=0, id=0, db=file:test, alias=] opened sucessfully in 468 ms.
[Server@83cc67]: Startup sequence completed in 546 ms.
[Server@83cc67]: 2010-05-04 14:06:10.923 HSQLDB server 1.8.1 is online
[Server@83cc67]: To close normally, connect and execute SHUTDOWN SQL
[Server@83cc67]: From command line, use [Ctrl]+[C] to abort abruptly