Fetchandlock External task not working with oracle

I am using camunda external task.

API rest/external-task/fetchAndLock
works well with h2 database where it lists all the tasks as per topic and other mandatory parameters.

However it doesn’t work well with oracle11g database where an empty response is returned. Because of which external task is never executed.
Below details of camunda and spring boot are used


@kaushik_raj can you share the configuration for oracle datasource. Also if you had got any exception provide the stack trace inorder to sort out the issue.


I don’t see any issue in stacktrace but only fetchandlock always results in empty response. I would suggest you to check by creating a simple external task process with oracle db and check if its working

oracle ojdbc6

The above dependency for oracle has been used