See information about the latest product version
JDBCProviders configurable service
Select the objects and properties that you want to change for the JDBCProviders configurable service.
For JDBCProviders configurable services, you must stop and start the execution group for a change of property value to take effect.
Supplied configurable services that are created for each broker | Properties for each configurable service that is defined | Description of properties |
---|---|---|
DB2 |
connectionUrlFormat |
A pattern that represents the connection URL definition,
which is specific to a particular database type. For example, the
pattern for DB2® is defined with
the following fixed content:
Do not use the mqsichangeproperties command to change the pattern itself; changes made to the pattern might cause unpredictable results.
|
connectionUrlFormatAttr1 |
If the specified URL format contains non-standard JDBC data source properties, such as a server identifier, specify one of five general-purpose connection attributes to define these additional properties. For example, if connectionURLFormat = jdbc:oracle:thin:[user]/[password]@[serverName]:[portNumber]:[connectionUrlFormatAttr1], connectionUrlFormatAttr1 must contain an Oracle server identifier, which you must supply by defining the value for the property connectionUrlFormatAttr1 on the mqsicreateconfigurableservice or mqsichangeproperties command. The broker can then substitute all the required values into the required pattern. |
|
databaseName |
The name of the database to which the data source entry enables connections; for example, employees. |
|
databaseSchemaNames |
The name of the database schema to include in SQL statements created by message flow nodes. This property is used only by the Mapping node, and only when calling a graphical data map that contains a database transform. Valid values are:
|
|
databaseType |
The database type, for example, DB2. |
|
databaseVersion |
The database version; for example, 9.1. |
|
description |
An optional property to describe the data source definition. |
|
environmentParms |
DB2 and Informix® only. An optional property specifying a list of data source properties of the form name=value each separated by a semicolon. |
|
jarsURL |
The local directory path on the system on which the broker is running, where the JAR file that contains the type 4 driver class is located. |
|
portNumber |
The port number on which the database server is listening; for example, 50000. |
|
securityIdentity |
|
|
serverName |
The name of the server; for example, host1. |
|
type4DatasourceClassName |
The name of the JDBC type 4 data source class name that is used to establish a type 4 connection to a remote database and for coordinated transaction support; for example, com.ibm.db2.jcc.DB2XADataSource. |
|
type4DriverClassName |
The name of the JDBC driver class name that is used to establish a connection; for example, com.ibm.db2.jcc.DB2Driver. |
|
jdbcProviderXASupport |
This property is optional. Setting this property to true, indicates that the selected JDBC provider supports XA coordinated transactions, and the database server is enabled to use the XA transaction protocol. Setting this property to false, indicates that the selected JDBC provider either does not support XA coordinated transactions, or the database server is not enabled to use the XA transaction protocol. The default value for this property is true. If you set this property to true, and the selected JDBC provider does not support XA transactions, an exception is raised. If you set this property to false, but the Coordinated Transaction message flow property is selected, an exception is raised. |
|
maxConnectionPoolSize |
Connection pooling is switched on for a JDBCProviders configurable service when the value for this attribute is non-zero and within the range 1 - 100000. The connection pool limits the number of connections for that configurable service for each execution group. Note that, after you have set a value for this attribute, you must stop and restart the execution group for the changes to take effect. The default value for this attribute is zero and this value turns connection pooling off for the execution group. All message flows in an execution group that use the same JDBCProviders configurable service share the same connection pool. Multiple JDBCProviders configurable services that refer to the same database have their own pool of independently controlled connections to that database |