[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Urgent help please!

[ihunter]

[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


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3958256#3958256

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3958256