OpenJPA
  1. OpenJPA
  2. OPENJPA-1941

Criteria query returns wrong result when query cache is enabled

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Duplicate
    • Affects Version/s: 2.0.1, 2.0.2
    • Fix Version/s: 2.1.0, 2.2.0
    • Component/s: datacache, jpa
    • Labels:
      None
    • Environment:
      The issue was detected when using a criteria query against Oracle database.

      Description

      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.

      1. JpaCriteriaQueryCacheIssue.zip
        14 kB
        Guido Mueller
      2. jpacriteriaquerycacheissue.sql
        0.9 kB
        Guido Mueller

        Issue Links

          Activity

          No work has yet been logged on this issue.

            People

            • Assignee:
              Michael Dick
              Reporter:
              Guido Mueller
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development