[hibernate-issues] [Hibernate-JIRA] Issue Comment Edited: (HHH-6661) Parent-child self-referencing relationship via link table causes QuerySyntaxException:(table) is not mapped when retrieving previous revisions
Xi Zhang (JIRA)
noreply at atlassian.com
Thu Jan 19 07:07:09 EST 2012
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-6661?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=45171#comment-45171 ]
Xi Zhang edited comment on HHH-6661 at 1/19/12 6:06 AM:
--------------------------------------------------------
In the version of Hibernate 4.0.1-final auditng over the ManyToOne relation works and data(parent_id) is saved correctly in the audit table, but the generated HBM file looks littel different(see below) as it in version 3.6.7
*The construct of properties in {{<join table}} disappears.*
{code}
...
<join table="Tree_HIERARCHY_HSTRY">
<key>
<column length="255" name="CHILD_ID" precision="19" scale="2"/>
<column name="REV"/>
</key>
<property insert="true" name="parent_id" type="long" update="false">
<column length="255" name="PARENT_ID" precision="19" scale="2"/>
</property>
</join>
...
{code}
was (Author: xi.zhang):
In the version of Hibernate 4.0.1-final auditng over the ManyToOne relation works and data(parent_id) is saved correctly in the audit table, but the generated HBM file looks littel different(see below) as it in version 3.
*The construct of properties in {{<join table}} disappears.*
{code}
...
<join table="Tree_HIERARCHY_HSTRY">
<key>
<column length="255" name="CHILD_ID" precision="19" scale="2"/>
<column name="REV"/>
</key>
<property insert="true" name="parent_id" type="long" update="false">
<column length="255" name="PARENT_ID" precision="19" scale="2"/>
</property>
</join>
...
{code}
> Parent-child self-referencing relationship via link table causes QuerySyntaxException:(table) is not mapped when retrieving previous revisions
> ----------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: HHH-6661
> URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6661
> Project: Hibernate ORM
> Issue Type: Bug
> Components: envers
> Affects Versions: 3.6.7
> Environment: Hibernate 3.6.7.Final, Oracle 11g DB (also reproduced with Derby 10.8.1.2), Spring 3.0.3
> Reporter: Gerard Krupa
> Attachments: gjkrupa_envers_problem.zip
>
>
> We have a parent-child relationship set up for an entity using a plain link table. This is annotated with @JoinTable and @AuditJoinTable so there is no entity for the link table itself. The definition looks something like this...
>
> @Entity
> @Table(name = "BKG_BKCM_BKG_CMPT")
> @Audited
> public class BookingComponent implements Serializable {
> @ManyToOne(fetch = FetchType.LAZY, optional = true)
> @AuditJoinTable(name = "BKG_BKCMR_REL_AUD", inverseJoinColumns = { @JoinColumn(name = "BKCM_ID_PARENT", nullable = true, updatable = false) })
> @JoinTable(name = "BKG_BKCMR_REL", joinColumns = { @JoinColumn(name = "BKCM_ID_CHILD", nullable = true, updatable = false) }, inverseJoinColumns = { @JoinColumn(name = "BKCM_ID_PARENT", nullable = true, updatable = false) })
> private BookingComponent parent;
> @OneToMany(mappedBy = "parent")
> private List<BookingComponent> children;
> }
>
> We've found two issues. Firstly, when we try to retrieve a previous revision of these entities (they in turn are held in a collection in a container entity) using List<>.size() Envers seems to be constructing a JPQL query using the link table's table name which isn't valid JPQL resulting in the following exception:
> org.hibernate.hql.ast.QuerySyntaxException: BKG_BKCMR_REL_AUD is not mapped [select new list(ee, e) from BKG_BKCMR_REL_AUD ee, *package-name-omitted*.BookingComponent_AUD e where ee.originalId.BookingComponent_id = e.originalId.id and ee.originalId.children_id = :children_id and e.originalId.rev_id.id <= :revision and ee.originalId.rev_id.id <= :revision and ee.rev_type != :delrevisiontype and e.rev_type != :delrevisiontype and (e.REV_ID_END.id > :revision or e.REV_ID_END is null) and (ee.REV_ID_END.id > :revision or ee.REV_ID_END is null)]
> at org.hibernate.hql.ast.util.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.java:180)
> at org.hibernate.hql.ast.tree.FromElementFactory.addFromElement(FromElementFactory.java:111)
> at org.hibernate.hql.ast.tree.FromClause.addFromElement(FromClause.java:93)
> at org.hibernate.hql.ast.HqlSqlWalker.createFromElement(HqlSqlWalker.java:327)
> at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3441)
> at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:3325)
> at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:733)
> at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:584)
> at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:301)
> at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:244)
> at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:254)
> at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:185)
> at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
> at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
> at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
> at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:124)
> at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)
> at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)
> at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1770)
> at org.hibernate.envers.entities.mapper.relation.query.TwoEntityQueryGenerator.getQuery(TwoEntityQueryGenerator.java:128)
> at org.hibernate.envers.entities.mapper.relation.lazy.initializor.AbstractCollectionInitializor.initialize(AbstractCollectionInitializor.java:62)
> at org.hibernate.envers.entities.mapper.relation.lazy.proxy.CollectionProxy.checkInit(CollectionProxy.java:50)
> at org.hibernate.envers.entities.mapper.relation.lazy.proxy.CollectionProxy.size(CollectionProxy.java:55)
>
> We've also noticed that the audit entries for the link table have a null REV_ID_END despite there being multiple revisions.
> See attached gjkrupa_envers_problem.zip for a test case that demonstrates this issue.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the hibernate-issues
mailing list