How to use Batch Process SELECT Statement in Hibernate for Native SQL
posted 2 years ago
When the query returns more than 1500 records , I want to chunk up the requests into multiple requests of 1500 each. How can we achieve this using Hibernate ScrollableResults or similar for native SQL query used in createSQLQuery ?
I have tried using simple technique but need more input on how we can use Hibernate ScrollableResults for Native SQL batch select records