How to access & perform DB operations using datasource configured in server.xml

Camunda 7 Topics Discussion & Questions
1

I have configured oracle db in server.xml as per the documentation @ Database | docs.camunda.org

<property name="jdbcUrl" value="jdbc:h2:mem:camunda;DB_CLOSE_DELAY=1000" />
<property name="jdbcDriver" value="org.h2.Driver" />
<property name="jdbcUsername" value="sa" />
<property name="jdbcPassword" value="" />

How to access & perform DB operations using datasource in a service task (implementation is in java delegate) ? I didn’t found any samples or more details on this. Please suggest.

2

@jvm what operation are you trying to perform with data source?

3

Hi @jvm,

to do data manipulation, just code them as JDBC statements in your java delegate.

Or use a persistence framework of your choice to do it in the java delegate.

Hope this help, Ingo

4

Any examples or code samples available for performing DB operations (like select) in java delegate with configured jdbc params with oracle db details ?

5

Hi @jvm,

it’s common java stuff, not any Camunda specifics included. A Google search should help you out.

Hope this helps, Ingo