You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ode.apache.org by "Rafal Rusin (JIRA)" <ji...@apache.org> on 2010/07/14 22:41:49 UTC
[jira] Resolved: (ODE-872) DECIMAL and NUMERIC types are not
handled properly for xvar on Oracle
[ https://issues.apache.org/jira/browse/ODE-872?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rafal Rusin resolved ODE-872.
-----------------------------
Resolution: Fixed
Applied. Thanks!
> DECIMAL and NUMERIC types are not handled properly for xvar on Oracle
> ---------------------------------------------------------------------
>
> Key: ODE-872
> URL: https://issues.apache.org/jira/browse/ODE-872
> Project: ODE
> Issue Type: Bug
> Components: BPEL Runtime
> Affects Versions: 1.3.4
> Environment: External Variables on Oracle 9g/10g
> Reporter: Oleg Zenzin
> Fix For: 1.3.5
>
> Attachments: bpel-runtime.patch
>
>
> The external variables functionality can suffer form Oracle 9g/10g bug when run on Java 1.5. Essentially what happens is when a BigDecimal data is being updated or inserted the numbers like 125000 or others with trailing zeros can become "125", i.e. lose the zeros! The bug is discussed here: http://www.javalobby.org/java/forums/t88158.html. Here's an excerpt:
> "Between Java 1.4 and Java 1.5, the BigDecimal class changed. In Java 1.4, the scale must be non-negative. In Java 1.5, the scale can now be negative (see the javadoc).
> If you look at the value 12500000 as a BigDecimal, in Java 1.5, this gets represented as 125 with a scale of -5. In 1.4, this would get represented as 12500000 with a scale of 0.
> In Oracle's driver, they appear to do the conversion to an array of bytes to send to the driver themselves; I'm not sure which cases it will work for, but I'd suspect that it won't work correctly for a large number of negative scales. I'd guess that they designed it under 1.4 and didn't test it adequately under 1.5. "
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.