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

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

[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 *really* think the historical 
stuff should be on another box but thats another fight.]

I propose to NOT use JBoss CMP, but to go straight to JDBC for these historical 
queries [the queries will also be paged for performance].

Does anybody have similar experiences they can share, and any alternative 
ideas. For instance, can I destroy the cache for the historical data when the 
data has been sent to the client - if so, an example would be really great.

Any ideas or comments appreciated

Ian Hunter

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

Reply to the post : 
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3973857
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user