Hi Scott,Pagination is not working on https://localhost:8443/webtools/control/FindGeneric screen. Throwing following error on latest revision:
2009-08-31 16:55:05,759 (http-0.0.0.0-8443-6) [ EntityListIterator.java:218:WARN ] Warning: auto-closed EntityListIterator because of exception: java.sql.SQLException: The 'absolute()' method is only allowed on scroll cursors. 2009-08-31 16:55:05,765 (http-0.0.0.0-8443-6) [ CallSiteArray.java:43 :ERROR] ---- exception report ----------------------------------------------------------
Failure in operation, rolling back transaction Exception: org.ofbiz.entity.GenericEntityExceptionMessage: Error setting the absolute index to 4801 (The 'absolute()' method is only allowed on scroll cursors.) ---- cause ---------------------------------------------------------------------
Exception: org.apache.derby.impl.jdbc.EmbedSQLException Message: The 'absolute()' method is only allowed on scroll cursors.---- stack trace --------------------------------------------------------------- java.sql.SQLException: The 'absolute()' method is only allowed on scroll cursors. org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)org.apache.derby.impl.jdbc.EmbedResultSet.checkScrollCursor(Unknown Source)
org.apache.derby.impl.jdbc.EmbedResultSet.absolute(Unknown Source)org .apache .commons.dbcp.DelegatingResultSet.absolute(DelegatingResultSet.java:335) org .apache .commons.dbcp.DelegatingResultSet.absolute(DelegatingResultSet.java:335) org .ofbiz.entity.util.EntityListIterator.absolute(EntityListIterator.java: 214) org .ofbiz .entity.util.EntityListIterator.getPartialList(EntityListIterator.java: 472)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)sun .reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java: 39) sun .reflect .DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java: 25)
java.lang.reflect.Method.invoke(Method.java:585)org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite $PojoCachedMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java: 229) org .codehaus .groovy .runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:52) org .codehaus .groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java: 128)
FindGeneric.run(FindGeneric.groovy:177)Posting it here as this thread seems to be dealing with similar problems.
-- Thanks, Mridul Pathak On 31-Aug-09, at 3:47 AM, Scott Gray wrote:
Thanks Jacopo, should be fixed in r809425, I've given up on using forward only for now and reverted back to scroll insensitive.Regards Scott On 31/08/2009, at 5:52 AM, Jacopo Cappellato wrote:Scott, I am still getting errors in many screens, for example: https://localhost:8443/facility/control/ViewFacilityInventoryItemsDetails?facilityId=WebStoreWarehouse the error in the log is:Error rewinding list form render EntityListIterator: org.ofbiz.entity.GenericEntityException: Error setting the cursor to first (The 'isFirst' method is only allowed on scroll cursors.)Exception: org.ofbiz.entity.GenericEntityExceptionMessage: Error setting the cursor to first (The 'isFirst' method is only allowed on scroll cursors.) ---- cause ---------------------------------------------------------------------Exception: org.apache.derby.impl.jdbc.EmbedSQLException Message: The 'isFirst' method is only allowed on scroll cursors.---- stack trace --------------------------------------------------------------- java.sql.SQLException: The 'isFirst' method is only allowed on scroll cursors. org .apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)org.apache.derby.impl.jdbc.EmbedResultSet.checkScrollCursor(Unknown Source) org.apache.derby.impl.jdbc.EmbedResultSet.checkRowPosition(Unknown Source)org.apache.derby.impl.jdbc.EmbedResultSet.isFirst(Unknown Source)org .apache .commons.dbcp.DelegatingResultSet.isFirst(DelegatingResultSet.java: 314) org .apache .commons.dbcp.DelegatingResultSet.isFirst(DelegatingResultSet.java: 314) org .ofbiz.entity.util.EntityListIterator.first(EntityListIterator.java: 140)org.ofbiz.widget.form.ModelForm.preparePager(ModelForm.java:1349) or in screen: https://localhost:8443/ordermgr/control/findreturn where the error is:java.sql.SQLException: ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF. org .apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source) org.apache.derby.impl.jdbc.ConnectionChild.newSQLException(Unknown Source) org.apache.derby.impl.jdbc.EmbedResultSet.checkIfClosed(Unknown Source) org.apache.derby.impl.jdbc.EmbedResultSet.checkExecIfClosed(Unknown Source) org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown Source)org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source)org .apache .commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:169) org .apache .commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:169) org .ofbiz.entity.util.EntityListIterator.next(EntityListIterator.java: 344) org .ofbiz.entity.util.EntityListIterator.next(EntityListIterator.java: 48)org.ofbiz.widget.form.ModelForm.safeNext(ModelForm.java:1284)I will try to have a look at them later tonight if you don't beat me before.Jacopo On Aug 30, 2009, at 2:37 PM, Scott Gray wrote:Thanks Jacques, should be fixed in r809324 Regards Scott HotWax Media http://www.hotwaxmedia.com On 30/08/2009, at 10:36 PM, Jacques Le Roux wrote:Click "Inventory Items" menu and click "Find" (https://localhost:18443/facility/control/EditFacilityInventoryItems ) you get2009-08-30 09:43:25,593 (http-0.0.0.0-18443-5) [ ControlServlet.java:130:INFO ] [[[EditFacilityInventoryItems] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] 2009-08-30 09:43:25,593 (http-0.0.0.0-18443-5) [ RequestHandler.java:716:INFO ] Rendering View [EditFacilityInventoryItems], sessionId=6D587C24284D4B23F7269FC26AFB92B0.jvm1 2009-08-30 09:43:25,687 (http-0.0.0.0-18443-5) [ ServiceEcaRule.java:134:INFO ] For Service ECA [facilityGenericPermission] on [return] got false for condition: [hasPermission][equals][false][true][Boolean]2009-08-30 09:43:25,718 (http-0.0.0.0-18443-5) [ UtilXml.java:1016:ERROR] XmlFileLoader: File file:/ D:/workspace/ofbizRun/applications/product/webapp/facility/ facility/FacilityForms.xml process err or. Line: 608. Error message: cvc-complex-type.2.3: Element 'form' cannot have character [children], because the type's content type is element-only. 2009-08-30 09:43:25,750 (http-0.0.0.0-18443-5) [ UtilProperties.java:870:INFO ] ResourceBundle conditional (en) created in 0.016s with 14 properties 2009-08-30 09:43:25,781 (http-0.0.0.0-18443-5) [ UtilXml.java:1016:ERROR] XmlFileLoader: File file:/ D:/workspace/ofbizRun/applications/product/webapp/facility/ facility/FacilityForms.xml process err or. Line: 608. Error message: cvc-complex-type.2.3: Element 'form' cannot have character [children], because the type's content type is element-only. 2009-08-30 09:43:25,875 (http-0.0.0.0-18443-5) [ ServiceDispatcher.java:585:INFO ] Sync service [facility/ executeFind] finished in [94] milliseconds 2009-08-30 09:43:25,875 (http-0.0.0.0-18443-5) [ ServiceDispatcher.java:585:INFO ] Sync service [facility/ performFind] finished in [94] milliseconds 2009-08-30 09:43:25,906 (http-0.0.0.0-18443-5) [ EntityListIterator.java:143:WARN ] Warning: auto-closed EntityListIterator because of exception: org.postgresql.util.PSQLException: Operation requires a scrollable ResultSet, but this ResultSet is FORWARD_ONLY.2009-08-30 09:43:25,906 (http-0.0.0.0-18443-5) [ ModelForm.java:1351:ERROR] ---- exception report ---------------------------------------------------------- Error rewinding list form render EntityListIterator: org.ofbiz.entity.GenericEntityException: Error setting the cursor to first (Operation requires a scrollable ResultSet, but this ResultSet is FORWARD_ONLY.)Exception: org.ofbiz.entity.GenericEntityExceptionMessage: Error setting the cursor to first (Operation requires a scrollable ResultSet, but this ResultSet is FORWARD_ONLY.) ---- cause ---------------------------------------------------------------------Exception: org.postgresql.util.PSQLExceptionMessage: Operation requires a scrollable ResultSet, but this ResultSet is FORWARD_ONLY. ---- stack trace --------------------------------------------------------------- org.postgresql.util.PSQLException: Operation requires a scrollable ResultSet, but this ResultSet is FORWARD_ONLY. org .postgresql .jdbc2 .AbstractJdbc2ResultSet .checkScrollable(AbstractJdbc2ResultSet.java:206) org .postgresql .jdbc2.AbstractJdbc2ResultSet.first(AbstractJdbc2ResultSet.java: 291) org .apache .commons.dbcp.DelegatingResultSet.first(DelegatingResultSet.java: 326) org .apache .commons.dbcp.DelegatingResultSet.first(DelegatingResultSet.java: 326) org .ofbiz .entity.util.EntityListIterator.first(EntityListIterator.java:139)org.ofbiz.widget.form.ModelForm.preparePager(ModelForm.java:1349)org .ofbiz.widget.form.ModelForm.renderListFormString(ModelForm.java: 1059) org.ofbiz.widget.form.ModelForm.renderFormString(ModelForm.java: 819) org.ofbiz.widget.screen.ModelScreenWidget $Form.renderWidgetString(ModelScreenWidget.java:847) org .ofbiz .widget .screen .ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java: 157) org.ofbiz.widget.screen.ModelScreenWidget $DecoratorSection.renderWidgetString(ModelScreenWidget.java:710) org.ofbiz.widget.screen.ModelScreenWidget $SectionsRenderer.render(ModelScreenWidget.java:187) org.ofbiz.widget.screen.ModelScreenWidget $ DecoratorSectionInclude.renderWidgetString(ModelScreenWidget.java: 742) org .ofbiz .widget .screen .ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java: 157) org.ofbiz.widget.screen.ModelScreenWidget $Container.renderWidgetString(ModelScreenWidget.java:316) org .ofbiz .widget .screen .ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java: 157) org.ofbiz.widget.screen.ModelScreenWidget $Container.renderWidgetString(ModelScreenWidget.java:316) org .ofbiz .widget .screen .ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java: 157) org.ofbiz.widget.screen.ModelScreenWidget $Section.renderWidgetString(ModelScreenWidget.java:248) org .ofbiz .widget.screen.ModelScreen.renderScreenString(ModelScreen.java:393) org.ofbiz.widget.screen.ModelScreenWidget $DecoratorScreen.renderWidgetString(ModelScreenWidget.java:678) org .ofbiz .widget .screen .ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java: 157) org.ofbiz.widget.screen.ModelScreenWidget $DecoratorSection.renderWidgetString(ModelScreenWidget.java:710) org.ofbiz.widget.screen.ModelScreenWidget $SectionsRenderer.render(ModelScreenWidget.java:187) org.ofbiz.widget.screen.ModelScreenWidget $ DecoratorSectionInclude.renderWidgetString(ModelScreenWidget.java: 742) org .ofbiz .widget .screen .ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java: 157) org.ofbiz.widget.screen.ModelScreenWidget $Section.renderWidgetString(ModelScreenWidget.java:248) org .ofbiz .widget .screen .ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java: 157) org.ofbiz.widget.screen.ModelScreenWidget $Section.renderWidgetString(ModelScreenWidget.java:248) org .ofbiz .widget .screen .ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java: 157) org.ofbiz.widget.screen.ModelScreenWidget $DecoratorSection.renderWidgetString(ModelScreenWidget.java:710) org.ofbiz.widget.screen.ModelScreenWidget $SectionsRenderer.render(ModelScreenWidget.java:187) org.ofbiz.widget.screen.ModelScreenWidget $ DecoratorSectionInclude.renderWidgetString(ModelScreenWidget.java: 742) org .ofbiz .widget .screen .ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java: 157) org.ofbiz.widget.screen.ModelScreenWidget $Container.renderWidgetString(ModelScreenWidget.java:316) org .ofbiz .widget .screen .ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java: 157) org.ofbiz.widget.screen.ModelScreenWidget $Container.renderWidgetString(ModelScreenWidget.java:316) org .ofbiz .widget .screen .ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java: 157) org.ofbiz.widget.screen.ModelScreenWidget $Container.renderWidgetString(ModelScreenWidget.java:316) org .ofbiz .widget .screen .ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java: 157) org.ofbiz.widget.screen.ModelScreenWidget $Section.renderWidgetString(ModelScreenWidget.java:248) org .ofbiz .widget.screen.ModelScreen.renderScreenString(ModelScreen.java:393) org.ofbiz.widget.screen.ModelScreenWidget $IncludeScreen.renderWidgetString(ModelScreenWidget.java:582) org .ofbiz .widget .screen .ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java: 157) org.ofbiz.widget.screen.ModelScreenWidget $Section.renderWidgetString(ModelScreenWidget.java:248) org .ofbiz .widget.screen.ModelScreen.renderScreenString(ModelScreen.java:393) org.ofbiz.widget.screen.ModelScreenWidget $IncludeScreen.renderWidgetString(ModelScreenWidget.java:582) org .ofbiz .widget .screen .ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java: 157) org.ofbiz.widget.screen.ModelScreenWidget $Section.renderWidgetString(ModelScreenWidget.java:248) org .ofbiz .widget.screen.ModelScreen.renderScreenString(ModelScreen.java:393) org.ofbiz.widget.screen.ModelScreenWidget $DecoratorScreen.renderWidgetString(ModelScreenWidget.java:678) org .ofbiz .widget .screen .ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java: 157) org.ofbiz.widget.screen.ModelScreenWidget $Section.renderWidgetString(ModelScreenWidget.java:248) org .ofbiz .widget.screen.ModelScreen.renderScreenString(ModelScreen.java:393) org.ofbiz.widget.screen.ModelScreenWidget $DecoratorScreen.renderWidgetString(ModelScreenWidget.java:678) org .ofbiz .widget .screen .ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java: 157) org.ofbiz.widget.screen.ModelScreenWidget $Section.renderWidgetString(ModelScreenWidget.java:248) org .ofbiz .widget.screen.ModelScreen.renderScreenString(ModelScreen.java:393) org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java: 132) org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java: 95) org .ofbiz .widget .screen.MacroScreenViewHandler.render(MacroScreenViewHandler.java: 114) org .ofbiz .webapp.control.RequestHandler.renderView(RequestHandler.java:808) org .ofbiz .webapp.control.RequestHandler.doRequest(RequestHandler.java:550) org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java: 215)javax.servlet.http.HttpServlet.service(HttpServlet.java:690) javax.servlet.http.HttpServlet.service(HttpServlet.java:803)org .apache .catalina .core .ApplicationFilterChain .internalDoFilter(ApplicationFilterChain.java:290) org .apache .catalina .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: 206) org .ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java: 265) org .apache .catalina .core .ApplicationFilterChain .internalDoFilter(ApplicationFilterChain.java:235) org .apache .catalina .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: 206) org .apache .catalina .core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) org .apache .catalina .core.StandardContextValve.invoke(StandardContextValve.java:175) org .apache .catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) org .apache .catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) org .apache .catalina .core.StandardEngineValve.invoke(StandardEngineValve.java:109) org .apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java: 568) org .apache .catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) org .apache .coyote.http11.Http11Processor.process(Http11Processor.java:844) org.apache.coyote.http11.Http11Protocol $Http11ConnectionHandler.process(Http11Protocol.java:583) org.apache.tomcat.util.net.JIoEndpoint $Worker.run(JIoEndpoint.java:447)java.lang.Thread.run(Thread.java:619) --------------------------------------------------------------------------------2009-08-30 09:43:25,906 (http-0.0.0.0-18443-5) [ ModelScreen.java:398:ERROR] Error rendering screen [component://common/widget/ CommonScreens.xml#FindScreenDecorator]: org.ofbiz.base.util.GeneralRuntime Exception: Error getting the next result (This ResultSet is closed.). Rolling back transaction.Seems to be relate to Scott's recent work. I'm using PostGres 8.4 with postgresql-8.3-603.jdbc3.jar on XPsp3. Note that one time (I don't remember how exactly) I got the right result.Jacques
smime.p7s
Description: S/MIME cryptographic signature
