Support for Hana database


#1

I’d like to add support for using the Hana database to Camunda. Is there some documentation available to help me do this?
I managed to add the database but I need to see the SQL being executed to try and determine some problems I see.

thanks,
Paul


#2

Hi Paul,

You can set the logger org.camunda.bpm.engine.impl.persistence.entity to DEBUG to have all SQL statements logged.

Cheers,
Thorben


Printing Camunda's SQL statements
Error: insertHistoricVariableInstance (batch index #1) failed
#3

Thanks for the reply, Thorben.

I want to see the SQL executed when running tests in engine, like:
mvn test -Pdatabase,hana -Ddatabase.url=jdbc:sap://xxx -Ddatabase.username=xxx -Ddatabase.password=xxx -Dmaven.surefire.debug -Dtest=VariableScopeTest

I then added the logger property to:
engine\src\test\resources\logging.properties

Where can I expect to see the logging output or am I doing this incorrectly?
Also, is this documented somewhere?

thank-you,

Paul


#4

You have to add it to engine/src/test/resources/logback-test.xml and the output should appear in the surefire reports.

Cheers,
Thorben


#5

Thanks Thorben,
That works for some SQL executions but not all.

For example,
HistoricBatchManagerBatchesForCleanupTest
executes ‘selectHistoricBatchIdsForCleanup’ which had a problem returning the correct row count for me.

I do not see the execution of the SQL in the log.
Any idea why?

Paul


#6

Hi Paul,

For some queries you need different logger, in this case you need:
org.camunda.bpm.engine.impl.batch.history

Best regards,
Yana


#7

Hi @ptonizzo,

here is a complete list: Logging in Camunda Engine

Cheers, Ingo


#8

Thanks for your help, folks!