MSAccess adapter does not support paged queries
-----------------------------------------------
Key: CAY-543
URL: http://issues.apache.org/cayenne/browse/CAY-543
Project: Cayenne
Type: Bug
Versions: AFTER 1.2
Reporter: Øyvind Harboe
This is for the MSAccess adapter I'm working on. I intend to fix this myself(sometime in the forseable future, I really need to run some unit tests that Cayenne has built in).
DataContext context=getDataContext();
SelectQuery query=new SelectQuery(Treatment.class);
query.setPageSize(50); // if I don't set page size, then the query works fine
creatmentList=context.performQuery(query);
unlabeledMessage: Error performing query.
Stack Trace:
* org.objectstyle.cayenne.access.IncrementalFaultList.fillIn(IncrementalFaultList.java:265)
* org.objectstyle.cayenne.access.IncrementalFaultList.<init>(IncrementalFaultList.java:192)
* org.objectstyle.cayenne.access.DataContextQueryAction.interceptPaginatedQuery(DataContextQueryAction.java:128)
* org.objectstyle.cayenne.access.DataContextQueryAction.execute(DataContextQueryAction.java:86)
* org.objectstyle.cayenne.access.DataContext.onQuery(DataContext.java:1320)
* org.objectstyle.cayenne.access.DataContext.performQuery(DataContext.java:1309)
* com.zylin.payback.app.tapestry.Visit.getTreatments(Visit.java:35)
* sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
* sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
* sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
* java.lang.reflect.Method.invoke(Unknown Source)
* ognl.OgnlRuntime.invokeMethod(OgnlRuntime.java:491)
* ognl.OgnlRuntime.getMethodValue(OgnlRuntime.java:904)
* ognl.ObjectPropertyAccessor.getPossibleProperty(ObjectPropertyAccessor.java:54)
* ognl.ObjectPropertyAccessor.getProperty(ObjectPropertyAccessor.java:122)
* ognl.OgnlRuntime.getProperty(OgnlRuntime.java:1616)
* ognl.ASTProperty.getValueBody(ASTProperty.java:96)
* ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:170)
* ognl.SimpleNode.getValue(SimpleNode.java:210)
* ognl.ASTChain.getValueBody(ASTChain.java:109)
* ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:170)
* ognl.SimpleNode.getValue(SimpleNode.java:210)
* ognl.Ognl.getValue(Ognl.java:333)
* ognl.Ognl.getValue(Ognl.java:310)
* org.apache.tapestry.binding.ExpressionBinding.resolveProperty(ExpressionBinding.java:201)
* org.apache.tapestry.binding.ExpressionBinding.getObject(ExpressionBinding.java:194)
* com.zylin.payback.app.html.QPBTable.getList(QPBTable.java:14)
* com.zylin.payback.app.html.QPBTable.validPos(QPBTable.java:37)
* com.zylin.payback.app.html.QPBTable.getPageList(QPBTable.java:23)
* sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
* sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
* sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
* java.lang.reflect.Method.invoke(Unknown Source)
* ognl.OgnlRuntime.invokeMethod(OgnlRuntime.java:491)
* ognl.OgnlRuntime.getMethodValue(OgnlRuntime.java:904)
* ognl.ObjectPropertyAccessor.getPossibleProperty(ObjectPropertyAccessor.java:54)
* ognl.ObjectPropertyAccessor.getProperty(ObjectPropertyAccessor.java:122)
* ognl.OgnlRuntime.getProperty(OgnlRuntime.java:1616)
* ognl.ASTProperty.getValueBody(ASTProperty.java:96)
* ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:170)
* ognl.SimpleNode.getValue(SimpleNode.java:210)
* ognl.ASTChain.getValueBody(ASTChain.java:109)
* ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:170)
* ognl.SimpleNode.getValue(SimpleNode.java:210)
* ognl.ASTAdd.getValueBody(ASTAdd.java:55)
* ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:170)
* ognl.SimpleNode.getValue(SimpleNode.java:210)
* ognl.Ognl.getValue(Ognl.java:333)
* ognl.Ognl.getValue(Ognl.java:310)
* org.apache.tapestry.binding.ExpressionBinding.resolveProperty(ExpressionBinding.java:201)
* org.apache.tapestry.binding.ExpressionBinding.getObject(ExpressionBinding.java:194)
* org.apache.tapestry.binding.AbstractBinding.getObject(AbstractBinding.java:208)
* org.apache.tapestry.param.AbstractParameterConnector.getBindingValue(AbstractParameterConnector.java:105)
* org.apache.tapestry.param.ObjectParameterConnector.setParameter(ObjectParameterConnector.java:53)
* org.apache.tapestry.param.ParameterManager.setParameters(ParameterManager.java:105)
* org.apache.tapestry.AbstractComponent.prepareForRender(AbstractComponent.java:898)
* org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:853)
* org.apache.tapestry.AbstractComponent.renderBody(AbstractComponent.java:624)
* org.apache.tapestry.form.Form.renderComponent(Form.java:362)
* org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:857)
* org.apache.tapestry.BaseComponent.renderComponent(BaseComponent.java:118)
* org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:857)
* org.apache.tapestry.AbstractComponent.renderBody(AbstractComponent.java:624)
* org.apache.tapestry.components.RenderBody.renderComponent(RenderBody.java:45)
* org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:857)
* org.apache.tapestry.AbstractComponent.renderBody(AbstractComponent.java:624)
* org.apache.tapestry.html.Body.renderComponent(Body.java:269)
* org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:857)
* org.apache.tapestry.AbstractComponent.renderBody(AbstractComponent.java:624)
* org.apache.tapestry.html.Shell.renderComponent(Shell.java:124)
* org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:857)
* org.apache.tapestry.BaseComponent.renderComponent(BaseComponent.java:118)
* org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:857)
* org.apache.tapestry.BaseComponent.renderComponent(BaseComponent.java:118)
* org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:857)
* org.apache.tapestry.AbstractPage.renderPage(AbstractPage.java:300)
* org.apache.tapestry.engine.RequestCycle.renderPage(RequestCycle.java:368)
* org.apache.tapestry.engine.AbstractEngine.renderResponse(AbstractEngine.java:749)
* org.apache.tapestry.engine.PageService.service(PageService.java:77)
* org.apache.tapestry.engine.AbstractEngine.service(AbstractEngine.java:889)
* org.apache.tapestry.ApplicationServlet.doService(ApplicationServlet.java:198)
* org.apache.tapestry.ApplicationServlet.doGet(ApplicationServlet.java:159)
* javax.servlet.http.HttpServlet.service(HttpServlet.java:596)
* javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
* org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428)
* org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:473)
* org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568)
* org.mortbay.http.HttpContext.handle(HttpContext.java:1530)
* org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633)
* org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
* org.mortbay.http.HttpServer.service(HttpServer.java:909)
* org.mortbay.http.HttpConnection.service(HttpConnection.java:820)
* org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:986)
* org.mortbay.http.HttpConnection.handle(HttpConnection.java:837)
* org.mortbay.http.SocketListener.handleConnection(SocketListener.java:245)
* org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)
* org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
* Caused by: java.sql.SQLException: [Microsoft][ODBC Driver Manager] Function sequence error
* sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
* sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
* sun.jdbc.odbc.JdbcOdbc.SQLGetDataInteger(Unknown Source)
* sun.jdbc.odbc.JdbcOdbcResultSet.getDataInteger(Unknown Source)
* sun.jdbc.odbc.JdbcOdbcResultSet.getInt(Unknown Source)
* sun.reflect.GeneratedMethodAccessor8.invoke(Unknown Source)
* sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
* java.lang.reflect.Method.invoke(Unknown Source)
* org.objectstyle.cayenne.access.types.DefaultType.materializeObject(DefaultType.java:221)
* org.objectstyle.cayenne.access.jdbc.JDBCResultIterator.readDataRow(JDBCResultIterator.java:305)
* org.objectstyle.cayenne.access.jdbc.JDBCResultIterator.nextDataRow(JDBCResultIterator.java:163)
* org.objectstyle.cayenne.access.IncrementalFaultList.fillIn(IncrementalFaultList.java:236)
* ... 96 more
-- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/cayenne/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
This archive was generated by hypermail 2.0.0 : Sat May 06 2006 - 03:19:37 EDT