Hi - Sybase ASE has a limitation of 250 ANDs/ORs in a select. It also has a limitation of 250 elements inside of an IN. We've encountered a problem with the way that JBoss CMP pulls large sets of data from the database because of this limitation. CMP engine first pulls all of the primary keys and then does a second query that looks like "SELECT * FROM TABLE WHERE primary_key=? OR primary_key=? OR primary_key=? OR ..." The problem is that when the result set contains more than 250 primary keys, the query that JBoss generates causes Sybase to throw an SQL exception because of the limitation. Any way around this? Thanks.
Robert ------------------------------------------------------- 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
