Hi Forum,

I have a big table need to go though and process timeout, if it's timeout, I want to delete. I'm using scrollable result to process data, but scrollable result do not support remove, so I delete object from session. But now I'm getting exception:
org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1

My understand is: this is because delete data is not tough result set on scrollable. So, I'm wandering if there is a way to delete row from scrollable result just like Iterator?

Thanks

Noodle