• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
MySQL and BigDecimal rounding
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

MySQL and BigDecimal rounding


  • Subject: MySQL and BigDecimal rounding
  • From: David Griffith <email@hidden>
  • Date: Wed, 02 Mar 2005 18:30:10 +0100

Title: MySQL and BigDecimal rounding
Hi all,

I’m sure someone knows the answer to this one..

I’ve just switched from Frontbase to mySQL for one of my applications (which worked perfectly with FrontBase).  I have installed Connector/J and can connect to the database fine.

I am having issues with the rounding now with mySQL (which I guess was handled internally by the FrontBase adaptor?).  This is the error I am getting:

com.webobjects.eoaccess.EOGeneralAdaptorException: The attribute cartItemLineTotal has a scale of 2, but the value 29.950000762939453125 has a scale of 18: Rounding necessary

I am just curious is there is an easy way to solve this without large code changes.

Regards,
David.
 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden

  • Follow-Ups:
    • Re: MySQL and BigDecimal rounding
      • From: Robert Walker <email@hidden>
    • Re: MySQL and BigDecimal rounding
      • From: Robert Walker <email@hidden>
  • Prev by Date: breadcrumb path design ... to do or not to do !
  • Next by Date: Re: MySQL and BigDecimal rounding
  • Previous by thread: breadcrumb path design ... to do or not to do !
  • Next by thread: Re: MySQL and BigDecimal rounding
  • Index(es):
    • Date
    • Thread