Setting up the database
In order to demonstrate create, restore, update, and delete operations and
true metadata-driven design, the TwineBall server uses an actual database to
define its entities and store its data. This necessitates some
additional setup. Scripts have been provided to make this easier, but
these scripts will require some slight modification to match your
system.
To set up the database, follow these steps.
- Install the WebSphere Business Integration Adapter Framework or WebSphere
InterChange Server and all their pre-requisites.
- Install IBM DB2 Version 8, Fix pack 2.
- Create the following user ids in your operating system:
TwineBall, TwineBallAdapter.
Give them the password
sample42
- Create the Twine database. In the setup/SQL
directory, you'll find Twine-database.bat and
Twine-database.sql.
Edit Twine-database.sql to match your password for the
db2admin id.
- Run the Twine-database.bat script. You should not receive
any error messages. If you do, resolve them before continuing.
- Create the tables needed by the TwineBall server. In the
setup/SQL directory, you'll find TwineBall-Schema.bat
and TwineBall-Schema.SQL.
- Run the TwineBall-Schema.bat script. Resolve any errors
before continuing.
- Set up the Event and Archive tables. In the setup/SQL
directory, you'll find WBIA-Events.sql and
WBIA-Events.bat.
- Run the WBIA-Events.bat script. Resolve any errors before
continuing.
