Adapter for JDBC 10.3 | webMethods Adapter for JDBC Documentation | webMethods Adapter for JDBC Installation and User’s Documentation | Overview of the Adapter | Adapter Connections
 
Adapter Connections
 
Using JDBC Drivers to Connect to Databases
Transaction Management of Adapter Connections
Transaction Isolation Level Settings
Connection Pools
Built-In Services for Connections
Adapter for JDBC connects to a database through a JDBC driver at run time. You create one or more connections at design time to use in integrations. The number of connections you create, and the types of those connections, depend on the types of databases you are connecting to and your integration needs. For example, if you are connecting to an Oracle database and a DB2 Server database, you will need to create connections that are unique to those two databases. Additionally, if you have multiple installations of the same kinds of databases, you access each using different connections. For example, if you have a data warehouse system and an ERP system that use your Oracle database, you create a connection for each system.
Adapter for JDBC connections contain parameters that Integration Server uses to manage connections to the database so that they can be used by the adapter to provide services. You configure connections using Integration Server Administrator. You must have Integration Server Administrator privileges to access Adapter for JDBC's administrative screens.
For instructions on configuring, viewing, editing, enabling, and disabling Adapter for JDBC connections, see Overview of Adapter Connections. For information about setting user privileges, see the webMethods Integration Server Administrator’s Guide for your release.