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.
- 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.
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"
- 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.