[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
_______________________________________________
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user
