Mapping Oracle Number(5,2)

c_java · **Joined:** Tue Aug 28, 2007 2:09 pm **Posts:** 9

Hi,

I am using Oracle 9i. I have a column of type Number(5,2) , how shall i map it in Hibernate? What should be the data type in POJO class and what shall be the property type in hbm.xml file? I tried with Float but it is not working.

Thanks

gskempes · **Joined:** Mon Nov 22, 2004 11:21 am **Posts:** 42

Hi,
unless it is a scientific application, you should use "big_decimal". This maps to the Java-Class BigDecimal. In business software you should always prefer fix point arithmetic over floating point arithmetic.

Regards,
Georg

wynton · **Joined:** Fri Aug 17, 2007 2:24 pm **Posts:** 6

c_java wrote:

Hi,

I am using Oracle 9i. I have a column of type Number(5,2) , how shall i map it in Hibernate? What should be the data type in POJO class and what shall be the property type in hbm.xml file? I tried with Float but it is not working.

Thanks

1. The data type in POJO class should be "private Double amount;"
2. The property type in hbm.xml file shall be

<property
name="amount"
type="java.lang.Double"
>
<column name="AMOUNT" sql-type="NUMBER(5,2)" />
</property>

Good Luck!