The Database Table Mapping service has the following data externalized in the services file:
JDBCTable tag attributes
id
Name of the JDBCTable name attribute.
autoConnect
Specifies whether an automatic connection is to be made to the database. Possible values are:
true
false (default)
autoCommit
Specifies whether an automatic commit is to be performed 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.
databaseURL
The database URL where the table is created.
user
The userid to log on to the database, if required.
password
The password to log on to the database, if required.
JDBCDriver
Name of the JDBC Driver the service will use, either to request the connection to the database or to execute the SQL statements.
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.
sharedConnection
The alias of the connection the service wants to share with other JDBC services service instances.
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).
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.
Column tag attributes
id
Name of column
dataName
Name of data field or name of the key that keeps the data field value
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.