Error in columns with large numbers

KNIME Analytics Platform
1

Hi

After connect to Oracle data base and try write columns with large numbers (5.163734549766E10), I am getting error the error below 

DEBUG Database Writer      0:1345     Execute failed: Overflow
(Please find the log in attached)

It works only when this column is filtered.

I tried to change the data type, but even so, does not work.


Somebody could help me with this question?

Thank you

Marcus

 

2

Hi,

the error is thrown by the Oracle driver. It seems that the setDouble method of the driver is checking the size of the number and if it is to large for the db column type it rejects it. Maybe this is also related to the bug with infinite number handling as reported in the Oracle forum. Can you check the version of your driver and if it is version 11.2.0.4.0 and if that is the case try version 11.2.0.3.0 instead.

Bye

Tobias

3