JsonBlobType not working with Oracle in case of @Audited

[kuldeeparora89]

Hi,

I am getting below error -

Caused by: org.hibernate.MappingException: Could not determine type for: jsonb-lob, at table: hyperform_common_config_AUD, for columns: [org.hibernate.mapping.Column(config_data)]

This error only happens when I apply @Audited on the entity.

Code -

@TypeDefs({ @TypeDef(name = "jsonb", typeClass = JsonBlobType.class) })
    @Audited
    @Table(name = "hyperform_common_config")
    @Entity
    public class CommonConfig implements Serializable{

    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Id
    @Column(name = "id")
    private long id;
    @Type(type = "jsonb")
    @Column(name = "config_data")
    private String configData;

Please suggest !!

[vladmihalcea]

There are two ways you can fix this problem:

1. You investigate it, provide a fix, and send a Pull Request which I'll review when I have some time.
2. Your company employs my consulting services to investigate the issue and provide a fix.

You can choose whichever option works best for you.

[kuldeeparora89]

Strangely by just changing the name of type to "jsonb-lob" it worked -

@TypeDefs({ @TypeDef(name = "jsonb-lob", typeClass = JsonBlobType.class) })
@Audited
@Table(name = "hyperform_common_config")
@Entity
public class CommonConfig implements Serializable{

    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Id
    @Column(name = "id")
    private long id;
    @Type(type = "jsonb-lob")
    @Column(name = "config_data")
    private String configData;

[vladmihalcea]

I'm glad you found the solution.