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. |
Attribute | Description |
---|---|
id | Name of table column. |
dataName | Name of context data field or name of the key that keeps the data field value. |
<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.