Paginated list - connection is committed before the result set is read

It looks like Cayenne commits a connection when running an iterated query BEFORE the iterated result is processed. I was able to reproduce this on Ingres, but I believe the issue is universal and under certain circumstances (i.e. larger page size) it will show on other databases as well.

I already have a fix - wrap iterated queries in manual transactions.