Activiti 5.19 with Hibernate

turael — Mon, 11 Apr 2016 11:22:05 GMT

Hello friends of activiti,currently I have a very strange problem - my identity tables (from activiti.h2.create.identity.sql) not exists in my h2 database (for junit testing).I use activiti 5.19.0 and hibernate 5.1.0 in my project. Activiti is connected to a transactionManager and a sessionFactory e

Re: Activiti 5.19 with Hibernate

jbarrez — Tue, 12 Apr 2016 11:36:15 GMT

I've never seen that issue … we also use hibernate in the commercial version … but did not encounter this.

Could it be there is a table name overlap?

Re: Activiti 5.19 with Hibernate

turael — Tue, 12 Apr 2016 12:57:44 GMT

Activiti has a special namespace for the tables, while our tables dont have a namespace and the names are written in german - so i can exclude an overlaping problem

Maybere there are a configuration problem? But its mostly the default configuration from the guide…(execpt the sessionFactory)

<code>
<bean id="dataSource"
class="org.springframework.jdbc.datasource.SimpleDriverDataSource">
<property name="driverClass" value="org.h2.Driver" />
<property name="url" value="jdbc:h2:tcp://localhost/~/activiti" />
<property name="username" value="sa" />
<property name="password" value="" />
</bean>

<!– Hibernate Transaction Manager Definition –>
<bean id="transactionManager"
class="org.springframework.orm.hibernate5.HibernateTransactionManager">
<property name="sessionFactory" ref="sessionFactory" />
<property name="dataSource" ref="dataSource" />
</bean>

<!– Hibernate Session Factory –>
<bean id="sessionFactory"
class="org.springframework.orm.hibernate5.LocalSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="packagesToScan" value="de.custom.db.model" />
<property name="hibernateProperties">
   <props>
    <prop key="hibernate.dialect">org.hibernate.dialect.H2Dialect</prop>
    <prop key="hibernate.show_sql">false</prop>
    <prop key="hibernate.format_sql">true</prop>
    <prop key="hibernate.generate_statistics">false</prop>
    <!– <prop key="hibernate.hbm2ddl.auto">create</prop> –>
   </props>
</property>
</bean>

<bean id="processEngineConfiguration" class="org.activiti.spring.SpringProcessEngineConfiguration">
<property name="transactionManager" ref="transactionManager" />
<property name="databaseSchemaUpdate" value="true" />
<property name="jobExecutorActivate" value="true" />

<property name="asyncExecutorEnabled" value="true" />
<property name="asyncExecutorActivate" value="true" />

<property name="databaseType" value="h2" />
<property name="history" value="full" />

<property name="mailServerHost" value="localhost" />
<property name="mailServerPort" value="25" />
</bean>

</code>

Re: Activiti 5.19 with Hibernate

jbarrez — Wed, 20 Apr 2016 12:19:53 GMT

That config looks ok at a quick glance … nothing odd there.
I agree an overlap is odd, yet … it's the only way (looking at the code) I can see it being skipped.

Does your jdbc user have maybe access to more than one schema? Maybe it's reading from a different schema?

topic Re: Activiti 5.19 with Hibernate in Alfresco Archive

Activiti 5.19 with Hibernate

Re: Activiti 5.19 with Hibernate

Re: Activiti 5.19 with Hibernate

Re: Activiti 5.19 with Hibernate