Cayenne
  1. Cayenne
  2. CAY-1079

Derby adapter uses recursive implementation for orExp()

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: 3.0
    • Fix Version/s: None
    • Component/s: Core Library
    • Labels:
      None

      Description

      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)

        Activity

        Hide
        Øyvind Harboe added a comment -

        This is how the derby database is implemented and a fix would belong there. I ran into other problems when trying to run this test with the latest version of Derby, could have been fixed there.

        I don't really view this as a Cayenne bug, though IncrementalFaultList is vulnerable to problems with long select statements and the database adapter doesn't have a way to influence the length of the select statement in the IncrementalFaultList.

        Show
        Øyvind Harboe added a comment - This is how the derby database is implemented and a fix would belong there. I ran into other problems when trying to run this test with the latest version of Derby, could have been fixed there. I don't really view this as a Cayenne bug, though IncrementalFaultList is vulnerable to problems with long select statements and the database adapter doesn't have a way to influence the length of the select statement in the IncrementalFaultList.
        Hide
        Andrus Adamchik added a comment -

        actually IncrementalFaultList has a method to deal with this: 'setMaxFetchSize'. Interesting idea is to set the default per adapter

        Show
        Andrus Adamchik added a comment - actually IncrementalFaultList has a method to deal with this: 'setMaxFetchSize'. Interesting idea is to set the default per adapter
        Show
        Øyvind Harboe added a comment - https://issues.apache.org/jira/browse/DERBY-3876
        Hide
        Øyvind Harboe added a comment -

        I got hit by this again as Derby runs out of stack. It's easy to get hit by this even in well tested code as it only fails as the database grows....

        Show
        Øyvind Harboe added a comment - I got hit by this again as Derby runs out of stack. It's easy to get hit by this even in well tested code as it only fails as the database grows....

          People

          • Assignee:
            Andrus Adamchik
            Reporter:
            Øyvind Harboe
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:

              Development