Configure connections to a database through a JDBCProvider configurable service.
You must also set up JDBC connections if your message flows include graphical data maps with one or more database transforms to be run from a Mapping node, or if they include DatabaseRetrieve or DatabaseRoute nodes.
If you configure a JDBC type 4 connection from an application running on a Linux, UNIX, or Windows system, you can configure your integration node and queue manager to include interactions with the databases in globally-coordinated transactions. On z/OS®, JDBC connections can be coordinated only by the integration node.
The information provided in this section is independent of whether your operating systems, integration nodes, integration servers, queue managers, and databases operate in 32-bit or 64-bit mode, except where stated.
When you write Java classes for a JavaCompute node or a user-defined node, your code must comply with the following restrictions:
To configure JDBC type 4 connections:
When you have completed configuration of the databases, add or modify Java code in your JavaCompute or user-defined nodes to access the database that is identified in the JDBCProvider configurable service.