Re: MySQL and BigDecimal rounding
Re: MySQL and BigDecimal rounding
- Subject: Re: MySQL and BigDecimal rounding
- From: Robert Walker <email@hidden>
- Date: Wed, 2 Mar 2005 13:24:17 -0500
David,
Sorry for second post, but also make sure you have set the precision and scale for the attribute, and that you are using DECIMAL as the MySQL data type.
On Mar 2, 2005, at 12:30 PM, David Griffith wrote:
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
--
Robert Walker
Bennett Technology Group
(770) 957-1866 Ext: 790
_______________________________________________
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