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.
You configure the runtime database resources by defining
the JDBC provider configurable service properties. You must set the
following properties:
- 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.
Note: The table names must be the same in the database development
environment and in the run time database environment.
The following table lists the database resource names
in the development environment, and in the runtime environment:
Table 1. Scenario database resource names |
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
- Server1 is the name of the runtime broker.
- -o defines the name of the JDBC
configurable service.
Set the value to the name of
the development database, that is, CLIENTS. CLIENTS is the development
database name that you used to configure the data definition file
in the WebSphere Message
Broker 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.
You must define
the databaseName property, and the databaseSchemaNames property.
- -v defines the values you set for
each property defined in -n.
- Set the databaseName property to be the
name of your runtime database, that is, PCLIENTS.
- Set the databaseSchemaNames property to
be the name of your runtime schema, that is, PADDRESSBOOK.
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.