[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-7093) ValidityAuditStrategy causes Exception with Postgres and deep subclass hierarchy

[Thomas Mäder (JIRA)]

    [ https://hibernate.onjira.com/browse/HHH-7093?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=45567#comment-45567 ] 

Thomas Mäder commented on HHH-7093:
-----------------------------------

And the exception is: 

Caused by: org.postgresql.util.PSQLException: ERROR: SELECT FOR UPDATE/SHARE cannot be applied to the nullable side of an Outer join
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122)


> ValidityAuditStrategy causes Exception with Postgres and deep subclass hierarchy
> --------------------------------------------------------------------------------
>
>                 Key: HHH-7093
>                 URL: https://hibernate.onjira.com/browse/HHH-7093
>             Project: Hibernate ORM
>          Issue Type: Bug
>          Components: envers
>    Affects Versions: 4.1.0
>         Environment: Postgres 9.1
>            Reporter: Thomas Mäder
>         Attachments: EnversTest01.zip
>
>
> When I have a subclass of a subclass and a joined inheritance strategy, envers throws an exception when updating an entity. The attached Eclispse/Maven project contains a runing test case.
> The default audit strategy works fine.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira