[hibernate-issues] [JIRA] (HHH-16932) envers audit-trail not written for jsonb column

Christian Thiel ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZGRjZDJhODk4... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16932?atlOrigin=eyJpIjoiZGRjZD... ) HHH-16932 ( https://hibernate.atlassian.net/browse/HHH-16932?atlOrigin=eyJpIjoiZGRjZD... ) envers audit-trail not written for jsonb column ( https://hibernate.atlassian.net/browse/HHH-16932?atlOrigin=eyJpIjoiZGRjZD... ) Change By: Christian Thiel ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%... ) I’m using a Embeddable Object to store i18n in a JSONB-Column like this: {noformat}@Table(schema = "mdata", name = "PART") @Audited(withModifiedFlag = true) public class Part { @JdbcTypeCode(SqlTypes.JSON) Translation description; ... {noformat} with {noformat}@Embeddable public class Translation { String de; String en; } {noformat} All changes to the Part entity trigger an entry in the envers-table PART_AUD, but * changes to the JSONB description-column are not marked as modified and the * jsonb-values in the PART_AUD are always NULL. I have added a Quarkus Sample-Project with a test-case. My findings so far: I use Flyway to create the tables → the _AUD table has a jsonb-column, like the original table. Without flyway, if i configure the project to let hibernate create the tables, the _AUD table has separate STRING columns for each field in the embeddable! This seems odd… In the insert-statement that envers generates the jsonb-column  is missing at all (see console-log of my test): {code:sql}    insert into base.PART_AUD (REVTYPE,description_MOD,name,name_MOD,stamp,stamp_MOD,REV,id) values (?,?,?,?,?,?,?,?){code} may this is releated to [https://hibernate.atlassian.net/browse/HHH-16910|https://hibernate.atlass...] ( https://hibernate.atlassian.net/browse/HHH-16932#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16932#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=Em... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100231- sha1:2991753 )