I have an application running on WebLogic Server 10 using DB2 Type 4 Driver.
The column on the table was defined to have 5 precision points after the decimal, so when the application trying insert value 0.06849999999 into the table I expect to see 0.06850, but instead I got 0.06849.

When I ran the same application under WebLogic server 8 pointed to the same database/table with DB2 Type 2 Driver and same number 0.06849999999, the result was corrected 0.06850.

Does anyone ran into this issue before, and what should I do to fix this problem? I do not want to pre-formatt the number.

Thank you