java - 插入带有公式的字段( hibernate )

Question

我需要在插入对象之前设置另一个选择的字段之一。

我创建的属性如下:

        <property name="measureIndex" not-null="false" type="integer">
            <formula>(SELECT MAX(measure.measureIndex)+1 from measure WHERE measure.schemaId = schemaId)</formula>
            <column name="measureIndex" default="1" />
        </property>

但是抛出了错误 - 嵌套异常是:org.hibernate.MappingException:属性映射的列数错误:com.dataswell.core.domain.api.Measure.measureIndex 类型:整数

Answer 1

然后尝试:

<property name="measureIndex" not-null="false" type="integer">
  <formula>(SELECT IFNULL(MAX(measure.measureIndex),0)+1 from measure WHERE measure.schemaId = schemaId)</formula>
</property>