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:
|
autoCommit | Specifies whether the service performs an automatic commit after each
statement execution. Possible values are:
|
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. |
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. |
<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.