[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-3590) Having @version in Parent causes wrong HQL update when updating subclass in Joined Subclass Inheritance Strategy.

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3590?page=c... ] Julien roche commented on HHH-3590: ----------------------------------- Hi guys, I've got a similar problem with a bulk insert in HQL : I've got a joined table. The parent is JoinedEntityA (which is abstract and has got the version column), JoinedEntityB and JoinedEntity inherit from JoinedEntityA. I want to replace some JoinedEntityB with JoinedEntityC, I will execute the following code : Session session = sessionFactory.getCurrentSession(); session.createQuery("insert into JoinedEntityC(number, id) select 5, id from JoinedEntityB").executeUpdate(); session.createSQLQuery("delete from JoinedEntityB"); However, the following exception will be raised: org.hibernate.exception.SQLGrammarException: could not execute update query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67) at ... ... Caused by: java.sql.SQLException: Column not found: VERSION in statement [insert into JoinedEntityC ( version, number ) select ?, 5 as col_0_0_ from JoinedEntityB joinedenti0_ inner join JoinedEntityA joinedenti0_1_ on joinedenti0_.id=joinedenti0_1_.id] at org.hsqldb.jdbc.Util.throwError(Unknown Source) at ... ... I find a 'workaround' : in the class org.hibernate.hql.ast.HqlSqlWalker, into the postProcessInsert method, I've inserted the following code: final boolean includeVersionProperty = persister.isVersioned() && !insertStatement.getIntoClause().isExplicitVersionInsertion() && persister.isVersionPropertyInsertable(); /*--- Start Fix ---*/ Boolean versionColumnOnTable = true; if(persister instanceof JoinedSubclassEntityPersister){ // the version column is on this table or on parents ? // maybe we must override isVersionPropertyInsertable into // JoinedSubclassEntityPersister to return false ? versionColumnOnTable = ((JoinedSubclassEntityPersister) persister).getPropertyTableName( persister.getPropertyNames()[persister.getVersionProperty()]).equalsIgnoreCase(persister.getTableName()); } /*--- End Fix ---*/ if ( includeVersionProperty && versionColumnOnTable) { ... I don't find a good way to check if the version column is on the current table or on the parent table. Maybe there are some methods, but I didn't find them. An Eclipse project with the error is attached with this issue and an other Eclipse project with the 'patch'. Warning : that's solved only the insert case, not the update. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira