Oracle JDBC:双倍下溢

编程入门行业动态更新时间:2024-10-11 15:16:37

本文介绍了Oracle JDBC:双倍下溢的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！问题描述

当尝试将双精度型插入到Oracle表的 DOUBLE PRECISION 列中时，当双精度型超出范围(在我的情况下:太小)时，会出现异常，但仅当使用PreparedStatement(如果我使用普通的Statement，则将double舍入为0).

When trying to insert doubles into a DOUBLE PRECISION column of an Oracle table, I get an exception when the double is out of range (in my case: too small), but only when using PreparedStatement (if I use the normal Statement, it rounds the double to 0).

表格:

create table test ( VALUE DOUBLE PRECISION );

Java代码:

double d = 1e-234; // using Statement works, the number gets rounded and 0 is inserted try (Statement stmt = conn.createStatement()) { stmt.executeUpdate("insert into test values (" + d + ")"); } // using PreparedStatement fails, throws an IllegalArgumentException: Underflow try (PreparedStatement stmt = conn.prepareStatement("insert into test values (?)")) { stmt.setDouble(1, d); stmt.executeUpdate(); }