Hello,
I need to Query with LIMIT the Reslult length. I found 11.6.4. JBossQL in the
documentation, but I do not like to write a jbosscmp-jdbc.xml file. Is there a
way to make it like below, the Query must also be dynamic because of Order :
| @PersistenceContext
| Entitymanager manager;
|
| public List<SomeObj> findAllBlub(Integer offset, Integer limit){
| String order = "ORDER BY ....."
| return manager.createQuery("SELECT o FROM SomeObj o "+ order +" OFFSET "+
offset +" LIMIT "+ limit).getResultList();
| }
|
I'm using Jboss4.0.4 GA .
thx for Help
cjc
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3967428#3967428
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3967428
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
