cancel
Showing results for 
Search instead for 
Did you mean: 

Activiti 5.14 + PostgreSQL(nondefault shema) dose not work

nazavoya
Champ in-the-making
Champ in-the-making
  Hi, I'm a Java programmer from China, I use Activiti as the workflow engine for our company's software,but I encounter a problem, and this problem also happened on previous version.
We use the PostgreSQL as our DB, when I created the activiti tables in the fefault shema(public) ,there's no problerm,but when I created them in another one(activiti) ,an also config the "databaseSchema=activiti"  and "databaseTablePrefix=activiti.",then I start my web app, it has errors :“Activiti database problem: Tables missing for component(s) engine, history, identity …….", and the "databaseSchemaUpdate=true" looks like doesn't support PostgreSQL's nondefault schema. so I wander that,is there any bug in current version,or I have somthing wrong with my config file? i have check my config file many times, and just do not work at nondefault schema.
4 REPLIES 4

martin_grofcik
Confirmed Champ
Confirmed Champ
Does your database contain tables for engine, history…. .
You can create them
http://www.activiti.org/userguide/#creatingDatabaseTable

yes, I have already execute the sql scripts in the activiti's distribution pack, 23 tables has been created in the schema(activiti),if I use default schema to create tables, it works well ,but doesn't works on any other schema…

trademak
Star Contributor
Star Contributor
Yes, it's a know issue. See https://jira.codehaus.org/browse/ACT-1708
We'll try to resolve it for the next release.

Best regards,

nazavoya
Champ in-the-making
Champ in-the-making
Thank you for your help, expect the next version~! O(∩_∩)O