AnsweredAssumed Answered

Oracle and Java datatype double

Question asked by mamue on Aug 12, 2013
Latest reply on Aug 22, 2013 by mamue
Hi,

why maps Activiti the Java datatype double to the Oracle datatype NUMBER(*,10) instead to the Oracle datatype NUMBER?
With the current mapping the value 1e-11 becomes to 0 if stored.
This concerns the three tables ACT_HI_DETAIL, ACT_HI_VARINST, ACT_RU_VARIABLE.

The Oracle datatype NUMBER implements a floating point semantics.
With this type even 1e-130 may be stored as stated by
http://docs.oracle.com/cd/B28359_01/server.111/b28286/sql_elements001.htm#sthref83

Kind regards,
MaMue

Outcomes