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

 

The question is:  does writing a BigDecimal against Oracle using Torque
capture all significant digits?

 

Thanks!

David

 

David A. Ventimiglia

Wells Fargo Private Client Services

(415) 396-0414 (work)

 

Reply via email to