Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Regaring JBoss-ql LIMIT offset problem

 
vinny kumar
Greenhorn
Posts: 7
  • 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

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic