AnsweredAssumed Answered

Problem with schemas in PostgreSQL

Question asked by blopes on Jun 18, 2013
Latest reply on Apr 16, 2014 by trademak
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/browse/ACT-1610.  I have created the tables, and Activiti is able to find then, but this error happens.
Is there a workaround to this situation?

My activiti.cfg.xml is as follow:

<blockcode>
   <bean id="processEngineConfiguration" class="org.activiti.engine.impl.cfg.StandaloneProcessEngineConfiguration">
                <property name="processEngineName" value="activiti-engine" />
      <property name="jdbcUrl" value="jdbc:postgresql://localhost/localbd" />
      <property name="jdbcDriver" value="org.postgresql.Driver" />
      <property name="jdbcUsername" value="postgres" />
      <property name="jdbcPassword" value="postgres" />
                <property name="databaseSchema" value="activiti" />
                <property name="databaseTablePrefix" value="activiti." />
      <property name="databaseSchemaUpdate" value="false" />
      <property name="jobExecutorActivate" value="false" />
      <property name="mailServerHost" value="mail.my-corp.com" />
      <property name="mailServerPort" value="5025" />
   </bean>
</blockcode>

Thanks in advance. If you need more clarifications, let me know.

Outcomes