You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ode.apache.org by "René Bos (JIRA)" <ji...@apache.org> on 2011/09/26 12:08:27 UTC

[jira] [Commented] (ODE-787) column "detailsext" is of type bytea but expression is of type oid

    [ https://issues.apache.org/jira/browse/ODE-787?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13114573#comment-13114573 ] 

René Bos commented on ODE-787:
------------------------------

Why is the fix version of this issue still 2.0-beta3? It is a blocking issue for people using PostgreSQL like me.

The affected versions should include the current stable 1.3.5.

Regards, René

> 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: 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
>              Labels: patch
>             Fix For: 2.0-beta3
>
>         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.
For more information on JIRA, see: http://www.atlassian.com/software/jira