Hibernate Community • View topic - HQL

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

HQL - subquery with update

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

apophysis

Post subject: HQL - subquery with update

Posted: Fri Feb 22, 2008 5:45 am

Newbie

Joined: Tue Oct 30, 2007 5:41 am
Posts: 2

I get a NullPointer exception for the following HQL statement:

Code:

update BI$pricing p set p.isDeleted = 'P' where p.id in 
  (select p.id from BI$pricing p join p.folder f 
   where f.contextId = :folderBoId 
     and p.contextId = :pricingBoId 
     and p.isDeleted = 'N' 
     and f.isDeleted = 'N')

Is this not supported in hibernate 3.2.2?

regards

Top

paragb

Post subject:

Posted: Fri Feb 22, 2008 7:20 am

Newbie

Joined: Fri Feb 22, 2008 4:54 am
Posts: 1

I will suggest providing error stack trace and piece of code executing this HQL to the forum.

Just a few wild guesses:
1. UPDATE HQL should be executed with Query.executeUpdate() method. Verify if you are doing the same.
2. Use a different alias in subquery to refer 'BI$pricing' entity to make it different from that used in parent query for example say 'q' instead of 'p'.

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum