How to create a new database table and perform CURD operations

I have requirement of in creating a new database table and perform CURD operations. Can you help in doing it?

@Leela are you using camunda framework?

Thanks for replying,
Yes, I’m using camunda framework.

yes, using the camunda framework.

Hi @Leela

How are you running camunda? Using containers (wildfly, JBoss, Tomcat) or spring boot?

@Leela, Adding below property will auto create tables and indexes. Note that in the firsthand you need to create empty schema. Camunda won’t create schema/database rather it creates tables and indexes.

If you use spring add below property to the application.yaml configuration file.

camunda:
    bpm:
        database:
            schema-update: create

For container managed process engine refer below:

https://docs.camunda.org/manual/latest/user-guide/process-engine/database/#example-database-configuration

using Tomcat to run camunda