Configuring a JDBC provider configurable service for the database stored procedures scenario

Configure a JDBC provider configurable service 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 provider configurable service 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 defining the JDBC provider configurable service properties. You must set the following properties:
  • Name. Set its value to CLIENTS.
  • Type. Set its value to JDBCProviders.
  • Template. Set its value to DB2.
  • databaseName. Set its value to CLIENTS.
  • jarsURL. For a default DB2® installation on Windows, set its value to C:\Program Files\IBM\SQLLIB\java.
  • securityIdentity. Set its value to mySecurityId.
    Tip: You will use this security identity in the Securing the JDBC provider configurable service for the database stored procedures scenario, where you associate the user ID and password with this security identity.
  • serverName. Set its value to localhost.

Procedure

To configure the JDBC provider configurable service CLIENTS, run the mqsicreateconfigurableservice command.

In the IBM® Integration Console, issue the following command:

mqsicreateconfigurableservice IBNODE -c JDBCProviders -o CLIENTS -n connectionUrlFormat,connectionUrlFormatAttr1,connectionUrlFormatAttr2,connectionUrlFormatAttr3,connectionUrlFormatAttr4,connectionUrlFormatAttr5,databaseName,databaseType,databaseVersion,description,environmentParms,jarsURL,jdbcProviderXASupport,maxConnectionPoolSize,portNumber,securityIdentity,serverName,type4DatasourceClassName,type4DriverClassName -v "jdbc:db2://[serverName]:[portNumber]/[databaseName]:user=[user];password=[password];","","","","","","CLIENTS","DB2 Universal Database","10.1","default_Description","default_none","C:\Program Files\IBM\SQLLIB\java","true","0","50000","mySecurityId","localhost","com.ibm.db2.jcc.DB2XADataSource","com.ibm.db2.jcc.DB2Driver"

The example that is shown here uses the values for the scenario configuration.
  • IBNODE is the name of the integration node.
  • -o defines the name of the JDBC configurable service. It is set to the value to the name of the development database, CLIENTS, which you used to configure the data definition file in the IBM Integration Toolkit.
  • -n defines the list of properties that you must set to configure the JDBC connection. These properties are required by the Mapping node to access the database information at run time.
  • -v defines the values that you set for each property that is defined by the -n parameter.

Results

A JDBC provider configurable service is available at run time.

What to do next

Follow the steps in Securing the JDBC provider configurable service for the database stored procedures scenario.