Database Table Mapping external definitions

The Database Table Mapping service has the following data externalized in the services definition file:
Table 1. JDBCTable tag attributes
Tag attribute Attribute description
id Name of the JDBCTable instance.
connManager Name of the connection manager the service is using. The value must match ID of the connection manager defined in the service definition file (dsesrvce.xml).
autoConnect Specifies whether the service makes an automatic connection to the database. Possible values are:
  • true
  • false (default)
autoCommit Specifies whether the service performs an automatic commit after each statement execution. Possible values are:
  • true
  • false (default)
catalog The name of the table catalog in the database (if it applies to the DBMS being used).
schema The name of the table schema in the database if it applies to the DBMS being used. It is case-sensitive based in the DBMS specifications.
table The name of the table in the database. It is case-sensitive based in the DBMS specifications.
user The userid to log on to the database, if required.
password The password to log on to the database, if required.
dataSourceName The DataSource object name to be used by all requests to get a connection. This name requires a context part and a logical name part because the connection manager uses it 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." The application server administrator can supply this information and identify the DataSource object placed in the naming service.
primaryKeys A boolean value. If set to true (the default value), the service controls the primary key access when executing an update statement. This prevents anything else from updating these columns while the update is occurring.

If set to false, the service does not perform primary key checking. Set this attribute to false if the specific JDBC implementation (as for DB2(R) UDB for OS/390(R)) does not support the getPrimaryKeys method.
Table 2. column tag attributes
Tag attributes Attribute description
id Name of column used for mapping from the context to the table.
dataName Name of data field or key that keeps the data field value in the context.
Example:
<JDBCTable id="myMapping" table="myTable" autoConnect="true">
  <column id="CLIENT_ID" dataName="client.socialSecurityNumber"/>
  <column id="FIRSTNAME" dataName="client.firstName" />
  <column id="LASTNAME" dataName="client.lastName" /> 
</JDBCTable>

The <column> tag maps a specific data field in the context to a column in the database table if the data field and the column do not have the same name. The dataName tag attribute can directly hold the data field name or a key name if a KeyedObject formatter is being used inside the Hashtable formatter definition.

For the JDBCServicesConnectionManager tag and its attributes, see Connection Manager external definitions.