I saw that before: this happens when yo have too long query, plausibly
the one like:
SELECT whatever FROM someTable where id in (long list 100+ items)
how to get to this query when paging ? maybe setPageSize(1000), but
I'm not sure.
Marcin
On 23/06/2008, at 9:27 PM, Øyvind Harboe (JIRA) wrote:
> Derby adapter uses recursive implementation for orExp()
> -------------------------------------------------------
>
> Key: CAY-1079
> URL: https://issues.apache.org/cayenne/browse/CAY-1079
> Project: Cayenne
> Issue Type: Bug
> Components: Cayenne Core Library
> Affects Versions: 3.0
> Reporter: Øyvind Harboe
> Assignee: Andrus Adamchik
>
>
> I get this exception w/paged queries.
>
> I need to make a note of this bug and get back to it.
>
> at org.apache.derby.impl.sql.compile.OrNode.bindExpression(Unknown
> Source)
> at
> org
> .apache
> .derby.impl.sql.compile.BinaryOperatorNode.bindExpression(Unknown
> Source)
> at
> org
> .apache
> .derby
> .impl.sql.compile.BinaryLogicalOperatorNode.bindExpression(Unknown
> Source)
> at org.apache.derby.impl.sql.compile.OrNode.bindExpression(Unknown
> Source)
> at
> org
> .apache
> .derby.impl.sql.compile.BinaryOperatorNode.bindExpression(Unknown
> Source)
> at
> org
> .apache
> .derby
> .impl.sql.compile.BinaryLogicalOperatorNode.bindExpression(Unknown
> Source)
> at org.apache.derby.impl.sql.compile.OrNode.bindExpression(Unknown
> Source)
> at
> org
> .apache
> .derby.impl.sql.compile.BinaryOperatorNode.bindExpression(Unknown
> Source)
> at
> org
> .apache
> .derby
> .impl.sql.compile.BinaryLogicalOperatorNode.bindExpression(Unknown
> Source)
> at org.apache.derby.impl.sql.compile.OrNode.bindExpression(Unknown
> Source)
> at
> org
> .apache
> .derby.impl.sql.compile.BinaryOperatorNode.bindExpression(Unknown
> Source)
> at
> org
> .apache
> .derby
> .impl.sql.compile.BinaryLogicalOperatorNode.bindExpression(Unknown
> Source)
> at org.apache.derby.impl.sql.compile.OrNode.bindExpression(Unknown
> Source)
> at
> org
> .apache
> .derby.impl.sql.compile.BinaryOperatorNode.bindExpression(Unknown
> Source)
> at
> org
> .apache
> .derby
> .impl.sql.compile.BinaryLogicalOperatorNode.bindExpression(Unknown
> Source)
> at org.apache.derby.impl.sql.compile.OrNode.bindExpression(Unknown
> Source)
> at
> org
> .apache
> .derby.impl.sql.compile.BinaryOperatorNode.bindExpression(Unknown
> Source)
> at
> org
> .apache
> .derby
> .impl.sql.compile.BinaryLogicalOperatorNode.bindExpression(Unknown
> Source)
>
>
> --
> This message is automatically generated by JIRA.
> -
> You can reply to this email to add a comment to the issue online.
>
This archive was generated by hypermail 2.0.0 : Thu Jul 03 2008 - 04:07:59 EDT