Bugs item #550606, was opened at 2002-04-30 16:00 Message generated for change (Comment added) made by loubyansky You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=550606&group_id=22866
Category: JBossCMP Group: v4.0 >Status: Closed Resolution: Postponed Priority: 5 Submitted By: Daniel Moos (moosi_1978) Assigned to: Alexey Loubyansky (loubyansky) 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: Alexey Loubyansky (loubyansky) Date: 2003-10-24 14:11 Message: Logged In: YES user_id=543482 If you are using JAWS you should switch to JBossCMP and correct read-ahead configuration. If you want JBossCMP to use vendor-specific read-ahead configuration, please, submit a feature request. ---------------------------------------------------------------------- Comment By: Dain Sundstrom (dsundstrom) Date: 2003-08-18 01:36 Message: Logged In: YES user_id=251431 I am no no longer a JBoss committer, so I am unable to fix any bugs. ---------------------------------------------------------------------- Comment By: Sacha Labourey (slaboure) Date: 2003-04-19 19:22 Message: Logged In: YES user_id=95900 Is this now fixed Dain? ---------------------------------------------------------------------- Comment By: Dain Sundstrom (dsundstrom) Date: 2002-06-25 02:51 Message: Logged In: YES user_id=251431 This will be fixed during the rewrite of the metadata package in 3.1. ---------------------------------------------------------------------- Comment By: Daniel Moos (moosi_1978) Date: 2002-05-02 12:50 Message: Logged In: YES user_id=332885 Sorry, i set you're proposition and the Exception did not change. I even set in jaws.xml or standardjaws.xml a read-ahead tag to true, no change too. ---------------------------------------------------------------------- Comment By: Georg Schmid (giorgio42) Date: 2002-04-30 20: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: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=550606&group_id=22866 ------------------------------------------------------- This SF.net email is sponsored by: The SF.net Donation Program. Do you like what SourceForge.net is doing for the Open Source Community? Make a contribution, and help us add new features and functionality. Click here: http://sourceforge.net/donate/ _______________________________________________ JBoss-Development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
