openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Albert Lee <allee8...@gmail.com>
Subject Re: how to use orderBy clause in tuple query?
Date Tue, 28 Apr 2015 19:11:47 GMT
The "orderBy" coding looks correct to me.

Looks into the OJ code base, the part where it detects the error seems NOT
be able to
ExpressionStoreQuery {
        public Object getOrderingValue(StoreQuery q, Object[] params,
            Object resultObject, int orderIndex) {
            // if this is a projection, then we have to order on
something   <<<<<<< looking for the order path in the selected items
            // we selected
            if (_exps[0].projections.length > 0) {
                String ordering = _exps[0].orderingClauses[orderIndex];
                for (int i = 0; i < _exps[0].projectionClauses.length; i++)
                    if (ordering.equals(_exps[0].projectionClauses[i]))
                        return ((Object[]) resultObject)[i];

                throw new
InvalidStateException(_loc.get                         <<<<<< but failed
with this expression.
                    ("merged-order-with-result",
q.getContext().getLanguage(),
                        q.getContext().getQueryString(), ordering));
            }


You may want to set a break point here to find out what is in _exps[] and
what are missing that is expected by this method.

Good luck.
Albert.

On Mon, Apr 27, 2015 at 8:31 AM, zhourui <zhourui@zoneland.net> wrote:

> [15-4-27 21:18:26:952 CST] 000000d7 SystemErr     R
> <openjpa-2.2.3-SNAPSHOT-r422266:1595313 nonfatal user error>
> org.apache.openjpa.persistence.InvalidStateException:
>
> 使用过滤器“null”对候选类型“javax.persistence.criteria”执行了此查询,包括将多个查询的结果合并在内存中。您已选择对“”上的结果进行排序,但尚未在
> setResult() 子句中选择此数据。请将此排序数据包含在 setResult() 中,以便
OpenJPA 可以抽取此数据以进行内存中排序。
> [15-4-27 21:18:26:952 CST] 000000d7 SystemErr     R     at
>
> org.apache.openjpa.kernel.ExpressionStoreQuery$DataStoreExecutor.getOrderingValue(ExpressionStoreQuery.java:837)
> [15-4-27 21:18:26:952 CST] 000000d7 SystemErr     R     at
>
> org.apache.openjpa.kernel.OrderingMergedResultObjectProvider.getOrderingValue(OrderingMergedResultObjectProvider.java:62)
> [15-4-27 21:18:26:952 CST] 000000d7 SystemErr     R     at
>
> org.apache.openjpa.lib.rop.MergedResultObjectProvider.next(MergedResultObjectProvider.java:172)
> [15-4-27 21:18:26:952 CST] 000000d7 SystemErr     R     at
>
> org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.next(QueryImpl.java:2087)
> [15-4-27 21:18:26:952 CST] 000000d7 SystemErr     R     at
> org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:35)
> [15-4-27 21:18:26:952 CST] 000000d7 SystemErr     R     at
> org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1251)
> [15-4-27 21:18:26:952 CST] 000000d7 SystemErr     R     at
> org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1007)
> [15-4-27 21:18:26:952 CST] 000000d7 SystemErr     R     at
> org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:863)
> [15-4-27 21:18:26:952 CST] 000000d7 SystemErr     R     at
> org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:794)
> [15-4-27 21:18:26:952 CST] 000000d7 SystemErr     R     at
>
> org.apache.openjpa.slice.DistributedQueryImpl.execute(DistributedQueryImpl.java:61)
> [15-4-27 21:18:26:952 CST] 000000d7 SystemErr     R     at
> org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:542)
> [15-4-27 21:18:26:952 CST] 000000d7 SystemErr     R     at
> org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:286)
> [15-4-27 21:18:26:952 CST] 000000d7 SystemErr     R     at
> org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:302)
> [15-4-27 21:18:26:952 CST] 000000d7 SystemErr     R     at
> com.ibm.ws.persistence.QueryImpl.getResultList(QueryImpl.java:118)
>
>
> CriteriaBuilder cb = em.getCriteriaBuilder();
> CriteriaQuery<WrapOutCompany> cq = cb.createQuery(WrapOutCompany.class);
> Root<Company> root = cq.from(Company.class);
> Predicate p = cb.equal(root.get(Company_.level), 1);
> cq.multiselect(root.get(Company_.id), root.get(Company_.name),
> root.get(Company_.unique), root.get(Company_.level),
> root.get(Company_.superior));
> cq.where(p);
> cq.orderBy(cb.asc(root.get(Company_.name)));
> return em.createQuery(cq).getResultList();
>
> use tuple query, where with orderBy clause,it's throw exception,
> but without orderBy clause,it's work fine.
>
> how to use orderBy clause in tuple query?
>
>
>
> --
> View this message in context:
> http://openjpa.208410.n2.nabble.com/how-to-use-orderBy-clause-in-tuple-query-tp7588024.html
> Sent from the OpenJPA Users mailing list archive at Nabble.com.
>



-- 
Albert Lee.

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message