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:
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.
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
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.
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.