Paginated list - connection is committed before the result set is read
----------------------------------------------------------------------
Key: CAY-545
URL: http://issues.apache.org/cayenne/browse/CAY-545
Project: Cayenne
Type: Bug
Components: Cayenne Core Library
Versions: 1.2 [BETA]
Reporter: Andrus Adamchik
Assigned to: Andrus Adamchik
Fix For: 1.2 [BETA]
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.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/cayenne/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira