0 Replies Latest reply on Jul 1, 2006 2:58 AM by Ian Hunter

    Declared-SQL v. Dynami-QL - Can I have my cake and eat it?

    Ian Hunter Newbie

      [JBos 4.0.4.GA EJB2.1, using xdoclet, MySQL]

      I have a dyniamic query...

      "SELECT * FROM table WHERE (.....) LIMIT 100"

      and I build the WHERE clause at run time - I'm happy

      But the (JBoss) generated SQL does not include LIMIT on the query. With large record sets it takes a long time.

      So, I should use Declared-SQL. But this appears to be completely static.

      Does anybody know how I can do both? have I missed something here?

      Many Thanks
      Ian Hunter