
13
5 Configuring the DLT for a JDBC connection
Do the following process to configure TBSM DLT for a JDBC connection with TADDM.
Transfer the JAR files
The TADDM JAR files that are required by the toolkit are obtained by the DLT automatically.
Except a new JAR required for the JDBC connection (marked with an * below). Follow these
instructions if you would like to obtain all of these manually, or just obtain oal-topomgr.jar
manually:
1. From TADDM, copy the following JAR files from the %TADDM_HOME%/dist/sdk/lib
directory:
oal-topomgr.jar*
platform-model.jar
taddm-api-client.jar
2. Place these files into the %TBSM_HOME%/XMLtoolkit/sdk/clientlib directory.
If you start the toolkit and one or more new TADDM jars are detected, the jar will be pulled
automatically and you will be asked to stop and restart the toolkit to continue operations. Please see
the XMLtoolkit/logs/msgGTM_XT.log.0 file for these messages.
Add the change table to the TADDM database
A JDBC connection requires a change table be added to the TADDM database server for TBSM.
1. From the %TBSM_HOME%/XMLtoolkit/sql directory copy the
taddm_schema_setup_db2.sql file to the TADDM database server.
2. Using your DB2 instance user, connect to the TADDM database and enter db2 -tvf
taddm_schema_setup_db2.sql.
If using an Oracle database for TADDM please use the oracle file in a similar fashion.
Final Steps to pull data from TADDM
1. As in the past, you might have to run the setxmlaccess script to update your user
information. This command can be found in the %TBSM_HOME%/XMLtoolkit/bin directory.
2. For JDBC, you must issue the following command to set up the direct connection (found in the
same directory as the setxmlaccess script (only required if you did not configure TADDM at
the time of install or your configuration has changed):
Comentários a estes Manuais