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
