0 Replies Latest reply on Jul 15, 2006 3:21 AM by Ian Hunter

    Urgent help please!

    Ian Hunter Newbie

      [Using JBoss 4.0.3, EJB2, MySQL]

      Hi Folks,

      I have an EJB 2.0 app. and I need to effect the following (psudo) query for an entity...

      SELECT obj FROM Obj WHERE (obj.x IN {0}) LIMIT {1}

      Using dynamicQL does it, but the LIMIT doesn't go into the actual SQL for MySQL and blows the transaction timeout.

      OK, so I use declared-sql, but I NEED to parameterise the IN list from the application - how can do I do this?

      Anybody got any ideas, or alternative approaches.

      Many many thanks for any help

      [Hope this is clear enough]

      Ian Hunter