Hello, We are running an Oracle Database (version 12.2). In our application, we need to store double values. The Oracle type equivalent seems to be BINARY_DOUBLE [1]. During the build phase, we do not have the Oracle database available. So we use the same schema with the BINARY_DOUBLE column on an hsql DB and use this as basis for the code generation. In the generated code this results in a column with type SQLDataType.DOUBLE, which seems to be correct.
The problem arises when storing very small values (< E-130). When binding the value in the prepared statement, the method OraclePreparedStatement.setDouble is used, instead of OraclePreparedStatement.setBinaryDouble. That method converts the Double to a Number, which is only supported down to E-130 [2]. Therefore, an underflow exception is thrown. What is the correct way to store a double value on an Oracle DB using jOOQ? Any help would be greatly appreciated! Best regards, Christoph [1] https://docs.oracle.com/database/121/SQLRF/sql_elements001.htm#g195556 [2] https://community.oracle.com/thread/460586 -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
