File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes problems with double value Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "problems with double value" Watch "problems with double value" New topic

problems with double value

Jaishankar VV

Joined: May 13, 2002
Posts: 6

I have problem while inserting into a Oracle table from java. I am getting the following error ORA-01438: value larger than specified precision allows for this column

Value = 99999999999999999999999999.99
I have defined the column size as number(28,2). I am using setDouble to set the value. I have also tried using BigDecimal but it resulted in the same error. Any solutions to overcomes this.

I agree. Here's the link:
subject: problems with double value
It's not a secret anymore!