topic Re: Activiti Database Setup - 5.19.0.2 in Alfresco Archive

Activiti Database Setup - 5.19.0.2

snehasissamal — Mon, 04 Apr 2016 13:00:43 GMT

Hi,I have just started one POC on Activiti & able to run the explorer in Tomcat.I created some users & groups but once the Tomcat is restarted I found that the users and groups I created are not there.I have not done any changes respective to the database & its using the internal h2 DB.I

Re: Activiti Database Setup - 5.19.0.2

jbarrez — Mon, 04 Apr 2016 14:47:23 GMT

"I have not done any changes respective to the database & its using the internal h2 DB."

H2 is an in memory database. On a reboot, the JDK is killed and all data is gone. You have to switch to another (persistent) database if you want your data t survive reboots: http://activiti.org/userguide/index.html#activiti.setup.database

Re: Activiti Database Setup - 5.19.0.2

snehasissamal — Wed, 06 Apr 2016 11:43:23 GMT

Thanks jbarrez.

I went through the user guide but not clear what exactly needs to be done.
We have one standalone SQL Server database in one of the VM & I want to connect to that DB.

Here are the steps what I did.

Step 1: Created a database "activiti" and given access to the default account sa as dbAdmin
Step 2: Made changes in "db.properties" file placed in "…activiti-explorer\WEB-INF\classes"

db=mssqljdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriverjdbc.url=jdbc:sqlserver://110.6.115.11:1433/activiti;DB_CLOSE_DELAY=1000
jdbc.username=sa
jdbc.password=Welcome1

Step 3: I restarted the Tomcat server & was expecting the default tables needs to be created in our SQL Server DataBase.

When I logged in the activiti explorer it was like as I logged in for the first time. But didnt find a single table in the Activiti database.

Am I missing something else ? Here are the activiti versions

Activiti Version: 5.19.0.2
JDK:8
apache-tomcat-7.0.68

I am new in activiti and need your help to fix the same.

Thanks

Re: Activiti Database Setup - 5.19.0.2

jbarrez — Thu, 07 Apr 2016 10:25:09 GMT

Changing db.properties should all you need to do .. the tables should be created automatically for you. Do you see any logging when booting up? It should give some sql server specific log lines (creating schema)