Is CURSOR concept available in Hibernate?

siva.nrpm · **Joined:** Wed Jun 11, 2008 9:54 am **Posts:** 3

please help me on this..

hicnar · **Joined:** Sun Jun 20, 2004 7:41 am **Posts:** 7

Code:

Query q = session.createQuery("from your.package.ClassName cn where cn.property = \"foo\"");

for(ClassName object : (List<ClassName>)q.list()) {
  // process your objects
}

Alternatively you can use the Query.iterate() method that will return an instance of Iterator to the collection of objects returned by your query.

hope this helps

K.

Cameron McKenzie · **Posted:** Wed Jun 11, 2008 1:03 pm

As hincar said, you can certainly obtain a list of results, and loop through those results at your leisure. But is that what you were looking for with regards to using a Cursor?

More specifically, what type of functionality that you are using now with your cursor do you need?