topic Problem with schemas in PostgreSQL in Alfresco Archive

Problem with schemas in PostgreSQL

blopes — Tue, 18 Jun 2013 20:44:47 GMT

Hi everybody, I'm trying to use Activiti 5.12.1 in Grails 2.2.2 and generate its tables in a different schema in PostgreSQL 9.1. Using the default schema (public) it works very nice, but trying to use with another schema (activiti, for instance), I see the same error as in http://jira.codehaus.org/b

Re: Problem with schemas in PostgreSQL

trademak — Wed, 19 Jun 2013 10:22:24 GMT

Hi Bruno,

Yes that's a known issue. We plan to fix that in the next release (5.13.1). In the meantime what you can do is create the schema with our DDL files and set the databaseSchemaUpdate value to "none". And then only set the databaseTablePrefix value to your schema name.

Best regards,

Re: Problem with schemas in PostgreSQL

balunadig — Mon, 14 Apr 2014 22:20:15 GMT

Hi Tijs:

I am using 5.14/515 activiti wiith H2. I am trying to get a named schema work with it.

property name="databaseSchema" value="ACTIVITIDS"
property name="databaseTablePrefix" value="ACTIVITIDS."
property name="databaseSchemaUpdate" value="none"

Do I still need to do create schema activitiDS and the qualifier (activityDS.) to the ddl?

Re: Problem with schemas in PostgreSQL

trademak — Wed, 16 Apr 2014 14:21:47 GMT

Hi,

Yes, we didn't do any changes to this logic yet.

Best regards,