[jira] [Comment Edited] (OFBIZ-4769) Editing of product suppliers is not working for the Germany locale

[Nicolas Malin (Jira)]

    [ 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