[jira] Commented: (CAY-1059) (Remote)IncrementalFaultList resolveAll() fails

["Andrus Adamchik (JIRA)" <de...@cayenne.apache.org>]

    [ https://issues.apache.org/cayenne/browse/CAY-1059?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12870#action_12870 ] 

Andrus Adamchik commented on CAY-1059:
--------------------------------------

Actually IncrementalFaultList (server-side one) has a property "maxFetchSize" which is by default set to 10000. This was done to address a similar problem for PostgreSQL. There's currently no way to change this parameter via ROP (or via a SelectQuery)... As a quick fix you may try some lower default values, and see which threshold works for Derby. If it is not too low, we can change that in Cayenne. For the future I guess that should become one of the query hints...

> (Remote)IncrementalFaultList resolveAll() fails 
> ------------------------------------------------
>
>                 Key: CAY-1059
>                 URL: https://issues.apache.org/cayenne/browse/CAY-1059
>             Project: Cayenne
>          Issue Type: Bug
>          Components: Cayenne Core Library
>         Environment: OS X 10.5 , derby, remote cayenne
>            Reporter: Marcin Skladaniec
>            Assignee: Andrus Adamchik
>
> Iterating trough all select query results is best done using non-paged query, but sometimes though it happens that the paged list has to be iterated also.
> There is a method in the API resolveAll() which seems to be suited for this case, but unfortunately it does not work on big lists (in our case 50000+ records). I'm not sure if this is a derby thing only, but it seems like the generated expression (set of ObjectIdQueries) is too long.  
> Exception : 
>      [java] java.sql.SQLException: Java exception: ': java.lang.StackOverflowError'.
>      [java] 	at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
>      [java] 	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
>      [java] 	at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source)
>      [java] 	at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
>      [java] 	at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
>      [java] 	at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
>      [java] 	at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
>      [java] 	at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
>      [java] 	at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
>      [java] 	at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
>      [java] 	at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Unknown Source)
>      [java] 	at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
>      [java] 	at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
>      [java] 	at org.apache.cayenne.conn.ConnectionWrapper.prepareStatement(ConnectionWrapper.java:274)
>      [java] 	at org.apache.cayenne.conn.ConnectionWrapper.prepareStatement(ConnectionWrapper.java:280)
>      [java] 	at org.apache.cayenne.access.TransactionConnectionDecorator.prepareStatement(TransactionConnectionDecorator.java:179)
>      [java] 	at org.apache.cayenne.access.trans.QueryAssembler.createStatement(QueryAssembler.java:118)
>      [java] 	at org.apache.cayenne.access.jdbc.SelectAction.performAction(SelectAction.java:72)
>      [java] 	at org.apache.cayenne.access.DataNodeQueryAction.runQuery(DataNodeQueryAction.java:58)
>      [java] 	at org.apache.cayenne.access.DataNode.performQueries(DataNode.java:230)
>      [java] 	at org.apache.cayenne.access.DataDomainQueryAction.runQuery(DataDomainQueryAction.java:424)
>      [java] 	at org.apache.cayenne.access.DataDomainQueryAction.access$000(DataDomainQueryAction.java:68)
>      [java] 	at org.apache.cayenne.access.DataDomainQueryAction$2.transform(DataDomainQueryAction.java:397)
>      [java] 	at org.apache.cayenne.access.DataDomain.runInTransaction(DataDomain.java:847)
>      [java] 	at org.apache.cayenne.access.DataDomainQueryAction.runQueryInTransaction(DataDomainQueryAction.java:394)
>      [java] 	at org.apache.cayenne.access.DataDomainQueryAction.execute(DataDomainQueryAction.java:120)
>      [java] 	at org.apache.cayenne.access.DataDomain.onQuery(DataDomain.java:740)
>      [java] 	at org.apache.cayenne.util.ObjectContextQueryAction.runQuery(ObjectContextQueryAction.java:317)
>      [java] 	at org.apache.cayenne.util.ObjectContextQueryAction.execute(ObjectContextQueryAction.java:96)
>      [java] 	at org.apache.cayenne.access.DataContext.onQuery(DataContext.java:1336)
>      [java] 	at org.apache.cayenne.access.DataContext.performQuery(DataContext.java:1325)
>      [java] 	at org.apache.cayenne.access.IncrementalFaultList.resolveInterval(IncrementalFaultList.java:353)
>      [java] 	at org.apache.cayenne.access.IncrementalFaultList.subList(IncrementalFaultList.java:687)
>      [java] 	at org.apache.cayenne.access.ClientServerChannelQueryAction.interceptSinglePageQuery(ClientServerChannelQueryAction.java:109)
>      [java] 	at org.apache.cayenne.access.ClientServerChannelQueryAction.execute(ClientServerChannelQueryAction.java:65)
>      [java] 	at org.apache.cayenne.access.ClientServerChannel.onQuery(ClientServerChannel.java:82)
>      [java] 	at org.apache.cayenne.remote.service.DispatchHelper.dispatch(DispatchHelper.java:40)
>      [java] 	at org.apache.cayenne.remote.service.BaseRemoteService.processMessage(BaseRemoteService.java:153)
>      [java] 	at sun.reflect.GeneratedMethodAccessor11.invoke(Unknown Source)
>      [java] 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>      [java] 	at java.lang.reflect.Method.invoke(Method.java:585)
>      [java] 	at com.caucho.hessian.server.HessianSkeleton.invoke(HessianSkeleton.java:180)
>      [java] 	at com.caucho.hessian.server.HessianSkeleton.invoke(HessianSkeleton.java:109)
>      [java] 	at com.caucho.hessian.server.HessianServlet.service(HessianServlet.java:393)
>      [java] 	at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
>      [java] 	at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1093)
>      [java] 	at ish.oncourse.server.SecurityFilter.doFilter(SecurityFilter.java:112)
>      [java] 	at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
>      [java] 	at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)
>      [java] 	at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
>      [java] 	at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
>      [java] 	at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:726)
>      [java] 	at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:206)
>      [java] 	at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
>      [java] 	at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
>      [java] 	at org.mortbay.jetty.Server.handle(Server.java:324)
>      [java] 	at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505)
>      [java] 	at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:842)
>      [java] 	at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:730)
>      [java] 	at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:205)
>      [java] 	at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380)
>      [java] 	at org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228)
>      [java] 	at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:450)
>      [java] Caused by: java.lang.StackOverflowError
>      [java] 	at org.apache.derby.impl.sql.compile.BinaryOperatorNode.bindExpression(Unknown Source)
>      [java] 	at org.apache.derby.impl.sql.compile.BinaryLogicalOperatorNode.bindExpression(Unknown Source)
>      [java] 	at org.apache.derby.impl.sql.compile.OrNode.bindExpression(Unknown Source)
>      [java] 	at org.apache.derby.impl.sql.compile.BinaryOperatorNode.bindExpression(Unknown Source)
>      [java] 	at org.apache.derby.impl.sql.compile.BinaryLogicalOperatorNode.bindExpression(Unknown Source)
>      [java] 	at org.apache.derby.impl.sql.compile.OrNode.bindExpression(Unknown Source)
>      [java] 	at org.apache.derby.impl.sql.compile.BinaryOperatorNode.bindExpression(Unknown Source)
>      [java] 	at org.apache.derby.impl.sql.compile.BinaryLogicalOperatorNode.bindExpression(Unknown Source)
>      [java] 	at org.apache.derby.impl.sql.compile.OrNode.bindExpression(Unknown Source)
>      [java] 	at org.apache.derby.impl.sql.compile.BinaryOperatorNode.bindExpression(Unknown Source)
>      [java] 	at org.apache.derby.impl.sql.compile.BinaryLogicalOperatorNode.bindExpression(Unknown Source)
>      [java] 	at org.apache.derby.impl.sql.compile.OrNode.bindExpression(Unknown Source)
>      [java] 	at org.apache.derby.impl.sql.compile.BinaryOperatorNode.bindExpression(Unknown Source)
>      [java] 	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.