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
