Hello Robert, have tried tuning read-ahead?
alex Tuesday, December 10, 2002, 9:32:01 PM, you wrote: RM> Hi - RM> Sybase ASE has a limitation of 250 ANDs/ORs in a select. It also has a RM> limitation of 250 elements inside of an IN. We've encountered a problem RM> with the way that JBoss CMP pulls large sets of data from the database RM> because of this limitation. CMP engine first pulls all of the primary keys RM> and then does a second query that looks like "SELECT * FROM TABLE WHERE RM> primary_key=? OR primary_key=? OR primary_key=? OR ..." The problem is that RM> when the result set contains more than 250 primary keys, the query that RM> JBoss generates causes Sybase to throw an SQL exception because of the RM> limitation. Any way around this? Thanks. RM> Robert ------------------------------------------------------- This sf.net email is sponsored by: With Great Power, Comes Great Responsibility Learn to use your power at OSDN's High Performance Computing Channel http://hpc.devchannel.org/ _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
