IBM Integration Bus, Version 10.0.0.3 Operating Systems: AIX, HP-Itanium, Linux, Solaris, Windows, z/OS


Configuring a JDBC provider configurable service

Configure a JDBC provider configurable service so that the deployed application can connect to the database.

Before you begin

Ensure that the integration node named IB9NODE is created and started.

About this task

At run time, the Mapping node uses a JDBC provider configurable service 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, 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 WebSphere® Message Broker Console, issue the following command:

mqsicreateconfigurableservice IB9NODE -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.
  • IB9NODE is the name of the runtime 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

Set up security for the configurable service. For more information, see Securing the JDBC provider configurable service.


sp_01_22_.htm | Last updated 2015-11-25 08:25:32