I'm looking for help on how to log bootstrap DDL and runtime DML statements with Activiti Core 7.7.0 and Spring Boot 2.7.7. According to comments on this question, I simply need to enable hibernate SQL logging, which I've attempted to do in my application properties. Here's the "STDOUT" approach I've tried:
spring.datasource.url=jdbc:h2:./data/activiti-engine
spring.jpa.hibernate.ddl-auto=update
spring.jpa.properties.hibernate.format_sql=true
spring.jpa.properties.hibernate.show_sql=true
...and here's the "Java Logger" approach I've tried:
spring.datasource.url=jdbc:h2:./data/activiti-engine
spring.jpa.hibernate.ddl-auto=update
logging.level.org.hibernate.SQL=DEBUG
logging.level.org.hibernate.type.descriptor.sql.BasicBinder=TRACE
Neither approach produces SQL statements in the console.
It's clear to me that Activiti is picking up the datasource.url and ddl-auto properties, as the file-based database contains tables, and the ACT_PROCDEF_INFO table has rows for each BPMN file I've stored in src/main/resources/processes. I just don't see the SQL statements that are producing all this work.
I should point out that I've declared neither a logback nor a log4j configuration file, so I'm seeing the default logging levels printed to the console. Plenty of log output appears in the console, but no SQL.
