topic Re: Change the H2 database doesn't work in Alfresco Archive

Change the H2 database doesn't work

paco67 — Tue, 20 Jan 2015 14:37:26 GMT

Hello,I need to switch between the embedded H2 database to the persistent H2 database.I installed and started the H2 database version 2014-04-05.I copied activiti-explorer.war and activiti-rest.war into tomcat webapp and started to deply the apps.I turned off tomcat and modified both db.properties a

Re: Change the H2 database doesn't work

jbarrez — Wed, 21 Jan 2015 13:48:02 GMT

Which Activiti version are you trying this on?

On the latest version, the jdbc.url property is used, but default to H2 if not found, see https://github.com/Activiti/Activiti/blob/master/modules/activiti-webapp-explorer2/src/main/java/org/activiti/explorer/conf/ActivitiEngineConfiguration.java#L56

You sure the db properties is on the classpath?

Re: Change the H2 database doesn't work

paco67 — Wed, 21 Jan 2015 14:07:55 GMT

Thanks for your help.

I tried Activiti 5.17 and 5.13. I changed the jdbc.url string into "db.properties" under C:\Tomcat-8.0.17\webapps\activiti-explorer\WEB-INF\classes and under C:\Tomcat-8.0.17\webapps\activiti-rest\WEB-INF\classes.

What do you mean the db.properties file is "on the classpath" ?

Re: Change the H2 database doesn't work

paco67 — Thu, 22 Jan 2015 10:27:55 GMT

Sorry I'm a newbie, today I tried to use JNDI:

1. Into activiti-explorer webapp, replaced the META-INF\context.xml with:

<?xml version="1.0" encoding="UTF-8"?>
<Context antiJARLocking="true" path="/activiti-explorer"/>
<Resource auth="Container" name="jdbc/activitiDB" type="javax.sql.DataSource" scope="Shareable" description="JDBC DataSource" url="jdbc.url=jdbc:h2:tcp://localhost/activity" driverClassName="org.h2.Driver" username="sa" password="" defaultAutoCommit="false" initialSize="5" maxWait="5000" maxActive="120" maxIdle="5"/> </Context>

2. Opened the Spring configuration files:

activiti-explorer/WEB-INF/activiti-standalone-context.xml
activiti-rest/WEB-INF/classes/activiti-context.xml

I delete the beans named "dbProperties" and "dataSource".
I add the bean:

<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
<property name="jndiName" value="java:comp/env/jdbc/activitiDB"/>
</bean>

Unfortunatelly it doesn’t work.

Re: Change the H2 database doesn't work

paco67 — Thu, 22 Jan 2015 10:29:44 GMT

I don't know why but the XML code has been deleted.

Re: Change the H2 database doesn't work

paco67 — Mon, 26 Jan 2015 13:49:45 GMT

Dear jbarrez I solved,

the connection string "jdbc.url=jdbc:h2:tcp://localhost/activity" into db.properties is wrong.

The correct one is "jdbc.url=jdbc\:h2\:tcp\://localhost/activiti" and now it works.

Thanks and regards.