You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by "Guido Mueller (JIRA)" <ji...@apache.org> on 2011/02/17 11:29:24 UTC
[jira] Created: (OPENJPA-1941) Criteria query returns wrong result
when query cache is enabled
Criteria query returns wrong result when query cache is enabled
---------------------------------------------------------------
Key: OPENJPA-1941
URL: https://issues.apache.org/jira/browse/OPENJPA-1941
Project: OpenJPA
Issue Type: Bug
Components: datacache, jpa
Affects Versions: 2.0.1
Environment: The issue was detected when using a criteria query against Oracle database.
Reporter: Guido Mueller
When query cache is not enabled the queries return these lines: Query 1: 1 Query 2: 2 This is correct.
When query cache is enabled the queries return these lines: Query 1: 1 Query 2: 1 This is wrong.
See attached test case (Netbeans project). ojdbc14.jar and openjpa-all-2.0.1.jar must be added to the project.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (OPENJPA-1941) Criteria query returns wrong
result when query cache is enabled
Posted by "Guido Mueller (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-1941?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12995747#comment-12995747 ]
Guido Mueller commented on OPENJPA-1941:
----------------------------------------
The problem also occurs with EHCache is enabled instead of the the native OpenJPA cache.
> Criteria query returns wrong result when query cache is enabled
> ---------------------------------------------------------------
>
> Key: OPENJPA-1941
> URL: https://issues.apache.org/jira/browse/OPENJPA-1941
> Project: OpenJPA
> Issue Type: Bug
> Components: datacache, jpa
> Affects Versions: 2.0.1
> Environment: The issue was detected when using a criteria query against Oracle database.
> Reporter: Guido Mueller
> Attachments: JpaCriteriaQueryCacheIssue.zip, jpacriteriaquerycacheissue.sql
>
>
> When query cache is not enabled the queries return these lines: Query 1: 1 Query 2: 2 This is correct.
> When query cache is enabled the queries return these lines: Query 1: 1 Query 2: 1 This is wrong.
> See attached test case (Netbeans project). ojdbc14.jar and openjpa-all-2.0.1.jar must be added to the project.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (OPENJPA-1941) Criteria query returns wrong
result when query cache is enabled
Posted by "Michael Dick (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-1941?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12999063#comment-12999063 ]
Michael Dick commented on OPENJPA-1941:
---------------------------------------
Thanks for letting us know - I'll see if I can track down the change that fixed it.
> Criteria query returns wrong result when query cache is enabled
> ---------------------------------------------------------------
>
> Key: OPENJPA-1941
> URL: https://issues.apache.org/jira/browse/OPENJPA-1941
> Project: OpenJPA
> Issue Type: Bug
> Components: datacache, jpa
> Affects Versions: 2.0.1, 2.0.2, 2.1.0
> Environment: The issue was detected when using a criteria query against Oracle database.
> Reporter: Guido Mueller
> Assignee: Michael Dick
> Fix For: 2.2.0
>
> Attachments: JpaCriteriaQueryCacheIssue.zip, jpacriteriaquerycacheissue.sql
>
>
> When query cache is not enabled the queries return these lines: Query 1: 1 Query 2: 2 This is correct.
> When query cache is enabled the queries return these lines: Query 1: 1 Query 2: 1 This is wrong.
> See attached test case (Netbeans project). ojdbc14.jar and openjpa-all-2.0.1.jar must be added to the project.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (OPENJPA-1941) Criteria query returns wrong result
when query cache is enabled
Posted by "Guido Mueller (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-1941?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Guido Mueller updated OPENJPA-1941:
-----------------------------------
Affects Version/s: 2.1.0
> Criteria query returns wrong result when query cache is enabled
> ---------------------------------------------------------------
>
> Key: OPENJPA-1941
> URL: https://issues.apache.org/jira/browse/OPENJPA-1941
> Project: OpenJPA
> Issue Type: Bug
> Components: datacache, jpa
> Affects Versions: 2.0.1, 2.1.0
> Environment: The issue was detected when using a criteria query against Oracle database.
> Reporter: Guido Mueller
> Attachments: JpaCriteriaQueryCacheIssue.zip, jpacriteriaquerycacheissue.sql
>
>
> When query cache is not enabled the queries return these lines: Query 1: 1 Query 2: 2 This is correct.
> When query cache is enabled the queries return these lines: Query 1: 1 Query 2: 1 This is wrong.
> See attached test case (Netbeans project). ojdbc14.jar and openjpa-all-2.0.1.jar must be added to the project.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (OPENJPA-1941) Criteria query returns wrong
result when query cache is enabled
Posted by "Guido Mueller (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-1941?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13025187#comment-13025187 ]
Guido Mueller commented on OPENJPA-1941:
----------------------------------------
I can acknowledge the problem is fixed in 2.1.0 final. One issue may be that 2.1.0 is officially supported only with JDK 6.
> Criteria query returns wrong result when query cache is enabled
> ---------------------------------------------------------------
>
> Key: OPENJPA-1941
> URL: https://issues.apache.org/jira/browse/OPENJPA-1941
> Project: OpenJPA
> Issue Type: Bug
> Components: datacache, jpa
> Affects Versions: 2.0.1, 2.0.2
> Environment: The issue was detected when using a criteria query against Oracle database.
> Reporter: Guido Mueller
> Assignee: Michael Dick
> Fix For: 2.1.0, 2.2.0
>
> Attachments: JpaCriteriaQueryCacheIssue.zip, jpacriteriaquerycacheissue.sql
>
>
> When query cache is not enabled the queries return these lines: Query 1: 1 Query 2: 2 This is correct.
> When query cache is enabled the queries return these lines: Query 1: 1 Query 2: 1 This is wrong.
> See attached test case (Netbeans project). ojdbc14.jar and openjpa-all-2.0.1.jar must be added to the project.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (OPENJPA-1941) Criteria query returns wrong result
when query cache is enabled
Posted by "Guido Mueller (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-1941?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Guido Mueller updated OPENJPA-1941:
-----------------------------------
Fix Version/s: 2.2.0
Affects Version/s: 2.0.2
> Criteria query returns wrong result when query cache is enabled
> ---------------------------------------------------------------
>
> Key: OPENJPA-1941
> URL: https://issues.apache.org/jira/browse/OPENJPA-1941
> Project: OpenJPA
> Issue Type: Bug
> Components: datacache, jpa
> Affects Versions: 2.0.1, 2.0.2, 2.1.0
> Environment: The issue was detected when using a criteria query against Oracle database.
> Reporter: Guido Mueller
> Fix For: 2.2.0
>
> Attachments: JpaCriteriaQueryCacheIssue.zip, jpacriteriaquerycacheissue.sql
>
>
> When query cache is not enabled the queries return these lines: Query 1: 1 Query 2: 2 This is correct.
> When query cache is enabled the queries return these lines: Query 1: 1 Query 2: 1 This is wrong.
> See attached test case (Netbeans project). ojdbc14.jar and openjpa-all-2.0.1.jar must be added to the project.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (OPENJPA-1941) Criteria query returns wrong result
when query cache is enabled
Posted by "Michael Dick (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-1941?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Michael Dick updated OPENJPA-1941:
----------------------------------
Affects Version/s: (was: 2.1.0)
> Criteria query returns wrong result when query cache is enabled
> ---------------------------------------------------------------
>
> Key: OPENJPA-1941
> URL: https://issues.apache.org/jira/browse/OPENJPA-1941
> Project: OpenJPA
> Issue Type: Bug
> Components: datacache, jpa
> Affects Versions: 2.0.1, 2.0.2
> Environment: The issue was detected when using a criteria query against Oracle database.
> Reporter: Guido Mueller
> Assignee: Michael Dick
> Fix For: 2.1.0, 2.2.0
>
> Attachments: JpaCriteriaQueryCacheIssue.zip, jpacriteriaquerycacheissue.sql
>
>
> When query cache is not enabled the queries return these lines: Query 1: 1 Query 2: 2 This is correct.
> When query cache is enabled the queries return these lines: Query 1: 1 Query 2: 1 This is wrong.
> See attached test case (Netbeans project). ojdbc14.jar and openjpa-all-2.0.1.jar must be added to the project.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Resolved] (OPENJPA-1941) Criteria query returns wrong
result when query cache is enabled
Posted by "Michael Dick (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-1941?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Michael Dick resolved OPENJPA-1941.
-----------------------------------
Resolution: Duplicate
Fix Version/s: 2.1.0
I'm going to resolve the issue as a dup for now. Please comment / reopen if you can reproduce on 2.1.0.
> Criteria query returns wrong result when query cache is enabled
> ---------------------------------------------------------------
>
> Key: OPENJPA-1941
> URL: https://issues.apache.org/jira/browse/OPENJPA-1941
> Project: OpenJPA
> Issue Type: Bug
> Components: datacache, jpa
> Affects Versions: 2.0.1, 2.0.2
> Environment: The issue was detected when using a criteria query against Oracle database.
> Reporter: Guido Mueller
> Assignee: Michael Dick
> Fix For: 2.2.0, 2.1.0
>
> Attachments: JpaCriteriaQueryCacheIssue.zip, jpacriteriaquerycacheissue.sql
>
>
> When query cache is not enabled the queries return these lines: Query 1: 1 Query 2: 2 This is correct.
> When query cache is enabled the queries return these lines: Query 1: 1 Query 2: 1 This is wrong.
> See attached test case (Netbeans project). ojdbc14.jar and openjpa-all-2.0.1.jar must be added to the project.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (OPENJPA-1941) Criteria query returns wrong result
when query cache is enabled
Posted by "Guido Mueller (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-1941?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Guido Mueller updated OPENJPA-1941:
-----------------------------------
Attachment: jpacriteriaquerycacheissue.sql
JpaCriteriaQueryCacheIssue.zip
> Criteria query returns wrong result when query cache is enabled
> ---------------------------------------------------------------
>
> Key: OPENJPA-1941
> URL: https://issues.apache.org/jira/browse/OPENJPA-1941
> Project: OpenJPA
> Issue Type: Bug
> Components: datacache, jpa
> Affects Versions: 2.0.1
> Environment: The issue was detected when using a criteria query against Oracle database.
> Reporter: Guido Mueller
> Attachments: JpaCriteriaQueryCacheIssue.zip, jpacriteriaquerycacheissue.sql
>
>
> When query cache is not enabled the queries return these lines: Query 1: 1 Query 2: 2 This is correct.
> When query cache is enabled the queries return these lines: Query 1: 1 Query 2: 1 This is wrong.
> See attached test case (Netbeans project). ojdbc14.jar and openjpa-all-2.0.1.jar must be added to the project.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Assigned: (OPENJPA-1941) Criteria query returns wrong result
when query cache is enabled
Posted by "Michael Dick (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-1941?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Michael Dick reassigned OPENJPA-1941:
-------------------------------------
Assignee: Michael Dick
> Criteria query returns wrong result when query cache is enabled
> ---------------------------------------------------------------
>
> Key: OPENJPA-1941
> URL: https://issues.apache.org/jira/browse/OPENJPA-1941
> Project: OpenJPA
> Issue Type: Bug
> Components: datacache, jpa
> Affects Versions: 2.0.1, 2.0.2, 2.1.0
> Environment: The issue was detected when using a criteria query against Oracle database.
> Reporter: Guido Mueller
> Assignee: Michael Dick
> Fix For: 2.2.0
>
> Attachments: JpaCriteriaQueryCacheIssue.zip, jpacriteriaquerycacheissue.sql
>
>
> When query cache is not enabled the queries return these lines: Query 1: 1 Query 2: 2 This is correct.
> When query cache is enabled the queries return these lines: Query 1: 1 Query 2: 1 This is wrong.
> See attached test case (Netbeans project). ojdbc14.jar and openjpa-all-2.0.1.jar must be added to the project.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (OPENJPA-1941) Criteria query returns wrong
result when query cache is enabled
Posted by "Guido Mueller (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-1941?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12995777#comment-12995777 ]
Guido Mueller commented on OPENJPA-1941:
----------------------------------------
The problem is gone in 2.2.0 SNAPSHOT
> Criteria query returns wrong result when query cache is enabled
> ---------------------------------------------------------------
>
> Key: OPENJPA-1941
> URL: https://issues.apache.org/jira/browse/OPENJPA-1941
> Project: OpenJPA
> Issue Type: Bug
> Components: datacache, jpa
> Affects Versions: 2.0.1, 2.1.0
> Environment: The issue was detected when using a criteria query against Oracle database.
> Reporter: Guido Mueller
> Attachments: JpaCriteriaQueryCacheIssue.zip, jpacriteriaquerycacheissue.sql
>
>
> When query cache is not enabled the queries return these lines: Query 1: 1 Query 2: 2 This is correct.
> When query cache is enabled the queries return these lines: Query 1: 1 Query 2: 1 This is wrong.
> See attached test case (Netbeans project). ojdbc14.jar and openjpa-all-2.0.1.jar must be added to the project.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira