A problem with EJB-QL!!!

[daniko]

Greetings to all!

There was a problem with a subquery at creation of query EJB-GL. How to learn Jboss Portal to understand EJB-QL query with a subquery.

In advance thanks! A

[daniko]

Please somebody help me!!

[daniko]

I will try to describe the problem more in detail!!

Query code:

<query>
<description></description>
<query-method>
<method-name>findMaxId</method-name>
<method-params></method-params>
</query-method>
<ejb-ql>select object(o) from User_statistic o where o.id = (select max(u.id) from User_statistic u)</ejb-ql>
</query>

Whether the query is correctly written? If there is no that as it to correct?