Hello,

 

I'm having a problem with a BigDecimal value:

 

The column is defined in my schema.xml file as:

 

    <column name="TRANSFER_AMOUNT" primaryKey="false" required="false"
size="30,2" type="DECIMAL" javaType="object"

            description="Transaction Information:  Manual entry"/>

 

As expected, this appears in the SQL as:

 

 TRANSFER_AMOUNT NUMBER(30,2)

 

In Java, I have this bit of code:

 

...

Transaction someTransaction = new Transaction();

someTransaction.setTransferAmount(new
BigDecimal("22345678901234600000001.00"));

...

 

But what goes into the database (Oracle 9i) is:  22345678901234600000000

 

What gives?

 

Thanks!

David

 

David A. Ventimiglia

Wells Fargo Private Client Services

(415) 396-0414 (work)

 

Reply via email to