Hibernate Community • View topic - Does Hibernate allow this: Sequential execution of SQL

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Does Hibernate allow this: Sequential execution of SQL

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

vinayb

Post subject: Does Hibernate allow this: Sequential execution of SQL

Posted: Thu Feb 11, 2010 3:38 pm

Beginner

Joined: Thu May 28, 2009 10:25 am
Posts: 21

I have a requirement to achieve something like this (pseudocode follows)

Code:

Prepare Statement (select id from from tableX)
while hasResult 
 getNextResult(execute SQL statement to get next id)

Close statement

The Hibernate query iterator does something similar but gets all the ids initially . I'd like to have the underlying jdbc driver or the database know which id to fetch next.

Top

nordborg

Post subject: Re: Does Hibernate allow this: Sequential execution of SQL

Posted: Thu Feb 11, 2010 5:46 pm

Expert

Joined: Wed Mar 03, 2004 6:35 am
Posts: 1240
Location: Lund, Sweden

Query.scroll()?

From the javadoc of the ScrollableResults class:

Quote:

The Query / ScrollableResults pattern is very similar to the JDBC PreparedStatement/ ResultSet pattern....

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