Hi,

I am using Hibernate 3.1.1 with Oracle 10g and XE. The script of my Table sample is this:

CREATE sample (
sampa NUMBER,
sampb NUMBER(5),
sampc NUMBER(10),
sampd NUMBER(15,2),
sampe NUMBER(19,7)
);

As I should map Fields NUMBER to Java in Hibernate?
Option 1)
---------
sampa NUMBER -- > java.math.BigDecimal
sampb NUMBER(5), -- > java.lang.Integer
sampc NUMBER(10), -- > java.lang.Integer
sampd NUMBER(15,2), -- > java.lang.Float
sampe NUMBER(19,7) -- > java.lang.Long

or
Option 2)
---------
ALL FIELDS NUMBER should be used with -- > java.math.BigDecimal


Regards.

Sergio.

Hi bkmr_77,

Thank you for their quick answer.

Then I should assume that if I use
until NUMBER(38,0) ---> type="java.math.BigInteger"
until NUMBER(38,38) ---> type="java.math.BigDecimal" precision="38" scale="38"
and NUMBER ---> type="java.math.BigDecimal"

Is this range the Correct one?

For Last, where I find documentation on the topic? .

Thank you again.

Regards.

Sergio.

I guess the previous post of mine should be as follows



sorry I am confused, couldnt find any documentation information regarding this. Dont know which attributes are correct. If the ones mentioned in the first post worked, please let me know. Thanks.

Hi,

Forgive, Their first post worked well.

Now, I need to know the ranges for map Fields NUMBER to Java in Hibernate.

Exists Documentation on the ranges for map Fields NUMBER to Java in Hibernate?.

These ranges, are the correct ones?
until NUMBER(38,0) I should use ---> type="java.math.BigInteger" (All the Integers you mapping like BigInteger?)
until NUMBER(38,38) I should use ---> type="java.math.BigDecimal" precision="38" scale="38"
and NUMBER I should use ---> type="java.math.BigDecimal"


Do you understand my Question?

Thank you !!

Regards.

Sergio.