facing problem while retrieving entity based on foreign-key which is a UserType

[amit1]

We am facing problem while retrieving entity based on id which is a UserType

We have an entity money which has a bag of levels

money.hbm.xml

     <bag name="levels" inverse="true" cascade="all-delete-orphan"  outer-join="false">
            <key column="MONEY_ID"/>
            <one-to-many/>
        </bag>

Inside level.hbm.xml we have

          <property
            name="moneyId"
            column="MONEY_ID"
            type="UidType"
        />

where UidType is a custom UserType

The data gets persisted in the audit table. However on retrieving it is giving following error:-

could not resolve property: moneyId_uid of: LevelImpl_AUD [select new list(e) from LevelImpl_AUD e where e.moneyId_uid = :moneyId_uid and originalId.REV.id = (select max(e2.originalId.REV.id) from LevelImpl_AUD e2 where e2.originalId.REV.id <= :revision and e.originalId.uid = e2.originalId.uid) and REVTYPE != :delrevisiontype]

[adamw]

Hmm, weird. Could you create a JIRA issue with a reproducing test case?

Adam

[amit1]

By specifying inverse=true for bag name="levels", envers assumes the relationship to be bidirectional and therefore it is giving the error could not resolve property: moneyId_uid since it is a unidirectional relationship. On specifying inverse="false" it is working fine.

<bag name="levels" inverse="false" cascade="all-delete-orphan"  outer-join="false">
            <key column="MONEY_ID"/>
            <one-to-many/>

</bag>

so it is working now. Thanks