The log field mapping table associates access log fields with the database column names. Configure the log field mapping table using the dsconfig tool, which 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, you should map the following fields:

  • timestamp
  • startupid
  • message-type
  • connection-id
  • operation-type
  • instance-name
Note:

The table name is not part of this mapping.

The PingDirectory server also provides these options that you can 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.
  2. In the main menu, enter o to change to the Standard Object menu, and enter the number corresponding to Log Field Mapping.
  3. In theLog Field Mapping management menu, enter the option to create a new Log Field Mapping.
  4. In theLog 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.
  5. Enter a name for the new field mapping.

    For this example, enter my-jdbc-test.

  6. In the Access Log Field Mapping Properties menu, select a property for which you want to change the value.

    Any property that is undefined is not logged by the JDBC Access Log Publisher.

  7. Enter f to save and apply the changes.
  8. In the Log Field Mapping Management menu, enter q to exit the menu.
  9. 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