Cursor « Query « JPA Q&A





1. How do I implement Hibernate Pagination using a cursor (so the results stay consistent, despite new data being added to the table being paged)?    stackoverflow.com

Hey all, Is there any way to maintain a database cursor using Hibernate between web requests? Basically, I'm trying to implement pagination, but the data that is being paged is consistently changing ...

2. Quartz + Hibernate + MSSql Server = FOR UPDATE clause allowed only for DECLARE CURSOR    stackoverflow.com

I am trying to run a job with a MS Sql Server select (just need to read something off the database), but I am getting the error when I restart the ...

3. JPA Queries Open Cursors    coderanch.com

Hello All, I am running into a problem with very many open cursors. I am running close to 200 database queries very quickly to fetch data. The database is configured to handle up to 300 open cursors at a time. Over time, I am getting stack traces saying that I have reached the maximum amount of open cursors possible. I searched ...

4. Scrollable Cursors    forum.hibernate.org

5. Query API : iterate causes Maximum Open Cursors exception    forum.hibernate.org

Exactly, I do not close session after calling iterate on the Query interface. My object session is used only by one thread and it is a batch. I think I could use always the same session for all treatments in my batch as I do not know when I can close it because of lazy initialization. I perform select queries and ...