Installation and usage

This section discusses the following:

Before using JDBCODA

Before you can run JDBCODA, you must:

After installing the JDBC driver and setting configuration values in the shell or batch file, you must do the following to generate business objects:

  1. Launch the ODA.
  2. Launch Business Object Designer Express.
  3. Follow a six-step process in Business Object Designer Express to configure and run the ODA.

The following sections describe these steps in detail.

Launching JDBCODA

You can launch the JDBCODA with the startup script appropriate for your operating system.

start_JDBCODA.bat

You configure and run JDBCODA using Business Object Designer Express. Business Object Designer Express locates each ODA by the name specified in the AGENTNAME variable of each script or batch file. The default ODA name for this connector is JDBCODA.

Running multiple instances of JDBCODA

It is recommended that you change the name of the ODA when you run multiple instances of it. To create additional uniquely named instances of JDBCODA:

It is recommended that you prefix each name with the name of the host machine when you run ODA instances on different machines.

Select the ODA tells you how to select the ODA to run.

Working with error and trace message files

Error and trace message files (the default is JDBCODAAgent.txt) are located in \ODA\messages\, which is under the product directory. These files use the following naming convention:

AgentNameAgent.txt

If you create multiple instances of the ODA script or batch file and provide a unique name for each represented ODA, you can have a message file for each ODA instance. Alternatively, you can have differently named ODAs use the same message file. There are two ways to specify a valid message file:

Important:
Failing to correctly specify the message file's name when you configure the ODA causes it to run without messages. For more information on specifying the message file name, see "Configure initialization properties".

During the configuration process, you specify:

Table 12 describes these values.

Table 12. Tracing levels

Trace level Description
0 Logs all errors
1 Traces all entering and exiting messages for method
2 Traces the ODA's properties and their values
3 Traces the names of all business objects
4 Traces details of all spawned threads
5 * Indicates the ODA initialization values for all of its properties * Traces a detailed status of each thread that JDBCODA spawned * Traces the business object definition dump

For information on where you configure these values, see "Configure initialization properties".

Copyright IBM Corp. 2004