[ https://issues.apache.org/jira/browse/OFBIZ-4769?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13538719#comment-13538719 ]
Jacques Le Roux edited comment on OFBIZ-4769 at 12/22/12 10:40 AM: ------------------------------------------------------------------- Sorry Deepak, it does not work here (maybe the local side effect) org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen [component://product/widget/catalog/ProductScreens.xml#EditSupplierProduct]: java.lang.IllegalArgumentException: Could not convert field value for the field: [availableFromDate] on the [SupplierProduct] entity to the [java.sql.Timestamp] type for the value [2005-01-01+00:00:00.000]: org.ofbiz.base.util.GeneralException: java.text.ParseException: Unparseable date: "2005-01-01+00:00:00.000" Paul's solution would not work and it would actually need to revert Scott's commit http://svn.apache.org/viewvc?view=revision&revision=939254 using Hans's solution http://svn.apache.org/viewvc?view=revision&revision=939247. I'm then curious why Scott did so? was (Author: jacques.le.roux): Sorry Deepak, it does not work here (maybe the local side effect) org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen [component://product/widget/catalog/ProductScreens.xml#EditSupplierProduct]: java.lang.IllegalArgumentException: Could not convert field value for the field: [availableFromDate] on the [SupplierProduct] entity to the [java.sql.Timestamp] type for the value [2005-01-01+00:00:00.000]: org.ofbiz.base.util.GeneralException: java.text.ParseException: Unparseable date: "2005-01-01+00:00:00.000" Paul'solution would not work and it would actually need to revert Scott's commit http://svn.apache.org/viewvc?view=revision&revision=939254 using Hans's solution http://svn.apache.org/viewvc?view=revision&revision=939247. I'm then curious why Scott did so? > Editing of product suppliers is not working for the Germany locale > ------------------------------------------------------------------ > > Key: OFBIZ-4769 > URL: https://issues.apache.org/jira/browse/OFBIZ-4769 > Project: OFBiz > Issue Type: Bug > Components: product > Affects Versions: Release 10.04, Release Branch 11.04, SVN trunk > Reporter: Sergei Biletnikov > Attachments: JIRA-4769-EditProductSuppliers-20121213.diff, > JIRA-4769EditProductSuppliers-20121222.patch, OFBIZ-4769.patch > > > Please, open any product and add to it a supplier (SupplierProduct), than try > to edit it (..../catalog/control/EditProductSuppliers?productId=xxx). > It works for English locale, but it does not work for German, I have the > following error: > =-=-=-=-=-=-=-=-= Database type warning GenericEntity.set =-=-=-=-=-=-=-=-= > In entity field [SupplierProduct.minimumOrderQuantity] set the value passed > in [java.lang.String] is not compatible with the Java type of the field > [java.math.BigDecimal] > Exception: java.lang.Exception > Message: Location of database type warning > ---- stack trace > --------------------------------------------------------------- > java.lang.Exception: Location of database type warning > org.ofbiz.entity.GenericEntity.set(GenericEntity.java:426) > org.ofbiz.entity.GenericEntity.set(GenericEntity.java:372) > org.ofbiz.entity.GenericEntity.setAllFields(GenericEntity.java:887) > ................ > ---- exception report > ---------------------------------------------------------- > =-=-=-=-=-=-=-=-= Database type warning GenericEntity.set =-=-=-=-=-=-=-=-= > In entity field [SupplierProduct.availableFromDate] set the value passed in > [java.lang.String] is not compatible with the Java type of the field > [java.sql.Timestamp] > Exception: java.lang.Exception > Message: Location of database type warning > ---- stack trace > --------------------------------------------------------------- > java.lang.Exception: Location of database type warning > org.ofbiz.entity.GenericEntity.set(GenericEntity.java:426) > org.ofbiz.entity.GenericEntity.set(GenericEntity.java:372) > org.ofbiz.entity.GenericEntity.setAllFields(GenericEntity.java:887) > org.ofbiz.entity.finder.PrimaryKeyFinder.runFind(PrimaryKeyFinder.java:106) > .................. > the investigation says me the following: > <screen name="EditSupplierProduct"> > <section> > <actions> > <set field="titleProperty" > value="PageTitleEditSupplierProduct"/> > <set field="tabButtonItem" value="EditSupplierProduct"/> > <set field="labelTitleProperty" value="ProductSuppliers"/> > <!-- default currency in > framework/common/config/general.properties --> > <property-to-field field="defaultCurrencyUomId" > resource="general" property="currency.uom.id.default" default="USD"/> > <set field="productId" from-field="parameters.productId"/> > <set field="orderBy" from-field="parameters.orderBy" > default-value="partyId"/> > <entity-and entity-name="SupplierProduct" > list="productSuppliers"> > <field-map field-name="productId"/> > <order-by field-name="${orderBy}"/> > </entity-and> > <entity-one entity-name="SupplierProduct" > value-field="supplierProduct" auto-field-map="true"/> > </actions > ............... > where <entity-one entity-name="SupplierProduct" value-field="supplierProduct" > auto-field-map="true"/> can not be done. > I suppose that the problem depends on the German locale, where BigDecimal and > Date has another format than we have in the parameters via URL. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira