Uploaded image for project: 'OFBiz'
  1. OFBiz
  2. OFBIZ-4769

Editing of product suppliers is not working for the Germany locale

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Patch Available
    • Major
    • Resolution: Unresolved
    • Release 10.04, Release Branch 11.04, Trunk, Upcoming Branch
    • None
    • product
    • None
    • Bug Crush Event - 21/2/2015

    Description

      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.

      Attachments

        1. JIRA-4769-EditProductSuppliers-20121213.diff
          1 kB
          Christian Geisert
        2. JIRA-4769EditProductSuppliers-20121222.patch
          3 kB
          Jacques Le Roux
        3. JIRA-4769EditProductSuppliers-20121222.patch
          3 kB
          Jacques Le Roux
        4. JIRA-4769EditProductSuppliers-20121222.patch
          0.8 kB
          Paul Piper
        5. OFBIZ-4769.patch
          1 kB
          Deepak Dixit
        6. OFBIZ-4769-20121227.patch
          3 kB
          Deepak Dixit
        7. OFBIZ-4769-Updated.patch
          2 kB
          Deepak Dixit
        8. OFBIZ-4769-WidgetWorker-Including-DeleteProductSupplier.patch
          4 kB
          Jacques Le Roux
        9. OFBIZ-4769-WidgetWorker-Including-DeleteProductSupplier.patch
          3 kB
          Christian Geisert
        10. WidgetWorker.patch
          2 kB
          Jacopo Cappellato
        11. WidgetWorker.patch
          2 kB
          Jacopo Cappellato

        Issue Links

          Activity

            People

              Unassigned Unassigned
              sbiletnikov Sergei Biletnikov
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated: