1 Reply Latest reply on May 15, 2003 5:14 PM by Corby Page

    Too many AND's and OR's with Sybase

    cgijei Newbie

      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....