[jboss-user] [Beginners Corner] - Caching large volumes of entities

2006-09-25 Thread ihunter
Hi Folks, We have a server designed to serve 'live' database data. We have now been asked to provide a facility for querying 'historical' database data from the database. I *think* that serving up large volumes of historical data would consume resources and slow down the live service. [I

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

2006-07-15 Thread 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