Adapter for JDBC 10.3 | webMethods Adapter for JDBC Documentation | webMethods Adapter for JDBC Installation and User’s Documentation | Adapter for JDBC Connections | Before Configuring or Managing Adapter Connections
 
Before Configuring or Managing Adapter Connections
Perform the following steps before configuring or managing adapter connections.
*To prepare to configure or manage adapter connections
1. Install webMethods Integration Server and Adapter for JDBC on the same machine. For details, see Overview of Installing, Upgrading, and Uninstalling Adapter for JDBC.
2. Install a compatible JDBC driver. For instructions, see Installing a JDBC Driver on Integration Server. For a list of supported drivers, see webMethods Adapters System Requirements.
3. Make sure you have Integration Server administrator privileges so that you can access Adapter for JDBC's administrative screens. For information about setting user privileges, see the webMethods Integration Server Administrator’s Guide for your release.
4. Be sure to check for a list of known driver limitations because it may affect how you configure your connections.
5. Start your Integration Server and Integration Server Administrator, if they are not already running.
6. Using Integration Server Administrator, make sure the WmJDBCAdapter package is enabled. For instructions, see Enabling Packages.
7. Using Designer, create a user-defined package to contain the connection, if you have not already done so. For more information about managing packages for the adapter, see Adapter for JDBC Package Management.
8. If you use Oracle JDBC OCI drivers, you must set an environment variable before you can configure the connection. For details, see Setting the Environment Variable for Oracle JDBC OCI Drivers.
If you use Oracle JDBC OCI drivers with Oracle OCI Instant Client, then copy the following client library files before you set the environment variable:
*ojdbc5.jar and ojdbc6.jar files to the two locations, Integration Server_directory\lib\jars and Integration Server_directory\instances\instance_name\lib\jars.
*All the other client library files to the two locations, Integration Server_directory\lib and Integration Server_directory\instances\instance_name\lib.