[jboss-user] [EJB/JBoss] - EJB-QL: LIMIT / OFFSET not working

[jelevy01]

The following query, when deployed throws a parsing error:

SELECT OBJECT(o) 
FROM Conversation o WHERE

(o.toUserID = ?1 OR o.fromUserID= ?1) AND
(o.toUserID = ?2 OR o.fromUserID = ?2) 
ORDER BY o.timestamp DESC OFFSET ?3 LIMIT ?4

-------
12:43:10,826 ERROR [ConversationBean#findByUsers] ::: Encountered "OFFSET" at line 6, column 27.
Was expecting one of:
     
    "," ...
--------

As far as I can see I am using this correctly, any suggestions?

J

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4079699#4079699

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4079699