Installed file structure

The following subsections describe the installed file structure of the adapter on Windows, OS/400, and Linux platforms.

Table 2 describes the Windows file structures, Table 3 describes the OS/400 file structures, and Table 4 describes the Linux file structures used by the connector.

For more information on installing the connector component, refer to the following guides:

Installed file structure on a Windows system

For instructions on installing the JDBC adapter on a Windows system, see the WebSphere Business Integration Server Express Installation Guide for Windows. Table 2 describes the Windows file structure used by the connector.

Table 2. Installed Windows file structure for the connector

Subdirectory of %ProductDir% Description
connectors\JDBC
Contains the connector file CWJDBC.jar, the start-up files start_JDBC.bat and start_JDBC_service.bat, and the readme.htm file.
connectors\JDBC\dependencies
Contains the SQL scripts that create the event, archive, and unique identifier tables.
connectors\messages
Contains the JDBCConnector.txt file.
repository\JDBC
Contains the CN_JDBC.txt file.
connectors\JDBC\Samples
Contains sample files for creating different stored procedures and business objects.
\lib
Contains the WBIA. jar file.
\bin
Contains the CWConnEnv.bat file.

For Windows, the Installer adds an icon for the connector file viewable by selecting Programs>IBM WebSphere Business Integration Express>Adapters>Connectors. For a fast way to start the connector, create a shortcut to this file on the desktop.

Installed file structure for OS/400

For instructions on installing the JDBC adapter on an OS/400 system, see the WebSphere Business Integration Server Express Installation Guide for OS/400. Table 3 describes the OS/400 file structure used by the connector. Also, library QWBISVR43 contains a CL program, QWBIJDBCSQ, that is used to create the event, archive, and unique identifier tables. A source physical file QWBISRC in library QWBISVR43 contains members which contain the SQL scripts for the QWBIJDBCSQ CL program. A job description, QWBIJDBCC, is created in library QWBIJDBCSQ

Note:
ProductDir is hardcoded on OS/400 as /QIBM/ProdData/WBIServer43

Table 3. Installed OS/400 file structure for the connector

Subdirectory of %ProductDir% Description
connectors/JDBC Contains the connector CWJDBC.jar and the start_JDBC.sh files.
connectors/JDBC/dependencies Contains the SQL scripts that create the event, archive, and unique identifier tables.
connectors/messages Contains the JDBCConnector.txt file.
repository/JDBC Contains the CN_JDBC.txt file.
connectors/JDBC/Samples Contains README_Samples.txt and sample files for creating different stored procedures and business objects
/lib Contains the WBIA. jar file.
/bin Contains the CWConnEnv.sh file.

For OS/400, a function called WebSphere Business Integration Console runs on Windows. The Console tool can be used as a fast way to start the connector. For information about the Console, refer to the online help provided with the Console.

Section: Installed file structure for Linux

For instructions on installing the JDBC adapter on a Linux system, see the WebSphere Business Integration Server Express Installation Guide for Linux. Table 4 describes the Linux file structure used by the connector.


Table 4. Installed Linux file structure for the connector

Subdirectory of %ProductDir% Description
connectors/JDBC Contains the connector CWJDBC.jar and the start_JDBC.sh files.
connectors/JDBC/dependencies Contains the SQL scripts that create the event, archive, and unique identifier tables.
connectors/messages Contains the JDBCConnector.txt file.
repository/JDBC Contains the CN_JDBC.txt file.
connectors/JDBC/Samples Contains sample files for creating different stored procedures and business objects.
/lib Contains the WBIA. jar file.
/bin Contains the CWConnEnv.sh file.

For Linux, you must start the connector by using the "connector_manager" command. See Invoking the start-up script on Linux.

Copyright IBM Corp. 2004