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