Examples of org.apache.openjpa.kernel.PreparedQuery

org.apache.openjpa.kernel.PreparedQuery
A prepared query associates a compiled query to a parsed state that can be executed possibly with more efficiency. An obvious example is to associate a compiled query to an executable SQL string. The query expressed in target language can be executed directly bypassing the critical translation cost to the data store target language on every execution. As the subsequent execution of a cached query will bypass normal query compilation, the post-compilation state of the original query is captured by this receiver to be transferred to the executable query instance. This receiver must not hold any context-sensitive reference or dependency. Because the whole idea of preparing a query (for a cost) is to be able to execute the same logical query in different persistence contexts. However, a prepared query may not be valid when some parameters of execution context such as lock group or fetch plan changes in a way that will change the target query. Refer to {@link PreparedQueryCache} for invalidation mechanism onpossible actions under such circumstances. The query execution model does account for context changes that do not impact the target query e.g. bind variables. @author Pinaki Poddar @since 2.0.0


        Query query = em.createQuery(jpql, QueryTest1.class);


        List rs = query.getResultList();
        assertTrue(rs.get(0) instanceof QueryTest1);
        PreparedQuery pq = getPreparedQueryCache().get(jpql);
        assertNotNull(pq);


        Query query2 = em.createQuery(jpql, QueryTest1.class);
        PreparedQuery pq2 = getPreparedQueryCache().get(jpql);
        assertEquals(pq, pq2);
        rs = query2.getResultList();
        assertTrue(rs.get(0) instanceof QueryTest1);


        jpql = "SELECT o.datum FROM QueryTest1 o";

View Full Code Here

        
    }
    
    
    void assertCached(String id) {
        PreparedQuery cached = getPreparedQueryCache().get(id);
        assertNotNull(getPreparedQueryCache() + ": " + getPreparedQueryCache().getMapView() + 
                " does not contain " + id, cached);
    }

View Full Code Here

  
  public void testPreparedQueryIdentifierIsOriginalJPQLQuery() {
        String jpql = "select p from Company p";
        OpenJPAQuery<?> q1 = em.createQuery(jpql);
        q1.getResultList();
        PreparedQuery pq = getPreparedQueryCache().get(jpql);
        assertNotNull(pq);
        assertEquals(jpql, pq.getIdentifier());
        assertEquals(jpql, pq.getOriginalQuery());
  }

View Full Code Here

  
  public void testOriginalJPQLQueryStringIsSetOnPreparedQuery() {
        String jpql = "select p from Company p";
        OpenJPAQuery<?> q1 = em.createQuery(jpql);
        q1.getResultList();
        PreparedQuery pq = getPreparedQueryCache().get(jpql);
        assertNotNull(pq);
        OpenJPAQuery<?> q2 = em.createQuery(jpql);
        assertEquals(jpql,q2.getQueryString());
  }

View Full Code Here

  public void testOrderByElementsAbsentInProjection() {
      String jpql = "select c.name from Company c ORDER BY c.startYear";
        OpenJPAQuery<?> q1 = em.createQuery(jpql);
        List l1 = q1.getResultList();
        
        PreparedQuery pq = getPreparedQueryCache().get(jpql);
        assertNotNull(pq);
        OpenJPAQuery<?> q2 = em.createQuery(jpql);
        List l2 = q2.getResultList();
        
        assertEquals(l1.size(), l2.size());

View Full Code Here

  void assertLanguage(OpenJPAQuery<?> q, String lang) {
    assertEquals(lang, q.getLanguage());
  }
  
  void assertCached(String id) {
    PreparedQuery cached = getPreparedQueryCache().get(id);
    assertNotNull(getPreparedQueryCache() + ": " + getPreparedQueryCache().getMapView() + 
        " does not contain " + id, cached);
  }

View Full Code Here

    
    q1.getResultList();
    assertCached(jpql);
    assertLanguage(q1, JPQLParser.LANG_JPQL);
    
    PreparedQuery cached = getPreparedQueryCache().get(jpql);
    assertEquals(jpql, cached.getIdentifier());
    assertFalse(jpql.equalsIgnoreCase(cached.getTargetQuery()));
  }

View Full Code Here

            // We need
            if (query != null && _convertPositionalParams && JPQLParser.LANG_JPQL.equals(language)) {
                query = query.replaceAll("[\\?]", "\\:_");
            }
            String qid = query;
            PreparedQuery pq = JPQLParser.LANG_JPQL.equals(language)
                ? getPreparedQuery(qid) : null;
            org.apache.openjpa.kernel.Query q = (pq == null || !pq.isInitialized())
                ? _broker.newQuery(language, query)
                : _broker.newQuery(pq.getLanguage(), pq);
            // have to validate JPQL according to spec
            if (pq == null && JPQLParser.LANG_JPQL.equals(language))
                q.compile(); 
            if (pq != null) {
                pq.setInto(q);
            }
            return newQueryImpl(q).setId(qid);
        } catch (RuntimeException re) {
            throw PersistenceExceptions.toPersistenceException(re);
        }

View Full Code Here

            QueryMetaData meta = _broker.getConfiguration().
                getMetaDataRepositoryInstance().getQueryMetaData(null, name,
                _broker.getClassLoader(), true);
            String qid = meta.getQueryString();
            
            PreparedQuery pq = JPQLParser.LANG_JPQL.equals(meta.getLanguage()) ? getPreparedQuery(qid) : null;
            org.apache.openjpa.kernel.Query del =
                (pq == null || !pq.isInitialized()) ? _broker.newQuery(meta.getLanguage(), meta.getQueryString())
                    : _broker.newQuery(pq.getLanguage(), pq);
            
            if (pq != null) {
                pq.setInto(del);
            } else {
                meta.setInto(del);
                del.compile();
            }

View Full Code Here

        Boolean registered = cache.register(_id, _query, fetch);
        boolean alreadyCached = (registered == null);
        String lang = _query.getLanguage();
        QueryStatistics<String> stats = cache.getStatistics();
        if (alreadyCached && LANG_PREPARED_SQL.equals(lang)) {
            PreparedQuery pq = _em.getPreparedQuery(_id);
            if (pq.isInitialized()) {
                try {
                    Map rep = pq.reparametrize(params, _em.getBroker());
                    params.clear();
                    params.putAll(rep);
                } catch (UserException ue) {
                    invalidatePreparedQuery();
                    Log log = _em.getConfiguration().getLog(OpenJPAConfiguration.LOG_RUNTIME);
                    if (log.isWarnEnabled())
                        log.warn(ue.getMessage());
                    return false;
                }
            }
            stats.recordExecution(pq.getOriginalQuery());
        } else {
            stats.recordExecution(getQueryString());
        }
        return registered == Boolean.TRUE;
    }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.apache.openjpa.kernel.PreparedQuery

org.apache.openjpa.jdbc.kernel.PreparedQueryCacheImpl

org.apache.openjpa.persistence.EntityManagerImpl

org.apache.openjpa.persistence.jdbc.sqlcache.TestInExpressionParamaterBinding

org.apache.openjpa.persistence.jdbc.sqlcache.TestInExpressionParameterBinding

org.apache.openjpa.persistence.jdbc.sqlcache.TestPreparedQueryCache

org.apache.openjpa.persistence.jdbc.sqlcache.TestPreparedQueryCacheExclusion

org.apache.openjpa.persistence.query.TestQueryResultClassAPI

org.apache.openjpa.persistence.QueryImpl

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.