Thanks Rafał I could create the new DB schema in Postgres and run the application. Many thanks for your help.
-----Original Message----- From: Rafal Rusin [mailto:[email protected]] Sent: Tuesday, April 27, 2010 2:14 AM To: [email protected] Subject: Re: ODE on Postgres 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
