Mailing-List: contact jdo-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: jdo-dev@db.apache.org
Message-ID: <675912758.1235152261935.JavaMail.jira@brutus>
Date: Fri, 20 Feb 2009 09:51:01 -0800 (PST)
From: "Craig Russell (JIRA)" <jira@apache.org>
To: jdo-dev@db.apache.org
Subject: [jira] Commented: (JDO-624) Query behaviour independent of
 transactional boundaries
In-Reply-To: <1407215458.1234959064369.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/JDO-624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12675411#action_12675411 ] 

Craig Russell commented on JDO-624:
-----------------------------------

This request seems to affect several areas of the specification, including optimistic vs. datastore transaction, transaction isolation level, and for JDBC implementations of JDO, the handling of the JDBC connection and statement holdability across commit.

I think a bit more behavior needs to be specified than a note in 14.3. Could you please be more specific as to what the behavior should be?

> Query behaviour independent of transactional boundaries
> -------------------------------------------------------
>
>                 Key: JDO-624
>                 URL: https://issues.apache.org/jira/browse/JDO-624
>             Project: JDO
>          Issue Type: Bug
>    Affects Versions: JDO 2 maintenance release 2
>            Reporter: Christiaan
>
> (see also http://www.nabble.com/NonTransactionalRead---Query-Fetchplan-to19875446.html)
> I have a question about the behaviour of Queries after a commit when "NonTransactionalRead" is set to true. Should a Query behave like it did before the commit? More specifically, when defining a fetchsize in the FetchPlan I would like to see that the Query is still honouring this fetchsize after a commit is given.This behaviour is not explicitly described in the specification.
> The scenario I am working with is as such: 
> I have set NonTransactionRead=true and Multithreaded=true. I have 1 pm, and 2 threads. Thread 1 performs reads (executing queries with large result set) and Thread 2 performs writes. Now when I am iterating over a large query in Thread 1 and Thread 2 is doing a commit, I don't want this to affect the iterating over the query in Thread 1. 
> My proposal would be that the behaviour of the query should be unchanged by a commit(). For me this currently a portability issue, since our application depend on the fact that the query behaves the same. May be the following note to 14.3 Architecture of Query would be sufficient: 
> "The behaviour of a query should not depend on transactional boundaries"? 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.