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 name attribute.
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.
poolName Name of the connection manager pool containing the connection type you want. Consult the WebSphere® administrator for this 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 Application Server administrator, and it identifies the DataSource object placed in the naming service.
primaryKeys A boolean value.

If set to true (the default), the service will control the primary keys access when an update statement is executed. (By getting information about the primary keys columns defined for the database table, it will prevent the application from updating these columns if, by error, it tries to.)

If set to false, no primary keys checking is done by the service. This attribute must be set to false if the getPrimaryKeys() method is not supported by the specific JDBC implementation (as for DB2® UDB for OS/390®).
Table 2. column tag attributes
Tag attributes Attribute description
id Name of column.
dataName Name of data field or name of the key that keeps the data field value.
Example:
<JDBCTable id="myMapping" table="myTable" dataSourceName="jdbc/myDS" connManager="JDBCServicesConnMgr">
  <column id="CLIENT_ID" dataName="client.socialSecurityNumber"/>
  <column id="FIRSTNAME" dataName="client.firstName" />
  <column id="LASTNAME" dataName="client.lastName" /> 
</JDBCTable>

The tag column is used to map 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.