GeeCON Prague 2014*
The moose likes Object Relational Mapping and the fly likes HQL update query problem. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "HQL update query problem." Watch "HQL update query problem." New topic
Author

HQL update query problem.

Nagendra Shastry
Greenhorn

Joined: Oct 26, 2010
Posts: 19

I have 2 tables Asset and Asset_Dist_Types. Asset is parent and Asset_Dist_Types is a child table. Asset_Dist_Types is having 2 columns asset_id and lkp_dist_type where asset_id is the primary key in Asset table. In Asset_Dist_Types it is a many to many (one asset_id can have multiple lkp_dist_type entries.) In java, we have entity class only for Asset table. In that for Asset_Dist_Type, they have mentioned it as collection of elements. In Asset.java, entry for Asset_Dist_Type is as follows.



Now I would like to update Asset_Dist_Type table's lkp_dist_type column. I have list of asset id's. I have written following query to update it.



But this is throwing



Since I am new to hibernate I am not getting what is the solution. Can someone please help me?

 
GeeCON Prague 2014
 
subject: HQL update query problem.