scrollableresults

Using setFirstResult and setMaxResults is your only option that I’m aware of. Traditionally a scrollable resultset would only transfer rows to the client on an as required basis. Unfortunately the MySQL Connector/J actually fakes it, it executes the entire query and transports it to the client, so the driver actually has the entire result set … Read more