Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Underflow Exception when trying to bind small double to BINARY_DOUBLE

529693Dec 30 2006 — edited Jan 2 2007

I get exception when trying to insert small double value (1.0E-131) into BINARY_DOUBLE column via jdbc.

The exception I get:
Exception in thread "main" java.sql.SQLException: Underflow Exception trying to bind 1.0000000000000001E-131
at oracle.jdbc.driver.DoubleBinder.bind(OraclePreparedStatement.java:13856)
at oracle.jdbc.driver.OraclePreparedStatement.setupBindBuffers(OraclePreparedStatement.java:2866)
at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:2151)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3280)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3390)
at dbAccess.main(dbAccess.java:18)

According to oracle documentation the smallest positive number the BINARY_DOUBLE column can store is 2.22507485850720E-308.

I'm using oracle 10g r2 and thin jdbc driver.
Any ideas?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 30 2007

Added on Dec 30 2006

#java-database-connectivity-jdbc

2 comments

8,839 views