[
https://issues.apache.org/jira/browse/ODE-292?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12599241#action_12599241
]
Alex Boisvert commented on ODE-292:
-----------------------------------
There's a related discussion at http://jira.springframework.org/browse/SPR-2135
> ClassCastException: oracle.sql.TIMESTAMP with time external variable
> --------------------------------------------------------------------
>
> Key: ODE-292
> URL: https://issues.apache.org/jira/browse/ODE-292
> Project: ODE
> Issue Type: Bug
> Components: BPEL Runtime
> Affects Versions: 1.1.1
> Reporter: Alex Boisvert
> Fix For: 1.2
>
>
> The current external variable code assumes time/date values extracted from
> the resultset are either java.util.Date, java.sql.Time, or
> java.sql.Timestamp... but Oracle's JDBC implementation is "special" and
> breaks our code,
> 23:06:28,573 ERROR [JacobVPU] Method "run" in class
> "org.apache.ode.bpel.runtime
> .ASSIGN" threw an unexpected exception.
> java.lang.ClassCastException: oracle.sql.TIMESTAMP
> at
> org.apache.ode.bpel.extvar.jdbc.DbExternalVariable$Column.toText(DbEx
> ternalVariable.java:439)
> at
> org.apache.ode.bpel.extvar.jdbc.DbExternalVariable.addElement(DbExter
> nalVariable.java:278)
> at
> org.apache.ode.bpel.extvar.jdbc.DbExternalVariable.renderXmlRow(DbExt
> ernalVariable.java:262)
> at
> org.apache.ode.bpel.extvar.jdbc.JdbcExternalVariableModule.readValue(
> JdbcExternalVariableModule.java:292)
> at
> org.apache.ode.bpel.engine.extvar.ExternalVariableManager.read(Extern
> alVariableManager.java:139)
> at
> org.apache.ode.bpel.engine.BpelRuntimeContextImpl.readExtVar(BpelRunt
> imeContextImpl.java:1350)
> at
> org.apache.ode.bpel.runtime.ScopeFrame.initializeVariable(ScopeFrame.
> java:233)
> at
> org.apache.ode.bpel.runtime.ACTIVITY.initializeVariable(ACTIVITY.java
> :164)
> at org.apache.ode.bpel.runtime.ASSIGN.evalLValue(ASSIGN.java:125)
> at org.apache.ode.bpel.runtime.ASSIGN.copy(ASSIGN.java:348)
> at org.apache.ode.bpel.runtime.ASSIGN.run(ASSIGN.java:80)
> at sun.reflect.GeneratedMethodAccessor183.invoke(Unknown Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
> sorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585)
> at
> org.apache.ode.jacob.vpu.JacobVPU$JacobThreadImpl.run(JacobVPU.java:4
> 51)
> at org.apache.ode.jacob.vpu.JacobVPU.execute(JacobVPU.java:139)
> at
> org.apache.ode.bpel.engine.BpelRuntimeContextImpl.execute(BpelRuntime
> ContextImpl.java:831)
> at
> org.apache.ode.bpel.engine.PartnerLinkMyRoleImpl.invokeNewInstance(Pa
> rtnerLinkMyRoleImpl.java:197)
> at
> org.apache.ode.bpel.engine.BpelProcess.invokeProcess(BpelProcess.java
> :194)
> at
> org.apache.ode.bpel.engine.BpelProcess.handleWorkEvent(BpelProcess.ja
> va:362)
> at
> org.apache.ode.bpel.engine.BpelEngineImpl.onScheduledJob(BpelEngineIm
> pl.java:326)
> at
> org.apache.ode.bpel.engine.BpelServerImpl.onScheduledJob(BpelServerIm
> pl.java:373)
> at
> com.intalio.pxe.csched.SimpleScheduler$4$1.call(SimpleScheduler.java:
> 297)
> at
> com.intalio.pxe.csched.SimpleScheduler$4$1.call(SimpleScheduler.java:
> 296)
> at
> com.intalio.pxe.csched.SimpleScheduler.execTransaction(SimpleSchedule
> r.java:135)
> at
> com.intalio.pxe.csched.SimpleScheduler$4.call(SimpleScheduler.java:29
> 5)
> at
> com.intalio.pxe.csched.SimpleScheduler$4.call(SimpleScheduler.java:29
> 2)
> 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(ThreadPoolExec
> utor.java:650)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
> .java:675)
> at java.lang.Thread.run(Thread.java:595)
> 23:06:28,573 ERROR [BpelEngineImpl] Scheduled job failed;
> jobDetail={type=INVOKE
> _INTERNAL, mexid=3127, pid={http://example.com/NewDiagram/Pool0}Pool0-1}
> java.lang.RuntimeException: java.lang.ClassCastException: oracle.sql.TIMESTAMP
> at
> org.apache.ode.jacob.vpu.JacobVPU$JacobThreadImpl.run(JacobVPU.java:4
> 64)
> at org.apache.ode.jacob.vpu.JacobVPU.execute(JacobVPU.java:139)
> at
> org.apache.ode.bpel.engine.BpelRuntimeContextImpl.execute(BpelRuntime
> ContextImpl.java:831)
> at
> org.apache.ode.bpel.engine.PartnerLinkMyRoleImpl.invokeNewInstance(Pa
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.