IBM WebSphere Multichannel Bank Transformation Toolkit, Version 7.1

Store external definitions

The Store service has the following data externalized in the Services file:
Table 1. JDBCStore tag attributes
Attribute Description
id Name of the JDBCStore attribute.
autoCommit Specifies whether automatic commit is performed after each store write/update. Possible values are:

true

false (default)

catalog Name of the database catalog in which the table is created (if it applies to the DBMS being used). It may be case-sensitive based on the DBMS specifications.
schema Name of the table schema in the database (if it applies to the DBMS being used). It may be case-sensitive based on the DBMS specifications.
table Name of the table used by the store object. It may be case-sensitive based on the DBMS specifications.
JDBCDriver Name of the JDBC Driver that the service will use to request the connection to the database and to execute the SQL statements.
poolName Name of the connection manager pool containing the connection type you want. Consult the WebSphere® administrator for the pool name.
dataSourceName The DataSource object name to be used by all requests to get a connection. This should be specified when working with the connection pooling provided by WebSphere Application Server or with any other JDBC implementation of the connection pooling. This name requires a context part and a logical name part, since it will be used to do a lookup in the naming context. A typical string might look something like "jdbc/sample," where the context is "jdbc" and the logical name is "sample." This information can be supplied by the WebSphere administrator, and it identifies the DataSource object placed in the naming service.
sharedConnection Alias of the connection the service wants to share with other JDBC services instances.
singleTable Determines whether the JDBCStore instance being instantiated and initialized uses the same table as other JDBCStore instances. The attribute's value can be true or false (default). Set this value to true if the application uses a generic pool when requesting a Store service instance.
statementPoolSize Defines the dimension of the statements pool. The default value is 32. Increase the value of the attribute to improve system performance or reduce the value to prevent exhausting system resources.
Table 2. column tag attributes
Attribute Description
id Name of table column.
dataName Name of context data field or name of the key that keeps the data field value.
The following is an example:
<JDBCStore id="myStore" autoCommit="true" table="myTable"> 
  <column id="ACCOUNT_NUMBER" dataName="account.accountNumber" />
  <column id="AMOUNT" dataName="account.amount" />
  <column id="OPERATION_ID" dataName="operationId" />
</JDBCStore>

The tag column is used to map a specific data field in the operation context to a column in the database table in cases where the data field and the column do not have the same name, or where the data field is not located in the first level of the operation context. The dataName tag attribute can directly hold the data field name or a key name if a KeyedObject format is being used inside the Hashtable format definition.



Feedback