Java Hibernate HQL can't specify target table

Question

I was reading the Post from user @JB Nizet

Hibernate Exception on MySQL Cross Join Query

Later i have try my own code

I have a HQL like this.

update Student set newField='newField',anotherFieldsToBeUpdated where .... 
and id in
(select s.id from Student s where s.school=:school)
-->[Student->School]many to one relationship....

But still throws the infamous

Caused by: java.sql.SQLException: You can't specify target table 'Student' for update in FROM clause

I was wondering if still exists a solution without using another different select or use a temporal table.

Can you tell in words what is your query purpose? And what is the relationship between Student and School? — MaxZoom
– MaxZoom, Commented Feb 24, 2015 at 16:05

MaxZoom · Accepted Answer · 2015-02-24 15:55:47Z

1

When you access just one and the same table you can combine your limitation together:

update Student set newField = :newField where ... and school = :school

edited Feb 24, 2015 at 15:55

answered Feb 23, 2015 at 23:38

MaxZoom

7,7635 gold badges30 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

MaxZoom Over a year ago

Glad I could help. In case you need more info, refer to the HQL specification.

Collectives™ on Stack Overflow

Java Hibernate HQL can't specify target table

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related