---
title: Upgrade JDBC audit event handlers
description: "If you had configured one or more JDBC audit event handlers, make the following changes to the audit tables' schema:"
component: pingam
version: 7.5
page_id: pingam:upgrade:upgrading-jdbc-audit-event-handlers
canonical_url: https://docs.pingidentity.com/pingam/7.5/upgrade/upgrading-jdbc-audit-event-handlers.html
keywords: ["Upgrade", "Logs"]
page_aliases: ["upgrade-guide:upgrading-jdbc-audit-event-handlers.adoc"]
---

# Upgrade JDBC audit event handlers

If you had configured one or more JDBC audit event handlers, make the following changes to the audit tables' schema:

1. Run the following command on Oracle databases that support AM audit event handlers:

   ```
   ALTER TABLE am_auditaccess ADD (response_detail CLOB NULL);
   ```

   This command adds the `response_detail` column to the `am_auditaccess` table.

2. Run the following commands on MySQL databases that support AM audit event handlers:

   ```
   ALTER TABLE audit.am_auditconfig CHANGE COLUMN configobjectid objectid VARCHAR(255);
   ALTER TABLE audit.am_auditaccess ADD COLUMN response_detail TEXT NULL;
   ```

   The commands change the name of the `configobjectid` column in the `am_auditconfig` table to `objectid` and add the `response_detail` column to the `am_auditaccess` table.

3. If you use databases other than Oracle or MySQL to support AM audit event handlers, review their schema.

   If the `am_auditconfig` table has a column named `configobjectid`, change that column's name to `objectid`.

   If the `am_auditaccess` table does not have a column named `response_detail`, add that column to the table's schema.