如论坛- https://vladmihalcea.com/oracle-json-jpa-hibernate/所建议的
我使用以下代码将oracle blob JSON列与实体中的字符串类型进行映射-
@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;
但是JsonBlobType在@Audited的情况下不起作用。错误-
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)]
审计表需要做额外的配置吗?
发布于 2021-08-02 14:23:29
奇怪的是,只需将类型名称更改为"jsonb-lob“,它就可以工作了-
@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;
https://stackoverflow.com/questions/68622705
复制相似问题