Re: Question re: data types

From: Aristedes Maniatis (ar..sh.com.au)
Date: Thu Mar 12 2009 - 18:37:13 EDT

Next message: han..elinux.cl: "Re: Factory method subclassing cayenne data objects"

Previous message: Aristedes Maniatis: "Re: Object state after persist: consistent with JPA?"
In reply to: Chad Smith: "Question re: data types"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

On 13/03/2009, at 2:55 AM, Chad Smith wrote:

> I guess my question then, is what is the best way to handle money
> values on the db type and the java type?

BigDecimal in Java and DECIMAL in the database. Floating point numbers
are evil with respect to money since they are only approximations of
decimal numbers: I'm sure your tax office would appreciate that note
on your return stating 'all numbers are approximations only' :-)

Ari Maniatis

-------------------------->
ish
http://www.ish.com.au
Level 1, 30 Wilson Street Newtown 2042 Australia
phone +61 2 9550 5001 fax +61 2 9550 4001
GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A

Next message: han..elinux.cl: "Re: Factory method subclassing cayenne data objects"
Previous message: Aristedes Maniatis: "Re: Object state after persist: consistent with JPA?"
In reply to: Chad Smith: "Question re: data types"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This archive was generated by hypermail 2.0.0 : Thu Mar 12 2009 - 18:37:44 EDT