_aud is automatically converted to _AUD

Hibernate ORM
1

we kept the . but the table name is automatically converted to test_table_AUD while executing the code. but we have the test_table_aud table in DB.

Error:
Caused by: java.sql.SQLSyntaxErrorException: Table ‘test_table_AUD’ doesn’t exist
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1092)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1040)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1347)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1025)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:197)
… 23 more

POI:

org.hibernate
hibernate-envers
5.4.9.Final
compile

Please help on this.

  1. List item
2

You can configure the default suffix through the org.hibernate.envers.audit_table_suffix configuration property. See the documentation for details: Hibernate ORM 5.6.7.Final User Guide