Java Code Examples for javax.persistence.query#setHint()

private void addEntityGraphToQuery(Query query) {
  if (CountQueryDetector.isCountQuery()) {
    LOG.trace("CountQuery detected.");
    return;
  }
  if (!entityGraphCandidate.isPrimary()
      && QueryHintsUtils.containsEntityGraph(query.getHints())) {
    LOG.trace(
        "The query hints passed with the find method already hold an entity graph. Overriding aborted because the candidate EntityGraph is optional.");
    return;
  }

  QueryHintsUtils.removeEntityGraphs(query.getHints());
  Map<String, Object> hints =
      QueryHintsUtils.buildQueryHints(entityManager, entityGraphCandidate);
  for (Map.Entry<String, Object> hint : hints.entrySet()) {
    query.setHint(hint.getKey(), hint.getValue());
  }
}
 

/**
 * CommonDAO 内部方法，NamedQuery
 * 
 * @param entityManager
 *            entityManager
 * @param name
 *            name
 * @param cacheable
 *            cacheable
 * @param cacheRegion
 *            cacheRegion
 * @param values
 *            values
 * @return Query对象
 */
private Query createNamedQuery(EntityManager entityManager, String name, boolean cacheable, String cacheRegion,
		Map<String, Object> values) {
	Query query = entityManager.createNamedQuery(name.trim());
	if (cacheable) {
		query.setHint(QueryHints.HINT_CACHEABLE, "true");
		if (cacheRegion != null && (!cacheRegion.equals(""))) {
			query.setHint(QueryHints.HINT_CACHE_REGION, cacheRegion);
		}
	}
	if (values != null && values.size() > 0) {
		for (Entry<String, Object> e : values.entrySet()) {
			query.setParameter(e.getKey(), e.getValue());
		}
	}
	return query;
}
 

public CloneFile getWorkspaceRoot(String id) {
    CloneFile workspaceRoot;
    
    String queryStr = "select cf from CloneFile cf where "
            + "        cf.workspaceRoot = :isRoot and"
            + "        cf.version = ("
            + "            select max(cf2.version) from CloneFile cf2 where cf.id = cf2.id) and "
            + "        cf.workspace = ("
            + "           select wp from CloneWorkspace wp where "
            + "           wp.id = :workspaceId"
            + "        )";

    Query query = config.getDatabase().getEntityManager().createQuery(queryStr, CloneChunk.class);
    query.setHint("javax.persistence.cache.storeMode", "REFRESH");
    query.setHint("eclipselink.cache-usage", "DoNotCheckCache");
    query.setParameter("isRoot", true);
    query.setParameter("workspaceId", id);

    workspaceRoot = (CloneFile) query.getSingleResult();
    
    return workspaceRoot;
}
 

/**
 *
 * @param did
 * @param username - Name of the user whose keys need to be fetched.
 * @param status - status of Fido key (Active vs Inactive)
 * @return - List of keys for the supplied username
 */
@Override
public FidoKeys getNewestKeyByUsernameStatus(Long did, String username, String status) throws SKFEException {
    try {
        Query q = em.createNamedQuery("FidoKeys.findNewestKeyByUsernameStatus", FidoKeys.class);
        q.setHint("javax.persistence.cache.storeMode", "REFRESH");
        q.setParameter("username", username);
        q.setParameter("did", did);
        q.setParameter("status", status);

        List<FidoKeys> fkList = q.getResultList();
        if (fkList == null || fkList.isEmpty()) {
            return null;
        }
        FidoKeys rk = fkList.get(0);
        if (rk != null) {
            verifyDBRecordSignature(did, rk);
        }
        return rk;
    } catch (NoResultException ex) {
        return null;
    }
}
 

/**
 * This method lists all the entities inserted in datastore.
 * It uses HTTP GET method and paging support.
 *
 * @return A CollectionResponse class containing the list of all entities
 * persisted and a cursor to the next page.
 */
@SuppressWarnings({"unchecked", "unused"})
@ApiMethod(name = "listOffer")
public CollectionResponse<Offer> listOffer(
    @Nullable @Named("cursor") String cursorString, @Nullable @Named("limit") Integer limit) {

  EntityManager mgr = null;
  Cursor cursor = null;
  List<Offer> execute = null;

  try {
    mgr = getEntityManager();
    Query query = mgr.createQuery("select from Offer as Offer");
    if (cursorString != null && cursorString != "") {
      cursor = Cursor.fromWebSafeString(cursorString);
      query.setHint(JPACursorHelper.CURSOR_HINT, cursor);
    }

    if (limit != null) {
      query.setFirstResult(0);
      query.setMaxResults(limit);
    }

    execute = (List<Offer>) query.getResultList();
    cursor = JPACursorHelper.getCursor(execute);
    if (cursor != null) cursorString = cursor.toWebSafeString();

    // Tight loop for fetching all entities from datastore and accomodate
    // for lazy fetch.
    for (Offer obj : execute);
  } finally {
    mgr.close();
  }

  return CollectionResponse.<Offer>builder()
      .setItems(execute).setNextPageToken(cursorString).build();
}
 

@Override
public Act findLastActByContractAndScenario(Long idContract, String scenarioName) {
    StringBuilder queryString = new StringBuilder();
    queryString.append("SELECT a FROM ");
    queryString.append(ActImpl.class.getName());
    queryString.append(" a");
    queryString.append(" left join a.audit.subject w");
    queryString.append(" WHERE a.contract.id = :idContract");
    queryString.append(" AND (a.status = :completedStatus OR a.status = :errorStatus)");
    queryString.append(" AND a.scope.code =:scope ");
    queryString.append(" AND w.url=:scenarioName");
    queryString.append(" ORDER BY a.id DESC");
    
    Query query = entityManager.createQuery(queryString.toString());
    query.setParameter("idContract", idContract);
    query.setParameter("completedStatus", ActStatus.COMPLETED);
    query.setParameter("errorStatus", ActStatus.ERROR);
    query.setParameter("scope", ScopeEnum.SCENARIO);
    query.setParameter("scenarioName", scenarioName);
    query.setMaxResults(1);
    query.setHint(CACHEABLE_OPTION, "true");
    try {
        return (Act)query.getSingleResult();
    } catch (NoResultException nre) {
        return null;
    }
}
 

@Override
public WebResource ligthRead(Long webResourceId) {
    try {
        Query query = entityManager.createQuery("SELECT wr FROM "
                + getEntityClass().getName() + " wr"
                + " WHERE wr.id = :id");
        query.setParameter("id", webResourceId);
        query.setHint(CACHEABLE_OPTION, TRUE);
        return (WebResource) query.getSingleResult();
    } catch (NoResultException nre) {
        return null;
    }
}
 

@Override
public List<Test> retrieveAllByCriterion(Criterion criterion) {
    StringBuilder queryStr = new StringBuilder();
    queryStr.append("SELECT t FROM ");
    queryStr.append(getEntityClass().getName());
    queryStr.append(" t WHERE");
    queryStr.append(" t.criterion = :criterion");
    Query query = entityManager.createQuery(queryStr.toString());
    query.setParameter("criterion", criterion);
    query.setHint("org.hibernate.cacheable", "true");
    return query.getResultList();
}
 

/**
 * This method lists all the entities inserted in datastore.
 * It uses HTTP GET method and paging support.
 *
 * @return A CollectionResponse class containing the list of all entities
 * persisted and a cursor to the next page.
 */
@SuppressWarnings({"unchecked", "unused"})
@ApiMethod(name = "listPlace")
public CollectionResponse<Place> listPlace(
    @Nullable @Named("cursor") String cursorString, @Nullable @Named("limit") Integer limit) {

  EntityManager mgr = null;
  Cursor cursor = null;
  List<Place> execute = null;

  try {
    mgr = getEntityManager();
    Query query = mgr.createQuery("select from Place as Place");
    if (cursorString != null && cursorString != "") {
      cursor = Cursor.fromWebSafeString(cursorString);
      query.setHint(JPACursorHelper.CURSOR_HINT, cursor);
    }

    if (limit != null) {
      query.setFirstResult(0);
      query.setMaxResults(limit);
    }

    execute = (List<Place>) query.getResultList();
    cursor = JPACursorHelper.getCursor(execute);
    if (cursor != null) cursorString = cursor.toWebSafeString();

    // Tight loop for fetching all entities from datastore and accomodate
    // for lazy fetch.
    for (Place obj : execute);
  } finally {
    mgr.close();
  }

  return CollectionResponse.<Place>builder()
      .setItems(execute).setNextPageToken(cursorString).build();
}
 

@Transactional
private void queryCache(){
	_logger.warn("Query Cache");
	Query query = entityManager.createQuery("SELECT a FROM Account a WHERE a.accountId=:accountId", Account.class);
	query.setParameter("accountId", 7L);
	query.setHint("org.hibernate.cacheable", true);
	Account account = (Account)query.getSingleResult();
	_logger.warn(account);
}
 

@Override
@SuppressWarnings("unchecked")
public Collection<Act> findAllActsByContract(Contract contract) {
    Query query = entityManager.createQuery("SELECT a FROM "
            + getEntityClass().getName() + " a"
            + " WHERE a.contract = :contract");
    query.setHint(CACHEABLE_OPTION, "true");
    query.setParameter("contract", contract);
    return (List<Act>)query.getResultList();
}
 

public Map<String, List<CloneFile>> getHistoryUptoDate() {
    Calendar cal = Calendar.getInstance();  
    cal.set(getFieldTimeout(), getValueTimeout(cal)); 
    Date time = cal.getTime();        
    
    String queryStr = "select c from CloneFile c where "
            + "     c.syncStatus = :statusSync and "                
            + "     c.serverUploadedAck = false and "
            + "     c.workspaceRoot = false and "
            + "     (c.serverUploadedTime < :timeNow or "
            + "     c.serverUploadedTime is null) order by "
            + "                                     c.path asc, c.version asc";    
    
    Query query = config.getDatabase().getEntityManager().createQuery(queryStr, CloneFile.class);
    query.setHint("javax.persistence.cache.storeMode", "REFRESH");
    query.setHint("eclipselink.cache-usage", "DoNotCheckCache");        
    
    query.setParameter("statusSync", CloneFile.SyncStatus.UPTODATE);       
    query.setParameter("timeNow", time);
    
    Map<String, List<CloneFile>> workspaces = new HashMap<String, List<CloneFile>>();
    List<CloneFile> clonefiles = query.getResultList();
    for(CloneFile cf: clonefiles){
        if(!workspaces.containsKey(cf.getWorkspace().getId())){
            workspaces.put(cf.getWorkspace().getId(), new ArrayList<CloneFile>());
        } 
            
        workspaces.get(cf.getWorkspace().getId()).add(cf);            
    }
    
    return workspaces;
}
 

private Query recreateQuery(Query current, String newSqlString) {
    Query result = entityManager.createQuery(newSqlString);
    for (Entry<String, Object> hint : current.getHints().entrySet()) {
        result.setHint(hint.getKey(), hint.getValue());
    }
    return result;
}
 

public CloneWorkspace getWorkspace(String id) {
    String queryStr = "select w from CloneWorkspace w where"
            + "            w.id = :id";        
    Query query = config.getDatabase().getEntityManager().createQuery(queryStr, CloneWorkspace.class);
    query.setHint("javax.persistence.cache.storeMode", "REFRESH");
    query.setHint("eclipselink.cache-usage", "DoNotCheckCache");        
    
    query.setParameter("id", id);
    CloneWorkspace workspace = (CloneWorkspace)query.getSingleResult();
    
    return workspace;
}
 

public synchronized Query createQuery(String query, Class type) {
    Query request = getEntityManager().createQuery(query, type);

    request.setHint("javax.persistence.cache.storeMode", "REFRESH");
    request.setHint("eclipselink.cache-usage", "DoNotCheckCache");

    return request;
}
 

protected void applyFetchPaths(Query criteriaQuery) {
	EntityGraph<T> graph = em.createEntityGraph(getEntityClass());
	for (MetaAttributePath fetchPath : fetchPaths) {
		applyFetchPaths(graph, fetchPath);
	}
	criteriaQuery.setHint("javax.persistence.fetchgraph", graph);
}
 

@Override
@SuppressWarnings("unchecked")
public List<Test> retrieveAll(Reference reference) {
    Query query = entityManager.createQuery("SELECT t FROM "
            + getEntityClass().getName() + " t"
            + " WHERE t.criterion.reference = :reference");
    query.setParameter("reference", reference);
    query.setHint("org.hibernate.cacheable", "true");
    return (List<Test>) query.getResultList();
}
 

public void applyEnableQueryCache(Query query) {
    if (enableQueryCache) {
        query.setHint("org.hibernate.cacheable", true);//开启查询缓存
    }
}
 

private static void updateQueryParams(Query query, Filter filter) {
	filter.setParameters(query);
	filter.setPage(query);
	query.setHint(JPA.instance.getCacheableHint(), filter.isCacheable());
}
 

public void updateQueryPageSize(Query query, SearchCriteria searchCriteria) {
	// Set max records
	int pageSize = validatePageSize(searchCriteria.getMaxRows());

	query.setMaxResults(pageSize);

	// Set hint for max records
	query.setHint("eclipselink.jdbc.max-rows", "" + pageSize);

}