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: timestamp, startupid, message-type, connection-id, operation-type, instance-name.

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.
  1. 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.
  2. On the Log Field Mapping management menu, enter the option to create a new Log Field Mapping.
  3. 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.
  4. Next, enter a name for the new field mapping. In this example, type my-jdbc-test.
  5. 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.
  6. On the Log Field Mapping Management menu, type q to exit the menu.
  7. 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