Best way to store money using hibernate?

egervari · **Joined:** Sun Oct 26, 2003 5:05 am **Posts:** 139

What's the best way to store money in the database? I have a Money object that stores the value as a long and also contains java's Currency class. I'd like to store the combination into the database. Any place where I can find information on how to do this efficiently?

tq · **Posted:** Wed Aug 25, 2004 2:10 am

egervari wrote:

What's the best way to store money in the database? I have a Money object that stores the value as a long and also contains java's Currency class. I'd like to store the combination into the database. Any place where I can find information on how to do this efficiently?

just create the Money.hbm.xml file, I'm not sure you need the currency class as a property though.
btw long isn't suitable unless it represents cents and you divide by 100 for $ or whatever

gavin · **Posted:** Wed Aug 25, 2004 3:10 am

Nah, I wouldn't store it as a separate entity. If it were me, I'd use a UserType. Alternatively, you could use a <component> mapping.

egervari · **Joined:** Sun Oct 26, 2003 5:05 am **Posts:** 139

gavin wrote:

Nah, I wouldn't store it as a separate entity. If it were me, I'd use a UserType. Alternatively, you could use a <component> mapping.

That sounds reasonable. I'll look at UserTypes in the documentation to learn more about that. Thanks Gavin.

christian · **Posted:** Wed Aug 25, 2004 8:55 am

There is a MonetarAmountUserType in CaveatEmptor.

egervari · **Joined:** Sun Oct 26, 2003 5:05 am **Posts:** 139

christian wrote:

There is a MonetarAmountUserType in CaveatEmptor.

Yep, I found that and based it. It's working just great. Thanks.