Hi,

I'm a newbie in Hibernate. We are using Hibernate with Spring. As per our requirement, we may have to fetch upto 100K records in one transaction.

I would greatly appreciate if someone can advise me on the best approach for this.

1. HibernateTemplate / JDBCTemplate is the better option?

2. Since a List is returned, will it cause any Memory exception for large volume of records.

3. How effectively we can call stored procedures from hibernate?

Any help would be highly appreciated.

Thanks
Sara.