File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Regaring JBoss-ql LIMIT offset problem

 
vinny kumar
Greenhorn
Posts: 7
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dear All,

I am using ejb2.1 and CMP entiy Beans and Sybase15.0.2 and OS LInux

in my prjoject we are using total three DB servers
two servers below query working fine one server is not working

<jboss-ql>
<![CDATA[SELECT OBJECT(o) FROM RetailerTerminalRecall o where o.hwid=?1 ORDER BY o.recallTime desc OFFSET?2 LIMIT?3 ]]>
</jboss-ql>

Thanks&Regards
Ch.Vinaya Kumar

 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic