ResultSet is FORWARD_ONLY.
Locked
ResultSet is FORWARD_ONLY.
 
|
Re: ResultSet is FORWARD_ONLY.
|
|
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 get > > 2009-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][Boolea > n] > 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 scroll > able 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.GenericEntityException > Message: Error setting the cursor to first (Operation requires a > scrollable ResultSet, but this ResultSet is FORWARD_ONLY.) > ---- cause > --------------------------------------------------------------------- > Exception: org.postgresql.util.PSQLException > Message: 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 (3K)
Re: ResultSet is FORWARD_ONLY.
|
|
Re: ResultSet is FORWARD_ONLY.
|
|
Re: ResultSet is FORWARD_ONLY.
|
|
In reply to this post by Jacopo Cappellato-4
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.GenericEntityException > Message: 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 get >>> >>> 2009-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][Boolea >>> n] >>> 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 scroll >>> able 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.GenericEntityException >>> Message: Error setting the cursor to first (Operation requires a >>> scrollable ResultSet, but this ResultSet is FORWARD_ONLY.) >>> ---- cause >>> --------------------------------------------------------------------- >>> Exception: org.postgresql.util.PSQLException >>> Message: 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 >> > |
Re: ResultSet is FORWARD_ONLY.
|
|
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.GenericEntityException Message: 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.GenericEntityException >> Message: 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 get >>>> >>>> 2009-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][Boolea >>>> n] >>>> 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 scroll >>>> able 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.GenericEntityException >>>> Message: Error setting the cursor to first (Operation requires a >>>> scrollable ResultSet, but this ResultSet is FORWARD_ONLY.) >>>> ---- cause >>>> --------------------------------------------------------------------- >>>> Exception: org.postgresql.util.PSQLException >>>> Message: 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 >>> >> > |
Re: ResultSet is FORWARD_ONLY.
|
|
Thanks Mridul, fixed in r809554
Regards Scott On 31/08/2009, at 11:47 PM, Mridul Pathak wrote: > 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.GenericEntityException > Message: 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.GenericEntityException >>> Message: 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 get >>>>> >>>>> 2009-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][Boolea >>>>> n] >>>>> 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 scroll >>>>> able 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.GenericEntityException >>>>> Message: Error setting the cursor to first (Operation requires a >>>>> scrollable ResultSet, but this ResultSet is FORWARD_ONLY.) >>>>> ---- cause >>>>> --------------------------------------------------------------------- >>>>> Exception: org.postgresql.util.PSQLException >>>>> Message: 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 >>>> >>> >> > |
| Free forum by Nabble | Edit this page |