x

To install and configure H2DB:

1. Download the latest, stable version of H2DB from the following Web site:

   http://h2database.com/html/download.html

2. Unzip the file to a folder.
3. Copy the h2-1.1.114.jar file (or a similar stable version) from the bin folder to the following directory:

   iWay_Home\lib

   where:

   iWay_Home

   Is the directory where iWay Service Manager is installed.

4. Open the iWay Service Manager Administration Console and navigate to either the existing Data Provider referenced to by the TPMDriver or create a new driver with the following properties:

   1. Name: H2-TPMConnectionPool (or something similar, in case you are creating a new provider)

   2. Driver Class: org.h2.Driver

   3. Connection URL: jdbc:h2:~/TPM-H2-DB;MVCC=TRUE;MODE=MySQL

   4. User: iWay

   5. Password: tpm

5. Click Test.

   

6. Click Add if the test is successful.
7. Restart iWay Service Manager and check the log files. The H2 Database must be initialized and the database script must run without errors.

   Note: The script runs only the very first time and will not run any of the proceeding times.

Note: Running the H2 database in this mode means that the database cannot be queried externally. This is an example of RAD using TPM or a solution when the required database is not one of the targeted databases of the client.