Hibernate Community • View topic - How can I update a certain number of rows using mySql?

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

How can I update a certain number of rows using mySql?

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

creon79

Post subject: How can I update a certain number of rows using mySql?

Posted: Tue Jun 01, 2010 11:15 am

Newbie

Joined: Tue Jun 01, 2010 11:09 am
Posts: 3

Hi all,
I have a problem doing the following update:

UPDATE Esbinteraction e SET e.owner = :owner WHERE e.label = :label and e.owner = 0 and status = :status limit :count

I'm using mySql, but that query doesn't work cause hibernate doesn't know limit token, while, with oracle, i could use the queryString

UPDATE Esbinteraction e SET e.owner = :owner WHERE e.label = :label and e.owner = 0 and status = :status and rownum<:count

without any problems.
How can i do the same with mySql?
Thanks a lot.
Danilo

Top

creon79

Post subject: Re: How can I update a certain number of rows using mySql?

Posted: Thu Jun 03, 2010 4:55 am