How to view process engine tables like ACT_RE_PROCDEF, ACT_RU_EXECUTION, ACT_RU_TASK, etc

Camunda 7 Topics Discussion & Questions
1

Hello,
I am using Camunda BPM Engine 7.15 with embedded Tomcat.
I saw somewhere like http://localhost:8080/h2/h2 would show these tables. But I could see only the Information schema in it.

I tried to connect in Oracle SQL and it said “The network adapter could not establish the connection” error.
I have H2 as well as Oracle in my machine. Could you please explain how to connect and view the process tables?

2

Have you executed the db scripts manually? Could you explain more about your setup whether it’s spring boot app?

3

Hi @aravindhrs,

Thanks for your reply.

I am a beginner in this. I didn’t execute any db scripts.

I am running the tomcat version of Camunda Engine. I create a basic bpmn diagram and deployed it. Nothing else.

I just wanted to see the created process instance and process definition in tables.

Please tell me the way on how to execute db scripts.

Thanks,
Mahesh

4

Have you downloaded the tomcat which comes with camunda dependencies as full distribution or plain vanilla tomcat server?

Refer this page for camunda setup with tomcat.

https://docs.camunda.org/manual/7.15/installation/full/tomcat/

You can follow either one of the approach described over there.