Camunda DB queries

Camunda 7 Topics Discussion & Questions
1

Hi Team,

Need your help on below queries?

  • How do i query camunda H2 DB?
  • How does Data get saved in camunda. As a BLOB or Clob ?
  • How can we connect to external DB from Camunda ? Example: Oracle or Mongo
1 Like
2

Hi

For H2 DB access, instructions for Tomcat can be found here [1]

Primitive variable types are stored as native types in a DB column. Object types may be stored as serilaized byte arrays in a CLOB structure in the DB.

You can find an example of how to connect to a DB in Tomcat here [2]

regards

Rob

[1] https://docs.camunda.org/manual/7.6/installation/full/tomcat/pre-packaged/#accessing-the-h2-console
[2] https://docs.camunda.org/manual/7.6/installation/full/tomcat/manual/#configure-a-jdbc-resource

2 Likes
3