I suspected this was so, but was hoping for someone else to come up with a nice elegant solution for me.
I want to take advantage of oracle cursors, so in this case, it looks like I have to use the raw jdbc.
Russ
Eric J Kaplan wrote:
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
-- -- Russell Chan, Navaho Networks Inc. 416 542 1590 x108
------------------------------------------------------- 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
