hibernate with sql

upendra@soft9.in · **Posted:** Fri Oct 27, 2006 2:29 am

Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

Problems with Session and transaction handling?

Read this: http://hibernate.org/42.html

BullEarwig · **Posted:** Fri Oct 27, 2006 10:53 am

My favorite link is here:
http://opensource.atlassian.com/projects/hibernate/browse/HHH-1538

It describes HQL which is a lot like SQL, but more powerful.

There's always multiple ways to do things in Hibernate. Once I have a Session, I have had good luck doing the following:

Code:

Query query = session.createQuery(hqlText);

// Really fast way to get row count:
ScrollableResults scrollableResult = query.scroll();
if (scrollableResult.last()) {
   rowCount = scrollableResult.getRowNumber() + 1;
}
else {
   rowCount = 0;
}
scrollableResult.close();

To get result set:

Code:

List list = query.list();

Before doing the above, you can use Hibernate's powerful pagination support like this:

Code:

query.setFirstResult(firstRowIndex);
query.setMaxResults(maxRowsToFetch);