See information about the latest product version
Configuring a JDBC provider configurable service
You can configure a JDBC provider configurable service by running the mqsicreateconfigurableservice command.
Before you begin
The broker named Server1 is created and started.
About this task
The WebSphere® Message Broker Toolkit connects to the database CLIENTS and runs discovery so the Graphical Data Mapping editor can use the database definition to visualize the database tables PERSON, ADDRESS, and PHONE.
At run time, the Mapping node uses a JDBC provider configurable service named CLIENTS to obtain the configuration parameters that will enable it to make the connection to the runtime database PCLIENTS that the message map will execute against.
- databaseName property: You must set its value to be the runtime database name PCLIENTS.
- databaseSchemaNames property: You must set its value to use at run time the database schema PADDRESSBOOK.
The following table lists the database resource names in the development environment, and in the runtime environment:
Development database resource names | Runtime database resource names | |
---|---|---|
Database name | CLIENTS | PCLIENTS |
Schema name | ADDRESSBOOK | PADDRESSBOOK |
Tables names | PERSON, ADDRESS, PHONE | PERSON, ADDRESS, PHONE |
Procedure
To configure the JDBC provider configurable service CLIENTS, run the mqsicreateconfigurableservice command:
mqsicreateconfigurableservice Server1 -c JDBCProviders -o CLIENTS -n databaseName,databaseSchemaNames -v PCLIENTS,PADDRESSBOOK
where
Results
A JDBC provider configurable service is available at run time.
What to do next
Secure the JDBC connection. For more information, see Securing the JDBC provider configurable service.