From: <no...@so...> - 2002-04-30 17:26:17
|
Bugs item #550606, was opened at 2002-04-30 15:00 You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=376685&aid=550606&group_id=22866 Category: None Group: v3.0 Rabbit Hole Status: Open Resolution: None Priority: 5 Submitted By: Daniel Moos (moosi_1978) Assigned to: Nobody/Anonymous (nobody) Summary: Too many AND's and OR's with Sybase Initial Comment: I have following problems with Sybase 11.9.2 and JBoss3.0.0RC1: If Jboss call findAll()-Methode, then throws a following Exception : 14:25:40,730 INFO [STDOUT] SQLException: SQLState(ZZZZZ) vendor code(404) 14:25:40,731 INFO [STDOUT] com.sybase.jdbc2.jdbc.SybSQLException: Too many ANDs or ORs in expression (limit 250 per expression level). Try splitting query or limiting ANDs and ORs. Before Jboss call findAll-Methode, put i 300 rows in a Table over Jboss. What i doing false? Who can help me? ---------------------------------------------------------------------- Comment By: Georg Schmid (giorgio42) Date: 2002-04-30 19:26 Message: Logged In: YES user_id=437570 Maybe reducing the page size for the read-ahead to something below 250 (in standardjbosscmp-jdbc.xml or jbosscmp-jdbc.xml) helps. Georg ---------------------------------------------------------------------- You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=376685&aid=550606&group_id=22866 |