[ODE-266] Database external variables: Empty values not handled correctly

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.1.1
• Fix Version/s: 1.2
• Component/s: BPEL Runtime
• Assignee: Alex Boisvert
• Reporter: Alex Boisvert
• Created: 13/Apr/08 12:25
• Updated: 13/Apr/08 13:17
• Resolved: 13/Apr/08 13:17

Description

Assigning an empty string into any non-string valued type external variable element (e.g. integer, float, .timestamp, ..) leads to the following exception,

19:28:50,093 ERROR [ASSIGN] Exception while initializing external variable
org.apche.ode.bpel.evar.ExternalVariableModuleException: Unable to convert value "" for column "requestAmount" !
at org.apache.ode.bpel.extvar.jdbc.DbExternalVariable$Column.fromText(DbExternalVariable.java:461)
at org.apache.ode.bpel.extvar.jdbc.DbExternalVariable.parseXmlRow(DbExternalVariable.java:312)
at org.apache.ode.bpel.extvar.jdbc.JdbcExternalVariableModule.writeValue(JdbcExternalVariableModule.java:244)

Empty strings for these types should be interpreted as null values as well as supporting xsi:nil.