Too many AND's and OR's with Sybase

[cgijei]

Dear all,


Below exception is resulted whenever findByMethod() is invoked on those which return a large collection of data. Does anybody know how to fix this?

2003-05-15 17:22:46,649 ERROR [org.jboss.ejb.plugins.LogInterceptor] EJBException, causedBy:
com.sybase.jdbc2.jdbc.SybSQLException: Too many ANDs or ORs in expression (limit 1024 per expression level). Try splitting query or limiting ANDs and ORs.

at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2636)
at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:1996)

Exact same problem is posted on sourceforge.net http://sourceforge.net/tracker/?group_id=22866&atid=376685&func=detail&aid=550606 , but the action is on postponed status. Please advise what is the progress on this issue.

Thanks....

[cepage]

Restrict the size of your load-group so that is under the limit.

Interesting that your message describes a limit of 1024. My Sybase craps out at 256. Maybe the latest version has a higher limit...