Page created: 22 Jul 2020 |
Page updated: 12 Dec 2022
The log field mapping table associates access log fields to the database column names. You can configure the log field mapping table using the dsconfig tool, which then generates a DDL file that you can import into your database. The DDL file is generated when you create the JDBC Log Publisher.
To uniquely identify a log record, we recommend always mapping the following fields:
The table name is not part of this mapping.
The Directory Server also provides three options that you can quickly select for creating a log field mapping table:
- Complete JDBC Access Log Field Mappings. Maps all 52 object properties.
- Complete JDBC Error Log Field Mappings. Maps all 8 object properties.
- Simple JDBC Access Log Field Mappings. Maps a common set of object properties.
- Custom JDBC Access Log Field Mappings. Create a custom set of JDBC log field mappings.
- Custom JDBC Error Log Field Mappings. Create a custom set of JDBC error log field mappings.
- Use dsconfig to create a log field mapping table. On the main menu, type o to change to the Standard Object menu, and type the number corresponding to Log Field Mapping.
- On the Log Field Mapping management menu, enter the option to create a new Log Field Mapping.
- On the Log Field Mapping template menu, enter the option to select a complete JDBC Access Log Field mapping to use as a template for your new field mapping.
- Next, enter a name for the new field mapping. In this example, type my-jdbc-test.
- On the Access Log Field Mapping Properties menu, select a property for which you want to change the value. Any property that is undefined will not be logged by the JDBC Access Log Publisher. When complete, type f to save and apply the changes.
- On the Log Field Mapping Management menu, type q to exit the menu.
View the existing Log Mappings on the system.
$ bin/dsconfig list-log-field-mappings
Log Field Mapping : Type ----------------------------------------:------- Complete JDBC Access Log Field Mappings : access Complete JDBC Error Log Field Mappings : error my-jdbc-test : access Simple JDBC Access Log Field Mappings : access