Hibernate Community • View topic - Update query for multiple columns

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Update query for multiple columns

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

Metalhead

Post subject: Update query for multiple columns

Posted: Mon Jan 21, 2008 6:08 am

Newbie

Joined: Tue Feb 27, 2007 3:58 am
Posts: 5
Location: Netherlands

I have a small question, but I can't seem to find the answer;
I want to change two columns in one query, but I don't know the right syntax...
The columns are Float-values.

Code:

String hql = "update Location set longitude=NULL, latitude=NULL where longitude = '0' or latitude = '0'";
session.createQuery(hql).executeUpdate();
session.flush();
session.close();

There is no error-message, it says it updated a lot of rows, but nothing really changes in the database...

Top

Page 1 of 1

[ 1 post ]

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