Setting up a JDBC provider for type 4 connections
Use the mqsicreateconfigurableservice or the mqsichangeproperties command to configure a JDBC provider service.
Before you begin
- See the following information: Creating an integration node.
- Create the database by following the database documentation.
About this task
Important: When naming your JDBCProvider service, consider
the following requirements:
- If you want to use your JDBCProvider service with a JavaCompute node, or with a Java user-defined node, the name
of your JDBCProvider service must match the datasourceName parameter
in the
getJDBCType4Connection()
API call from the node. - If you want to use your JDBCProvider service with a Mapping node, the name of your JDBCProvider service must match the database name that is used by the database transforms in your Graphical Data Map. For each database transform, the database name is determined by the database definition (.dbm file) in the Data Design project that was used to create the map.
- If you want to use your JDBCProvider service with a DatabaseRetrieve node, or with a DatabaseRoute node, the name of your JDBCProvider service must match the value of the Data source name property of the node.
A JDBCProvider configurable service supports connections to one database only; you must create a service for each database that your nodes or Java applications connect to.
To set up a JDBC provider for type 4 connections by using the web user interface, see Creating configurable services.
To set up a JDBC provider for type 4 connections by using the mqsicreateconfigurableservice or mqsichangeproperties commands, complete the following steps: