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
