[JIRA] Created: (CAY-545) Paginated list - connection is committed before the result set is read

From: Andrus Adamchik (JIRA) ("Andrus)
Date: Mon May 08 2006 - 17:16:31 EDT

Next message: Jean T. Anderson: "[admin] May incubator report"

Previous message: Tomas Jucius: "Re: Proposal for the project "Support for full text search in Cayenne""
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

Next message: Jean T. Anderson: "[admin] May incubator report"
Previous message: Tomas Jucius: "Re: Proposal for the project "Support for full text search in Cayenne""
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This archive was generated by hypermail 2.0.0 : Mon May 08 2006 - 17:17:14 EDT