topic Re: Oracle and Java datatype double in Alfresco Archive

Oracle and Java datatype double

mamue — Mon, 12 Aug 2013 11:16:00 GMT

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

Re: Oracle and Java datatype double

jbarrez — Wed, 14 Aug 2013 09:56:24 GMT

No clue, to be honest.

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

Re: Oracle and Java datatype double

mamue — Thu, 22 Aug 2013 15:32:13 GMT

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