I've been hunting for over 3 days now to find out how to map the SQL Server money type to hibernate, finally tried to create a Custom type which too fails

I was hoping the BigDecimal would work, but it just fails with the following message at startup leaving me pissed!!!

"Wrong column type in xxxxxxxx for column amount. Found: money, expected: numeric(19,2)"

1. The column type in SQL (2005) is money

2. My hbm mapping is

<property name="amount" type="big_decimal">
<column name="amount" not-null="true" />
</property>

This incidentally is generated by the Hibernate tool itself.

Hibernate version:3

Has anyone ever faced this issue.... What is it that i'm missing....Any inputs would be greatly appreciated.

Thanks in advance.

mumbaiCutting, I'm having the same problem. Have you figured out how to map to the Money type? Thanks in advance!

Yeah, use the sql-type="money" as this :

<property name="field_name" type="big_decimal">
<column name="column_name" length="8" sql-type="money" not-null="true" />
</property>