topic Re: How to inspect the in-memory Activiti H2 database? in Alfresco Archive

How to inspect the in-memory Activiti H2 database?

kcassell — Mon, 21 Jul 2014 14:28:07 GMT

I'm just getting started using Activiti, and I'd like to be able to examine the contents of the in-memory H2 database as I run my workflows. How can I do so? Is it possible using a tool like Squirrel? If so, what do I use as a URL, user, password, etc.? Right now, I am using the default configuratio

Re: How to inspect the in-memory Activiti H2 database?

jbarrez — Fri, 25 Jul 2014 07:26:57 GMT

In a unit test, you can inspect it quite easily: http://activiti.org/userguide/index.html#apiDebuggingUnitTest

Re: How to inspect the in-memory Activiti H2 database?

kcassell — Fri, 25 Jul 2014 15:38:12 GMT

Thanks. That provides me a way to inspect the database. It doesn't seem to work with Squirrel, and I'm not sure I understand why. But as long as I can get at the info I care about, I guess I don't really care, although I am curious.

Re: How to inspect the in-memory Activiti H2 database?

frederikherema1 — Tue, 29 Jul 2014 07:48:44 GMT

What is the issue with squirrl? H2 offers a plain old JDBC-interface, so don't see any obvious reasons why connection doesn't work. Any stack trace in squirrel?

Re: How to inspect the in-memory Activiti H2 database?

fatma19 — Thu, 13 Apr 2017 14:22:02 GMT

it works for me but is it normal that every time i restart the process engine i don't get the old processes ?

Re: How to inspect the in-memory Activiti H2 database?

cjose — Thu, 13 Apr 2017 15:00:09 GMT

yes, if running against in-memory db.

Re: How to inspect the in-memory Activiti H2 database?

fatma19 — Thu, 13 Apr 2017 15:08:45 GMT

So what can i do if i want to make db persist the old processengine instance processes?

Re: How to inspect the in-memory Activiti H2 database?

cjose — Thu, 13 Apr 2017 15:14:15 GMT

It is not about db persisting the data or not. The DB itself is not getting persisted when you use in-memory. So if you want the process data to be available after an engine re-start, use a non-in-mem db in your activiti configuration. If you are using H2, check Tutorial for more details.

Re: How to inspect the in-memory Activiti H2 database?

fatma19 — Thu, 13 Apr 2017 15:56:40 GMT

ok Thank you i will follow that

Re: How to inspect the in-memory Activiti H2 database?

fatma19 — Thu, 13 Apr 2017 22:42:03 GMT

So i will use mysql database is that a good choice with activiti?

Re: How to inspect the in-memory Activiti H2 database?

fatma19 — Thu, 13 Apr 2017 23:25:20 GMT

I used mysql database and i created the activiti database with phpmyadmin and then i made run to my java application and all the needed tables were created and the engine is persisting the data about the processes.

This is my configuration bean

Re: How to inspect the in-memory Activiti H2 database?

cjose — Thu, 13 Apr 2017 23:33:53 GMT

yes, you are on the right track!