Bugs item #550606, was opened at 2002-04-30 08:00
Message generated for change (Comment added) made by dsundstrom
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=550606&group_id=22866

Category: JBossCMP
Group: v4.0
Status: Open
Resolution: Postponed
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: Dain Sundstrom (dsundstrom)
Date: 2003-08-17 17: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 11:22

Message:
Logged In: YES 
user_id=95900

Is this now fixed Dain?

----------------------------------------------------------------------

Comment By: Dain Sundstrom (dsundstrom)
Date: 2002-06-24 18: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 04: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 12: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 sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01
_______________________________________________
JBoss-Development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development

Reply via email to