IBM WebSphere Multichannel Bank Transformation Toolkit, Version 7.1

Electronic Journal external definitions

The Electronic Journal service has the following data externalized in the services definition file:
Table 1. JDBCJournal tag
Tag attribute Tag description
id Name of the JDBCJournal attribute.
autoCommit Specifies whether an automatic commit is made after each journal update:

true (default)

false

schema Schema name. If the schema is created in the DBMS, the schema name must match the DBMS specifications (for instance, in DB2®, the name must be 8 characters or fewer and uppercase).
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 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 The alias of the connection that the service wants to share with other JDBC service instances.
createSchema A boolean value. If set to true (the default value), the service understands there is a schema in the database that keeps the journal tables. If you set this attribute to false, the service understands there is no schema created in the database for keeping the journal tables. You must set this attribute to false if the DBMS being used does not support schemas (such as DB2 UDB for OS/390®).
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.
singleTable Determines whether the JDBCJournal instance being instantiated and initialized uses the same table as other JDBCJournal 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 Journal service instance.
Table 2. column tag
Tag attribute Tag description
id Journal table column name used for mapping.
dataName Operation context DataField name (or the key that keeps the data field value) used for mapping.


Feedback