You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by "Michael Dick (JIRA)" <ji...@apache.org> on 2011/02/18 15:37:38 UTC
[jira] Created: (OPENJPA-1944) Extra select statements executed
when version column is null.
Extra select statements executed when version column is null.
--------------------------------------------------------------
Key: OPENJPA-1944
URL: https://issues.apache.org/jira/browse/OPENJPA-1944
Project: OpenJPA
Issue Type: Bug
Affects Versions: 1.2.2, 2.1.0
Reporter: Michael Dick
Assignee: Michael Dick
Fix For: 2.2.0
This problem was originally reported on the users mailing list by Diego Cattelan. Link to the thread :http://openjpa.208410.n2.nabble.com/N-query-problem-with-Version-td6027619.html
The problem occurs if a null value is returned for an entity's version field. In this case OpenJPA will issue a second select statement to re-fetch the version, potentially resulting in a lot of repetitive SQL statements.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (OPENJPA-1944) Extra select statements executed
when version column is null.
Posted by "Rick Curtis (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-1944?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Curtis updated OPENJPA-1944:
---------------------------------
Fix Version/s: 2.1.1
> Extra select statements executed when version column is null.
> --------------------------------------------------------------
>
> Key: OPENJPA-1944
> URL: https://issues.apache.org/jira/browse/OPENJPA-1944
> Project: OpenJPA
> Issue Type: Bug
> Affects Versions: 1.2.2, 2.1.0
> Reporter: Michael Dick
> Assignee: Rick Curtis
> Fix For: 2.1.1, 2.2.0
>
>
> This problem was originally reported on the users mailing list by Diego Cattelan. Link to the thread :http://openjpa.208410.n2.nabble.com/N-query-problem-with-Version-td6027619.html
> The problem occurs if a null value is returned for an entity's version field. In this case OpenJPA will issue a second select statement to re-fetch the version, potentially resulting in a lot of repetitive SQL statements.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Resolved: (OPENJPA-1944) Extra select statements executed
when version column is null.
Posted by "Michael Dick (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-1944?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Michael Dick resolved OPENJPA-1944.
-----------------------------------
Resolution: Fixed
> Extra select statements executed when version column is null.
> --------------------------------------------------------------
>
> Key: OPENJPA-1944
> URL: https://issues.apache.org/jira/browse/OPENJPA-1944
> Project: OpenJPA
> Issue Type: Bug
> Affects Versions: 1.2.2, 2.1.0
> Reporter: Michael Dick
> Assignee: Michael Dick
> Fix For: 2.2.0
>
>
> This problem was originally reported on the users mailing list by Diego Cattelan. Link to the thread :http://openjpa.208410.n2.nabble.com/N-query-problem-with-Version-td6027619.html
> The problem occurs if a null value is returned for an entity's version field. In this case OpenJPA will issue a second select statement to re-fetch the version, potentially resulting in a lot of repetitive SQL statements.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Assigned] (OPENJPA-1944) Extra select statements executed
when version column is null.
Posted by "Rick Curtis (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-1944?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Curtis reassigned OPENJPA-1944:
------------------------------------
Assignee: Rick Curtis (was: Michael Dick)
> Extra select statements executed when version column is null.
> --------------------------------------------------------------
>
> Key: OPENJPA-1944
> URL: https://issues.apache.org/jira/browse/OPENJPA-1944
> Project: OpenJPA
> Issue Type: Bug
> Affects Versions: 1.2.2, 2.1.0
> Reporter: Michael Dick
> Assignee: Rick Curtis
> Fix For: 2.2.0
>
>
> This problem was originally reported on the users mailing list by Diego Cattelan. Link to the thread :http://openjpa.208410.n2.nabble.com/N-query-problem-with-Version-td6027619.html
> The problem occurs if a null value is returned for an entity's version field. In this case OpenJPA will issue a second select statement to re-fetch the version, potentially resulting in a lot of repetitive SQL statements.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (OPENJPA-1944) Extra select statements executed
when version column is null.
Posted by "Rick Curtis (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-1944?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13009732#comment-13009732 ]
Rick Curtis commented on OPENJPA-1944:
--------------------------------------
The previous change that Mike committed causes an OLE if an Entity with a null version is updated. The change I'm going to commit shortly here reverts the previous commit and looks to see if a null version field has been loaded before going back to the DB.
> Extra select statements executed when version column is null.
> --------------------------------------------------------------
>
> Key: OPENJPA-1944
> URL: https://issues.apache.org/jira/browse/OPENJPA-1944
> Project: OpenJPA
> Issue Type: Bug
> Affects Versions: 1.2.2, 2.1.0
> Reporter: Michael Dick
> Assignee: Rick Curtis
> Fix For: 2.2.0
>
>
> This problem was originally reported on the users mailing list by Diego Cattelan. Link to the thread :http://openjpa.208410.n2.nabble.com/N-query-problem-with-Version-td6027619.html
> The problem occurs if a null value is returned for an entity's version field. In this case OpenJPA will issue a second select statement to re-fetch the version, potentially resulting in a lot of repetitive SQL statements.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Closed] (OPENJPA-1944) Extra select statements executed
when version column is null.
Posted by "Albert Lee (Closed) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-1944?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Albert Lee closed OPENJPA-1944.
-------------------------------
Close issue in preparation for 2.2.0 release.
> Extra select statements executed when version column is null.
> --------------------------------------------------------------
>
> Key: OPENJPA-1944
> URL: https://issues.apache.org/jira/browse/OPENJPA-1944
> Project: OpenJPA
> Issue Type: Bug
> Affects Versions: 1.2.2, 2.1.0
> Reporter: Michael Dick
> Assignee: Rick Curtis
> Fix For: 2.1.1, 2.2.0
>
>
> This problem was originally reported on the users mailing list by Diego Cattelan. Link to the thread :http://openjpa.208410.n2.nabble.com/N-query-problem-with-Version-td6027619.html
> The problem occurs if a null value is returned for an entity's version field. In this case OpenJPA will issue a second select statement to re-fetch the version, potentially resulting in a lot of repetitive SQL statements.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Resolved] (OPENJPA-1944) Extra select statements executed
when version column is null.
Posted by "Rick Curtis (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-1944?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Curtis resolved OPENJPA-1944.
----------------------------------
Resolution: Fixed
Checked changes into 2.1.x and trunk
> Extra select statements executed when version column is null.
> --------------------------------------------------------------
>
> Key: OPENJPA-1944
> URL: https://issues.apache.org/jira/browse/OPENJPA-1944
> Project: OpenJPA
> Issue Type: Bug
> Affects Versions: 1.2.2, 2.1.0
> Reporter: Michael Dick
> Assignee: Rick Curtis
> Fix For: 2.1.1, 2.2.0
>
>
> This problem was originally reported on the users mailing list by Diego Cattelan. Link to the thread :http://openjpa.208410.n2.nabble.com/N-query-problem-with-Version-td6027619.html
> The problem occurs if a null value is returned for an entity's version field. In this case OpenJPA will issue a second select statement to re-fetch the version, potentially resulting in a lot of repetitive SQL statements.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Work started: (OPENJPA-1944) Extra select statements
executed when version column is null.
Posted by "Michael Dick (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-1944?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Work on OPENJPA-1944 started by Michael Dick.
> Extra select statements executed when version column is null.
> --------------------------------------------------------------
>
> Key: OPENJPA-1944
> URL: https://issues.apache.org/jira/browse/OPENJPA-1944
> Project: OpenJPA
> Issue Type: Bug
> Affects Versions: 1.2.2, 2.1.0
> Reporter: Michael Dick
> Assignee: Michael Dick
> Fix For: 2.2.0
>
>
> This problem was originally reported on the users mailing list by Diego Cattelan. Link to the thread :http://openjpa.208410.n2.nabble.com/N-query-problem-with-Version-td6027619.html
> The problem occurs if a null value is returned for an entity's version field. In this case OpenJPA will issue a second select statement to re-fetch the version, potentially resulting in a lot of repetitive SQL statements.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Reopened] (OPENJPA-1944) Extra select statements executed
when version column is null.
Posted by "Rick Curtis (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-1944?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Curtis reopened OPENJPA-1944:
----------------------------------
Reopening this JIRA as it needs a bit more work.
> Extra select statements executed when version column is null.
> --------------------------------------------------------------
>
> Key: OPENJPA-1944
> URL: https://issues.apache.org/jira/browse/OPENJPA-1944
> Project: OpenJPA
> Issue Type: Bug
> Affects Versions: 1.2.2, 2.1.0
> Reporter: Michael Dick
> Assignee: Rick Curtis
> Fix For: 2.2.0
>
>
> This problem was originally reported on the users mailing list by Diego Cattelan. Link to the thread :http://openjpa.208410.n2.nabble.com/N-query-problem-with-Version-td6027619.html
> The problem occurs if a null value is returned for an entity's version field. In this case OpenJPA will issue a second select statement to re-fetch the version, potentially resulting in a lot of repetitive SQL statements.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira