I will try 1.3.4 I don't think I have this applied.
The ODE I am having is the patch you gave sometime in April, which includes DB
Scripts for Postgres (see attached mail).
-----Original Message-----
From: Rafal Rusin [mailto:[email protected]]
Sent: Monday, June 14, 2010 5:01 PM
To: [email protected]
Subject: Re: Exception during - Parallel Execution
Hello,
do you have this applied?
commit 75797735770ee3cba63af0cf01d3c8cb598b5c54
Author: Rafal Konrad Rusin <[email protected]>
Date: Sat May 22 15:21:19 2010 +0000
Load immediate fix
git-svn-id:
https://svn.apache.org/repos/asf/ode/branches/apache_ode_1.3....@94730813f79535-47bb-0310-9956-ffa450edef68
Alternatively, could you try 1.3.4 release?
On Mon, Jun 14, 2010 at 1:02 PM, Dhanush Gopinath <
[email protected]> wrote:
> Hi,
>
> At times when I run my process with parallel flows ODE throws out an
> exception and the process execution path in which the exception is
> thrown is kind of stuck
>
>
>
> 16:20:53,186 ERROR [SimpleScheduler] Error while processing a persisted
> job: Job hqejbhcnphr5cs590vb10q time: 2010-06-14 16:20:50 IST
> transacted: true persisted: true details: JobDetails( instanceId: 3900
> mexId: 3405 processId: null type: INVOKE_RESPONSE channel: 70
> correlatorId: null correlationKeySet: null retryCount: null inMem: false
> detailsExt: {})
>
> org.apache.ode.bpel.iapi.Scheduler$JobProcessorException
>
> at
> org.apache.ode.bpel.engine.BpelEngineImpl.onScheduledJob(BpelEngineImpl.
> java:398)
>
> at
> org.apache.ode.bpel.engine.BpelServerImpl.onScheduledJob(BpelServerImpl.
> java:450)
>
> at
> org.apache.ode.scheduler.simple.SimpleScheduler$RunJob$1.call(SimpleSche
> duler.java:518)
>
> at
> org.apache.ode.scheduler.simple.SimpleScheduler$RunJob$1.call(SimpleSche
> duler.java:513)
>
> at
> org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleSc
> heduler.java:284)
>
>
>
> The process doesn't move forward. This doesn't happen all the time. Any
> idea why this is happening. I am using ODE 1.3.3 (with a patch) on JBOSS
> and Postgres.
>
>
>
> Please help.
>
>
>
> Thanks & Regards
>
> Dhanush Gopinath
>
>
>
>
--
Regards,
Rafał Rusin
http://rrusin.blogspot.com
--- Begin Message ---
OK, got it.
Please grab deps, config, schema and example process from here:
http://github.com/rafalrusin/ode/downloads (ode-134-pgsql-hib.zip)
And please use current shapshot
http://hudson.zones.apache.org/hudson/job/ODE-1.x/115/ .
I configured it using tranql vendor postgres internal pool and
hibernate DAO, like this:
ode-axis2.properties:
ode-axis2.dao.factory=org.apache.ode.daohib.bpel.BpelDAOConnectionFactoryImpl
ode-axis2.db.mode=INTERNAL
ode-axis2.db.int.mcf=org.tranql.connector.postgresql.PGXAMCF
ode-axis2.db.int.mcf.databaseName=ode134
ode-axis2.db.int.mcf.userName=postgres
ode-axis2.db.int.mcf.password=postgres
ode-axis2.db.int.mcf.serverName=localhost
Note that I had to do some schema update to pick up blobs correctly
(bytea & oid types).
Note2 we don't ship hibernate in Apache Distro, so you need to grab
those extra deps to have it working.
Regards,
Rafał Rusin
On 26 April 2010 18:18, Rafal Rusin <[email protected]> wrote:
> I'll try to set it up today.
>
> On 26 April 2010 14:22, Dhanush Gopinath <[email protected]> wrote:
>> Any Help? Can ODE be setup with Postgres DB? I pretty much tried the
>> same steps as mentioned in the Tutorial for setting up ODE with MySQL.
>>
>> -----Original Message-----
>> From: Dhanush Gopinath [mailto:[email protected]]
>> Sent: Friday, April 23, 2010 1:08 PM
>> To: [email protected]
>> Subject: ODE on Postgres
>>
>> Hi,
>>
>>
>>
>> I am trying to setup ODE with Postgres DB instead of the inbuilt Derby
>> DB. I created the DB tables, and was able to deploy the process
>> definition.
>>
>> But when I start executing the process it throws an exception saying
>>
>> Caused by: org.postgresql.util.PSQLException: ERROR: column
>> this_.jacob_state_data does not exist
>>
>> at
>> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecu
>> torImpl.java:1608)
>>
>> at
>> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImp
>> l.java:1343)
>>
>> at
>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:
>> 194)
>>
>>
>>
>> I inspected the SQL script for POSTGRES, none of the tables have
>> jacob_state_data column.
>>
>> Have anyone come across this error? Has any one set up Apache TOMCAT +
>> ODE on Postgres DB. I am using 1.3.4 snapshot build on Postgres 8.3
>>
>>
>>
>> Thanks & Regards
>>
>> Dhanush Gopinath
>>
>>
>>
>>
>
>
> Regards,
> --
> Rafał Rusin
> http://rrusin.blogspot.com
> http://www.touk.pl
> http://top.touk.pl
>
--
Rafał Rusin
http://rrusin.blogspot.com
http://www.touk.pl
http://top.touk.pl
--- End Message ---
