Completing Phonebook Prerequisites
- Procedure
- In TIBCO Business Studio - BPM Edition, 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 - BPM Edition cheat sheet, or from
phonebook.zip
extract jv.phonebook.soa/Deployment Artifacts/jv.phonebook.soa.daa. - Download HyperSQL Database Engine version 1.8.1.2 from http://sourceforge.net/.
- In TIBCO Silver Center:
- Upload hsqldb-1.8.1.2.zip to /root.
- 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.
- Unpack hsqldb-1.8.1.2.zip.
- Change to the server directory: cd hsqldb/bin.
- 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