Uploaded image for project: 'Cayenne'
  1. Cayenne
  2. CAY-1079

Derby adapter uses recursive implementation for orExp()

    Details

    • Type: Bug
    • Status: Open
    • Priority: 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
        oharboe Ø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
        oharboe Ø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 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 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
        oharboe Øyvind Harboe added a comment - https://issues.apache.org/jira/browse/DERBY-3876
        Hide
        oharboe Ø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
        oharboe Ø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 Andrus Adamchik
            Reporter:
            oharboe Øyvind Harboe
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:

              Development