Oracle and Java datatype double

[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

[jbarrez]

No clue, to be honest.

Could you create a jira for this, so we can follow up?

[mamue]

Ok, I have created ACT-1772

In our application we first mapped double columns to Oracle's datatype BINARY_DOUBLE.
But unfortunately this type is not supported by Oracle's EXP and IMP tools.
Therefore we use the good old datatype NUMBER now.

Kind regards,
MaMue