java – Envers审计表中缺少属性

我正在使用envers来审核我的ParameterToValue实体.它的属性“containerId”,“containerType”,“parameterId”在映射的数据库表“values_for_params”(常规Hibernate表)中显示为列,在生成的“values_for_params_AUD”DB表中缺少.我需要能够获得给定的(containerId,containerType,parameterId)的历史“值”.

ParameterToValue类：

@Auditedpublic class ParameterToValue extends BasicValueHolder {private Long containerId;private ContainerType containerType;private Long parameterId;public ParameterToValue(ContainerID containerId, Long parameterId, Value value) {    super(value);    this.containerId = containerId.getContainerId();    this.parameterId = parameterId;    containerType = containerId.getContainerType();}ParameterToValue() {}public Long getParameterId() {    return parameterId;}public void setParameterId(Long parameterId) {    this.parameterId = parameterId;}public Value getValue() {    return value;}public void setValue(Value value) {    this.value = value;}public Long getContainerId() {    return containerId;}public void setContainerId(Long containerId) {    this.containerId = containerId;}public ContainerType getContainerType() {    return containerType;}public void setContainerType(ContainerType containerType) {    this.containerType = containerType;}}

Hibernate映射定义：

<class name="platform.server.dataservices.model.ParameterToValue" table="values_for_params">    <cache usage="read-write" include="all" />    <id name="id" column="ID">        <generator class="native"/>    </id>    <properties name="uniqueProps" unique="true">        <property name="containerId" index="ParamValsContainerIdIndx"/>        <property name="parameterId" index="ParamValsParamIdIndx"/>        <property name="containerType" column="CONTAINER_TYPE">            <type name="org.hibernate.type.EnumType">                <param name="enumClass">platform.server.dataservices.model.ContainerType</param>                <param name="type">4</param>                <!-- 12 = string, 5 = smallint, 4 = integer, default 4 -->            </type>        </property>    </properties>    <many-to-one name="value" cascade="all" lazy="false" unique="true" index="PRM_VAL_IDX"/></class>

在MySQL中显示CREATE TABLE values_for_params：

CREATE TABLE `values_for_params` (  ID` bigint(20) NOT NULL AUTO_INCREMENT,  `containerId` bigint(20) DEFAULT NULL,  `parameterId` bigint(20) DEFAULT NULL,  `CONTAINER_TYPE` int(11) DEFAULT NULL,  `value` bigint(20) DEFAULT NULL,PRIMARY KEY (`ID`),UNIQUE KEY `value` (`value`),UNIQUE KEY `containerId` (`containerId`,`parameterId`,`CONTAINER_TYPE`),KEY `ParamValsParamIdIndx` (`parameterId`),KEY `ParamValsContainerIdIndx` (`containerId`),KEY `PRM_VAL_IDX` (`value`),KEY `FKE02CB4F981565307` (`value`),CONSTRAINT `FKE02CB4F981565307` FOREIGN KEY (`value`) REFERENCES `value` (`ID`)) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8

在MySQL中显示CREATE TABLE values_for_params_AUD：

CREATE TABLE `values_for_params_AUD` (  `ID` bigint(20) NOT NULL,  `REV` int(11) NOT NULL,  `REVTYPE` tinyint(4) DEFAULT NULL,  `value` bigint(20) DEFAULT NULL,PRIMARY KEY (`ID`,`REV`),KEY `FKE093BE4AEB88DFB` (`REV`),CONSTRAINT `FKE093BE4AEB88DFB` FOREIGN KEY (`REV`) REFERENCES `DesignRevisionEntity`     (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8

解决方法:

固定.如果有人需要答案：

问题是,envers忽略了在properties标签内写的任何内容.当我以这种方式删除标签时：

<properties name="uniqueProps" unique="true">    <property name="containerId" index="ParamValsContainerIdIndx"/>    <property name="parameterId" index="ParamValsParamIdIndx"/>    <property name="containerType" column="CONTAINER_TYPE">        <type name="org.hibernate.type.EnumType">            <param name="enumClass">platform.server.dataservices.model.ContainerType</param>            <param name="type">4</param>        </type>    </property></properties>

变成了：

<property name="containerId" index="ParamValsContainerIdIndx"/><property name="parameterId" index="ParamValsParamIdIndx"/><property name="containerType" column="CONTAINER_TYPE">  <type name="org.hibernate.type.EnumType">    <param name="enumClass">platform.server.dataservices.model.ContainerType</param>    <param name="type">4</param>  </type></property>

这样,所有属性都被审计,但我仍然需要三元组(containerId,parameterId,containerType)是唯一的.最终的解决方案是：

<property name="containerId" index="ParamValsContainerIdIndx"/><property name="parameterId" index="ParamValsParamIdIndx"/><property name="containerType" column="CONTAINER_TYPE">  <type name="org.hibernate.type.EnumType">    <param name="enumClass">platform.server.dataservices.model.ContainerType</param>    <param name="type">4</param>  </type></property><properties name="uniqueProps" unique="true">  <property name="containerId" insert="false" update="false"/>  <property name="parameterId" insert="false" update="false"/>  <property name="containerType" insert="false" update="false"/></properties>

来源：https://www.icode9.com/content-1-283951.html