Russ I don't know exactly what you need to do in this app (just reading, updating as well) but there's nothing wrong with straight jdbc from the session bean for very large queries. This has been a J2EE design principal for a while. Especially if it's read only.
On the other hand, if you get CMP to work with this on jboss as well as a straight query from a session bean, I'd be very interested to know. We have an app that deals with very large data sets. Regards Eric -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Russell Chan Sent: Tuesday, September 09, 2003 3:53 PM To: [EMAIL PROTECTED] Subject: [JBoss-user] Selecting large datasets using CMP Hi, In our application we currently have a need (don't ask) to periodically go through a very large dataset. We are using jboss 3.2.1, with an oracle 9i back-end, using CMP2. On my first attempts to do this, with a read-ahead strategy of "on-load", with a page size of 10, (in a transaction), the cmp engine executes the query, and appears to try to load up the primary keys for the resultset. Unforunately, the amount of keys alone causes jboss on my developer machine to give me an OutOfMemoryException. It hasn't even started to preload the beans or anything (so, AFAIK, the read-ahead is immaterial). Am I stuck with BMP for this? Is there any way to tune the CMP 2 engine so that it doesn't try to load in all of the primary keys, and THEN, load up the entities? Thanks, Russ Chan ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
