[OFBiz] Users - Ecommerce Currency Comma Problems

Uli Suppa USuppa at yahoo.de
Thu Sep 23 09:40:53 EDT 2004


Hi Dirk,

i am entering this decimal values in the prices fields in the 
products->prices view. i think there has at least to be a default and a 
list price for each produkt, so i entered these two. it doesn't matter 
wether the default or the list price is a comma value, the error occures 
every time.

when i try to enter 445.5 and hit the update button then the dot gets 
stripped of.

i just installed the ofbiz-3.0 version, exactly the same setup but 
without the error.

thanks uli.


dirk.osterkamp at agrenon.com schrieb:
> Uli,
> in which field do you enter 445,4 or did it come out of ofbiz.
> If you enter floats with locale en_us and USD as currency i think you have 
> to enter 445.5
> In my svn version of ofbiz this problem didn't occur.
> 
> Viele Gruesse
> Best Regards
> 
> Dirk Osterkamp
> 
> Agrenon GmbH ,  a Subsidiary of Lynx Consulting AG
> Johanniskirchplatz 6, D-33615 Bielefeld, Germany
> Tel. +49 (521) 5247-0, Fax.+49 (521) 5247-250, Mobile +49(171)7437992
> E-Mail: dirk.osterkamp at agrenon.com
> 
> 
> 
> 
> 
> Uli Suppa <USuppa at yahoo.de>
> Sent by: users-bounces at lists.ofbiz.org
> 23.09.2004 13:24
> Please respond to OFBiz Users / Usage
>  
>         To:     OFBiz Users / Usage <users at lists.ofbiz.org>
>         cc: 
>         Subject:        Re: [OFBiz] Users - Ecommerce Currency Comma 
> Problems
> 
> 
> Hello everyone,
> 
> I just did a fresh svn checkout and cleared my database.
> 
> these are the only changes i made:
> - copied the mysql driver into the entity jdbc dir
> - configured mysql as datasource
> - turned on mail notification and set the smtp host in general.properties
> 
> I ran ant and then run-install, started ofbiz.
> 
> Created a customer account, and checked out WG-9943-B3 - Giant Widget B3.
> 
> So I made no currency or locale changes, plain en_us and USD.
> 
> but i get the same error:
> 
> ---- runtime exception report 
> --------------------------------------------------
> 
> Async-Service failed.
> Exception: java.lang.NumberFormatException
> Message: For input string: "445,4"
> ---- stack trace 
> ---------------------------------------------------------------
> 
> java.lang.NumberFormatException: For input string: "445,4"
> java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
> java.lang.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:1207)
> java.lang.Double.valueOf(Double.java:202)
> org.ofbiz.entity.GenericEntity.setString(GenericEntity.java:398)
> org.ofbiz.entity.GenericDelegator.makeValue(GenericDelegator.java:2034)
> 
> Should I look for a new java version (installed: j2sdk1.4.2_04)? Might 
> that be the problem ? I also tried the text file database instead of 
> mysql, but that also made no difference.
> 
> sincerely Uli.
> 
> Uli Suppa schrieb:
> 
>>Hello everyone,
>>
>>my system ist latest OfBiz from svn, Win2k, MySQL-4.0.18 with 
>>mysql-connector-java-3.0.11 as jdbc driver.
>>
>>i try to setup a german onlineshop so i changed the currency in my 
>>created store to EUR. edited 
>>/ofbiz/commponents/common/config/general.properties and changed:
>>
>>currency.uom.id.default=EUR
>>currency.decimal.format=##0,00
>>country.uom.id.default=DE
>>
>>now i can order products as long as the default and list price are 
>>integers, if i change a price to 12,50 the order fails:
>>
>>[java] ---- runtime exception report 
>>--------------------------------------------------
>>[java] Async-Service failed.
>>[java] Exception: java.lang.NumberFormatException
>>[java] Message: For input string: "12,5"
>>[java] ---- stack trace 
>>---------------------------------------------------------------
>>[java] java.lang.NumberFormatException: For input string: "12,5"
>>[java] java.lang.NumberFormatException.forInputString(Unknown source)
>>[java] java.lang.FloatingDecimal.readJavaFormatString(Unknown Source)
>>[java] java.lang.Double.valueOf(Unknown Source)
>>[java] org.ofbiz.entity.GenericEntity.setString(GenericEntity.java:398)
>>[java] 
>>org.ofbiz.entity.GenericDelegator.makeValue(GenericDelegator.java:2033)
>>
>>any ideas ? did I miss any config switch ?
>>
>>sincerely uli.
>>
>>_______________________________________________
>>Users mailing list
>>Users at lists.ofbiz.org
>>http://lists.ofbiz.org/mailman/listinfo/users
> 
>  
> _______________________________________________
> Users mailing list
> Users at lists.ofbiz.org
> http://lists.ofbiz.org/mailman/listinfo/users
> 
> 
> 
> 
> ------------------------------------------------------------------------
> 
>  
> _______________________________________________
> Users mailing list
> Users at lists.ofbiz.org
> http://lists.ofbiz.org/mailman/listinfo/users


More information about the Users mailing list