[
https://issues.apache.org/jira/browse/ODE-787?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13659511#comment-13659511
]
Sathwik Bantwal Premakumar commented on ODE-787:
------------------------------------------------
As per the postgres script available under
http://ode.apache.org/ode-schema.html which was created for ODE 1.3.4 the
detailsExt column is of type OID. The existing code works.
If we apply the patch attached in this ticket, then the column has to be
changed to BYTEA
> column "detailsext" is of type bytea but expression is of type oid
> ------------------------------------------------------------------
>
> Key: ODE-787
> URL: https://issues.apache.org/jira/browse/ODE-787
> Project: ODE
> Issue Type: Bug
> Components: BPEL Runtime
> Affects Versions: 1.3.5, 2.0-beta3
> Environment: Linux localhost.localdomain 2.6.32.9-70.fc12.x86_64 #1
> SMP Wed Mar 3 04:40:41 UTC 2010 x86_64 x86_64 x86_64 GNU/Linux
> psql (PostgreSQL) 8.4.2
> Reporter: Terry Mueller
> Assignee: Tammo van Lessen
> Labels: patch
> Fix For: 1.3.6, 1.4
>
> Attachments: ODE-787.patch
>
>
> 13:48:03,400 ODEServerImpl-1 ERROR [SimpleScheduler] Database error.
> org.apache.ode.scheduler.simple.DatabaseException:
> org.postgresql.util.PSQLException: ERROR: column "detailsext" is of type
> bytea but expression is of type oid
> at
> org.apache.ode.scheduler.simple.JdbcDelegate.insertJob(JdbcDelegate.java:218)
> at
> org.apache.ode.scheduler.simple.SimpleScheduler.schedulePersistedJob(SimpleScheduler.java:230)
> at
> org.apache.ode.scheduler.simple.SimpleScheduler.schedulePersistedJob(SimpleScheduler.java:187)
> at
> org.apache.ode.bpel.engine.ODEProcess.scheduleJob(ODEProcess.java:811)
> at
> org.apache.ode.bpel.engine.ODEWSProcess.scheduleInvokeCheck(ODEWSProcess.java:706)
> at
> org.apache.ode.bpel.engine.ODEWSProcess.invokePartner(ODEWSProcess.java:641)
> at
> org.apache.ode.bpel.engine.BpelRuntimeContextImpl.invoke(BpelRuntimeContextImpl.java:739)
> at
> org.apache.ode.bpel.rtrep.v2.RuntimeInstanceImpl.invoke(RuntimeInstanceImpl.java:654)
> at org.apache.ode.bpel.rtrep.v2.INVOKE.wsdlInvoke(INVOKE.java:108)
> at org.apache.ode.bpel.rtrep.v2.INVOKE.run(INVOKE.java:71)
> at sun.reflect.GeneratedMethodAccessor136.invoke(Unknown Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at
> org.apache.ode.jacob.vpu.JacobVPU$JacobThreadImpl.run(JacobVPU.java:450)
> at org.apache.ode.jacob.vpu.JacobVPU.execute(JacobVPU.java:139)
> at
> org.apache.ode.bpel.rtrep.v2.RuntimeInstanceImpl.execute(RuntimeInstanceImpl.java:716)
> at
> org.apache.ode.bpel.engine.BpelRuntimeContextImpl.execute(BpelRuntimeContextImpl.java:844)
> at
> org.apache.ode.bpel.engine.BpelRuntimeContextImpl.executeCreateInstance(BpelRuntimeContextImpl.java:832)
> at
> org.apache.ode.bpel.engine.ODEProcess.executeCreateInstance(ODEProcess.java:235)
> at org.apache.ode.bpel.engine.ODEWSProcess$1.call(ODEWSProcess.java:410)
> at org.apache.ode.bpel.engine.ODEWSProcess$1.call(ODEWSProcess.java:408)
> at
> org.apache.ode.bpel.engine.ODEProcess$ProcessCallable.call(ODEProcess.java:800)
> at
> org.apache.ode.bpel.engine.BpelInstanceWorker.doInstanceWork(BpelInstanceWorker.java:171)
> at
> org.apache.ode.bpel.engine.BpelInstanceWorker.execInCurrentThread(BpelInstanceWorker.java:106)
> at
> org.apache.ode.bpel.engine.ODEProcess.doInstanceWork(ODEProcess.java:355)
> at
> org.apache.ode.bpel.engine.ODEWSProcess.invokeProcess(ODEWSProcess.java:408)
> at
> org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl.doInvoke(MyRoleMessageExchangeImpl.java:129)
> at
> org.apache.ode.bpel.engine.UnreliableMyRoleMessageExchangeImpl$1.call(UnreliableMyRoleMessageExchangeImpl.java:46)
> at
> org.apache.ode.bpel.engine.UnreliableMyRoleMessageExchangeImpl$1.call(UnreliableMyRoleMessageExchangeImpl.java:44)
> at
> org.apache.ode.bpel.engine.ODEProcess$ProcessCallable.call(ODEProcess.java:800)
> at
> org.apache.ode.bpel.engine.Contexts.execTransaction(Contexts.java:110)
> at
> org.apache.ode.bpel.engine.BpelServerImpl$TransactedCallable.call(BpelServerImpl.java:1031)
> at
> org.apache.ode.bpel.engine.BpelServerImpl$ServerCallable.call(BpelServerImpl.java:1011)
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
> at java.util.concurrent.FutureTask.run(FutureTask.java:138)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> at java.lang.Thread.run(Thread.java:619)
> Caused by: org.postgresql.util.PSQLException: ERROR: column "detailsext" is
> of type bytea but expression is of type oid
> at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1608)
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1343)
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:194)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:304)
> at
> org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
> at
> org.apache.ode.scheduler.simple.JdbcDelegate.insertJob(JdbcDelegate.java:216)
> ... 37 more
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
