Mailing-List: contact dev-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@openjpa.apache.org
Date: Wed, 23 Jan 2013 14:48:13 +0000 (UTC)
From: "gonzalad (JIRA)" <jira@apache.org>
To: dev@openjpa.apache.org
Message-ID: <JIRA.12628902.1358952424951.179083.1358952493376@arcas>
In-Reply-To: <JIRA.12628902.1358952424951@arcas>
References: <JIRA.12628902.1358952424951@arcas>
Subject: [jira] [Created] (OPENJPA-2327) QueryCache as hint
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

gonzalad created OPENJPA-2327:
---------------------------------

             Summary: QueryCache as hint
                 Key: OPENJPA-2327
                 URL: https://issues.apache.org/jira/browse/OPENJPA-2327
             Project: OpenJPA
          Issue Type: Bug
            Reporter: gonzalad


Provide a way to enable query cache as a query hint.

This would facilitate writing portable JPA applications.

For the time being, with OpenJPA, we need to execute the following code to cache the query :

{code:java}
OpenJPAEntityManager oem = ((OpenJPAQuery<?>) query).getEntityManager();
OpenJPAEntityManagerFactory oemf = oem.getEntityManagerFactory();
QueryResultCache qcache = oemf.getQueryResultCache();
qcache.pin(query);
{code}

It would be easier if JPA provided a query hint like :

{code:java}
query.setHint("openjpa.cacheable", cache);
{code}

This would even enable us to use it in a NamedQuery declaration :


{code:java}
@NamedQuery(name = "Civilite.findAll",
    query = "SELECT c FROM Civilite c", 
    hints = @QueryHint(name = "openjpa.cacheable", value = "true"))
{code}


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira