Presently i am facing a problem with hibernate, that is "i am not able to retrieve more than 75k records using hibernate from database." if any one facing the same problem and if they have any alternative solution for that, then please help me.

Is this a hard stop at exactly 75k, or at approximately 75k.

What happens at this point? Is there a checked exception? A runtime exception? Is there a message that tells you what has gone wrong, or does the program simply hang/stop/exit?

What database are you using? How much memory is your JVM consuming? Can the hardware handle this many records?

i'm sorry. it is only approximately 7.5k(7500) records. i'm using MyISAM database. i got Out of memory error in the hibernate component.