[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-1657?page=c...
]
Paul Giblock commented on HHH-1657:
-----------------------------------
I am affected by this problem as well. A simple "update Child c set c.field = value
where c.id in (:cids)" is causing the issue. In this case, the c.id field is the
super class's Id.
I am updating 100 or so records. It sucks having to go back to SQL, and it is even worse
having to do 100+ queries when individually merging the records.
It is almost insulting that a bug like this would be left open for over three years. If
Hibernate cannot support simple updates, then the executeUpdate() function should just be
removed.
hql update generate wrong sql with joined subclass hierarcy
-----------------------------------------------------------
Key: HHH-1657
URL:
http://opensource.atlassian.com/projects/hibernate/browse/HHH-1657
Project: Hibernate Core
Issue Type: Bug
Components: query-hql
Environment: Hibernate 3.2.0cr1, Hibernate 3.1.3
Reporter: Alexey Romanchuk
Assignee: Gail Badner
Let suppose that we have two joined subclass entities: Parent (id PK) and Child (id PK)
that mapped with joined subclass method.
When I try to update Child by id with hql:
update Child c set c.field = 'value' where c.id = 1234
hibernate generates joined tables like
insert into HT_parent select child0_.id as id from child child0_ inner join parent
child0_1_ on child0_.id=child0_1_.id wher id in = 1234
look at last condition. hibernate use id WITH OUT tables alias that cause sql exception:
column reference "id" is ambiguous
--
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