H2 file Database is physically not created but only in memory

Camunda 7 Topics Discussion & Questions
1

Hello,
I simply reconfigured my application.yml as below in spring boot, the problem is that i could not see the file H2 that represent the database.
In fact data base is not created and when i restart server, i find that there is no history or process instances, it seems that all been done in memory

I need to show, configure and ever connect to DB.

Thanks.

//////////////////////////////////////////////////////////////////////////////////////////////////////////
spring.datasource.url: jdbc:h2:file:./camunda-h2-database

camunda.bpm.admin-user:
id: a
password: a

server:
port: 8070
//////////////////////////////////////////////////////////////////////////////////////////////////////////

2

The problem is solved
I should add this dependency :

<dependency>
  <groupId>org.springframework.boot</groupId>
  <artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
1 Like
3

Could you explain more?

Where did you add this dependency?

4

@ams it should be placed in pom.xml and you need to add dependency to the parent tags:

<dependencies>
    <dependency>
       <groupId>org.springframework.boot</groupId>
       <artifactId>spring-boot-starter-data-jpa</artifactId>
    </dependency>
   //other dependencies
</dependencies>
5

Appreciate your response.

I’m totally new to Camunda and the Java environment.

It appears that I got it totally wrong.

Here is my problem:

I set up the Camunda on ubuntu server by the start.sh file and completed the quick start guide.

Now I want to access the data that users submitted in their respective forms.

I configured the h2 server to be accessible through http://localhost:8080/h2-console, but I can’t find any tables showing the data entered in the processes.

How would I be able to access the tables showing the data inserted in Camunda processes?

6

@ams Are you following camunda spring boot architecture setup?

7

No, do I have to go through the spring boot setup to achieve what I want?

8

Tomcat or wildfly distribution? Can you explain about your setup?

9

Honestly I’m not sure which one it is.

I simply downloaded the recommended zip file at Download Open Source Workflow Software | Camunda and ran the start.sh file and everything went up and running.

The only config I did myself is adding this to my default.xml to enable the h2 console:

spring: h2: console: enabled: true settings: web-allow-others: true

1 Like
10

Okay, connecting to the H2 database through the web console, I changed the JDBC url to match the url specified in default.xml and now I can see all the tables created by Camunda.

But still I can’t find the variables submitted in the forms by users in the table ACT_RU_VARIABLE

1 Like
11

Okay it appears the variables I’m looking for are stored in ACT_HI_VARINST .

Thank you

12

@ams Glad you found the solution. Welcome to the forum :partying_face:

1 Like
13

Thank you!

14