Configuring a JDBC Providers policy for the database stored procedures scenario

Configure a JDBC Providers policy so that the deployed application can connect to the database.

Before you begin

Ensure that the integration node where you will run your solution is created and started. In this scenario, the integration node is named IBNODE.

About this task

At run time, the Mapping node uses a JDBC Providers policy that is called CLIENTS to obtain the configuration parameters that it needs to connect to the database CLIENTS.

You configure the runtime database resources by creating a JDBC Providers policy, as described in Setting up a JDBC provider for type 4 connections.

Procedure

  1. Create a policy project called DefaultPolicies, by using the IBM® App Connect Enterprise Toolkit.
    1. Right-click the Stored_Procedures application and then select New -> Policy.
    2. In the Create a policy window, select New to create a policy project called DefaultPolicies and then click Finish.
    3. Enter a policy name of CLIENTS.
  2. Configure the policy by completing the following steps:
    1. As the Type, select JDBC Providers.
    2. Specify CLIENTS as the name of the database.
    3. Specify localhost as the database server name.
    4. Specify 5000 as the database server port number (the listener port number for DB2).
    5. Specify the Type 4 driver class JARs URL as the directory that contains the DB2 JDBC JARS (db2jcc.jar). On Windows, this is C:\\Program Files\\IBM\\SQLLIB\\java by default.
    6. Leave the Template value as the default.
  3. When you have created your JDBC Providers policy, deploy it to the integration server where the message flows that will use the policy are deployed.

Results

A JDBC Providers policy is available at run time.

What to do next

Follow the steps in Securing the JDBC Providers policy for the database stored procedures scenario.