You can limit the ORs generated using the <page-size> on the <read-ahead>.
Regards, Adrian On Wed, 2003-09-24 at 11:01, Jonathan.O'[EMAIL PROTECTED] wrote: > Running JBoss 3.0.6, running a finder on a entity bean, JBoss generates a > load query like: > select field1, field2, field3 from MY_TABLE where ID = 1 or ID = 2 or ID = > 3 ... > Normally this code is fine, however, the finder happens to find more than > 250 rows, and Sybase ASE12.0 does not like where clauses with more than > 250 ANDs or ORs. I tried changing the select statement to "Select field1, > field2, field3 from MY_TABLE where ID in (1, 2, 3...)" but this produced > the same error message. It seems Sybase translates the IN clause to a > series of ORs. > > Is the only work around to upgrade to 3.2.2 and use LIMIT and OFFSET to > get around the problem? Yes, I know this is probably a better solution in > the long run, but... > > Any advice would be appreciated. > Ciao, > Jonathan O'Connor > XCOM Dublin > > > ------------------------------------------------------- > 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 -- xxxxxxxxxxxxxxxxxxxxxxxx Adrian Brock Director of Support Back Office JBoss Group, LLC xxxxxxxxxxxxxxxxxxxxxxxx ------------------------------------------------------- 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
