You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by Jacques Le Roux <ja...@free.fr> on 2009/08/30 12:36:20 UTC
ResultSet is FORWARD_ONLY.
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.
Posted by Jacques Le Roux <ja...@free.fr>.
Sorry Scott, I still get the same error (after ant clean-all)
Jacques
From: "Scott Gray" <sc...@hotwaxmedia.com>
> 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.
Posted by Scott Gray <sc...@hotwaxmedia.com>.
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
>>>>
>>>
>>
>
Re: ResultSet is FORWARD_ONLY.
Posted by Mridul Pathak <mr...@hotwaxmedia.com>.
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.
Posted by Scott Gray <sc...@hotwaxmedia.com>.
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.
Posted by Jacopo Cappellato <ja...@hotwaxmedia.com>.
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.
Posted by Scott Gray <sc...@hotwaxmedia.com>.
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