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

Reply via email to