[ODE-346] Unparseable date: "oracle.sql.TIMES:00.000TAMP@ec607c"

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.2
• Fix Version/s: 1.3.2
• Component/s: BPEL Runtime
• Environment: Oracle
• Assignee: Unassigned
• Reporter: Alex Boisvert
• Created: 23/Jul/08 02:03
• Updated: 24/Apr/09 00:54
• Resolved: 23/Jul/08 02:20

Description

Using external variables with Oracle and a timestamp field leads to,

17:50:08,765 ERROR [ASSIGN] Exception while initializing external variable
org.apache.ode.bpel.evar.ExternalVariableModuleException: Unable to convert value "oracle.sql.TIMESTAMP@ec607c" fo
at org.apache.ode.bpel.extvar.jdbc.DbExternalVariable$Column.fromText(DbExternalVariable.java:479)
at org.apache.ode.bpel.extvar.jdbc.DbExternalVariable.parseXmlRow(DbExternalVariable.java:312)
at org.apache.ode.bpel.extvar.jdbc.JdbcExternalVariableModule.writeValue(JdbcExternalVariableModule.java:2
at org.apache.ode.bpel.engine.extvar.ExternalVariableManager.write(ExternalVariableManager.java:155)
at org.apache.ode.bpel.engine.BpelRuntimeContextImpl.writeExtVar(BpelRuntimeContextImpl.java:1360)
at org.apache.ode.bpel.runtime.ScopeFrame.writeVariable(ScopeFrame.java:258)
at org.apache.ode.bpel.runtime.ScopeFrame.commitChanges(ScopeFrame.java:243)
at org.apache.ode.bpel.runtime.ACTIVITY.commitChanges(ACTIVITY.java:172)
at org.apache.ode.bpel.runtime.ASSIGN.copy(ASSIGN.java:412)
at org.apache.ode.bpel.runtime.ASSIGN.run(ASSIGN.java:81)
at sun.reflect.GeneratedMethodAccessor215.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.ode.jacob.vpu.JacobVPU$JacobThreadImpl.run(JacobVPU.java:451)
at org.apache.ode.jacob.vpu.JacobVPU.execute(JacobVPU.java:139)
at org.apache.ode.bpel.engine.BpelRuntimeContextImpl.execute(BpelRuntimeContextImpl.java:834)
at org.apache.ode.bpel.engine.BpelProcess.handleWorkEvent(BpelProcess.java:402)
at org.apache.ode.bpel.engine.BpelEngineImpl.onScheduledJob(BpelEngineImpl.java:326)
at org.apache.ode.bpel.engine.BpelServerImpl.onScheduledJob(BpelServerImpl.java:373)
at org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:337)
at org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:336)
at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:174)
at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:335)
at org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:332)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)
at java.util.concurrent.FutureTask.run(FutureTask.java:123)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.text.ParseException: Unparseable date: "oracle.sql.TIMES:00.000TAMP@ec607c"
at java.text.DateFormat.parse(DateFormat.java:335)
at org.apache.ode.utils.ISO8601DateParser.parse(ISO8601DateParser.java:100)
at org.apache.ode.bpel.extvar.jdbc.DbExternalVariable$Column.fromText(DbExternalVariable.java:458)
... 28 more