ODE on Postgres

[Dhanush Gopinath]

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