topic help whit BD activiti in Alfresco Archive

help whit BD activiti

samuray258 — Tue, 21 Jan 2014 19:28:09 GMT

I have a workflow project in eclipse indigo, I got connected to a postgresql database view. 9 …. but I need to connect and create activiti data base, I have no idea what I have to put in the "activiti.cnf.xml" methods or class or that I do … please respond promptly possible

Re: help whit BD activiti

jbarrez — Wed, 22 Jan 2014 14:07:54 GMT

<code>
<property name="databaseSchemaUpdate" value="true" />
</code>

For automatic creation. The zip file from the website contains DDL sql scripts for each database.

"please respond promptly possible"

> We always do. But we get itchy from being pushed.

Re: help whit BD activiti

samuray258 — Thu, 23 Jan 2014 16:04:59 GMT

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans
    http://www.springframework.org/schema/beans/spring-beans.xsd">

<bean id="processEngineConfiguration"
class="org.activiti.engine.impl.cfg.StandaloneInMemProcessEngineConfiguration">
<property name="databaseSchemaUpdate" value="true"/>
<property name="dataSource" ref="dataSource"/>
</bean>

    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" >
    <property name="driverClassName" value="org.postgresql.Driver" />
    <property name="url" value="jdbcostgresql://localhost:5432/activiti" />
    <property name="username" value="postgres" />
    <property name="password" value="******secret*******" />
    <property name="defaultAutoCommit" value="false" />
</bean>

</beans>

Re: help whit BD activiti

samuray258 — Thu, 23 Jan 2014 16:05:23 GMT

thanks for your answer, i resolved with this :

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans
    http://www.springframework.org/schema/beans/spring-beans.xsd">

<bean id="processEngineConfiguration"
class="org.activiti.engine.impl.cfg.StandaloneInMemProcessEngineConfiguration">
<property name="databaseSchemaUpdate" value="true"/>
<property name="dataSource" ref="dataSource"/>
</bean>

    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" >
    <property name="driverClassName" value="org.postgresql.Driver" />
    <property name="url" value="jdbcostgresql://localhost:5432/activiti" />
    <property name="username" value="postgres" />
    <property name="password" value="******secret*****" />
    <property name="defaultAutoCommit" value="false" />
</bean>

</beans>