Hibernate Community • View topic - Using Update HQL to update an entire object

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Using Update HQL to update an entire object

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

willpugh

Post subject: Using Update HQL to update an entire object

Posted: Thu Sep 22, 2011 8:41 pm

Newbie

Joined: Thu Sep 22, 2011 5:21 pm
Posts: 2

I'm trying to do a conditional update where my code looks something like:

Code:

final String hql   = "update myClass obj set obj = :obj where obj.id=:id and obj.hash=:hash";
final Query query = txn.getSession().createQuery(hql);
query.setParameter("obj", myObject)
                        .setInteger("id", myObject.getId())
                        .setLong("hash",  initialHash);
int updatedRecords = query.executeUpdate();

This does the conditional part just fine, but the

Code:

set obj = :obj

part gets turned into the sql

Code:

set idGroup=?

Is there a way for me to have

Code:

set obj = :obj

set the entire object? is there some other grammar to do so?

Thanks.

Top

willpugh

Post subject: Re: Using Update HQL to update an entire object

Posted: Mon Oct 03, 2011 11:57 am

Newbie

Joined: Thu Sep 22, 2011 5:21 pm
Posts: 2

No reply yet. Is there a better way to do this? Is there some other Type that I can use explicitly in the parameter to have the full object persisted instead of the ID?

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