Edit Question - KnowledgeHub

Title Body

How can I trace SQL requests for H2 in-memory embedded databases? The documentation says the trace file is located in the same directory as the database file, but for in-memory embedded database I have no database directory (under Windows). I tried to redirect traces to a given file with slf4j/logback by using TRACE_LEVEL_FIle=4;TRACE_LEVEL_SYSTEM_OUT=3 in the database URL and the following logback.xml config file but with no luck: <configuration scan="true"> <appender name="FILE" class="ch.qos.logback.core.rolling.RollingFileAppender"> <file>mylogfile.log</file> <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy"> <fileNamePattern>%d{yyyyMMdd}_mylogfile.log</fileNamePattern> </rollingPolicy> <encoder> <pattern>%date{yyyyMMdd HH:mm:ss} %contextName[%thread] %level %logger{0} - %msg%n</pattern> </encoder> </appender> <logger name="com.myapp" level="WARN"> <appender-ref ref="FILE" /> </logger> <logger name="h2database" level="TRACE"> <appender-ref ref="FILE" /> </logger> --> <root level="WARN"> <appender-ref ref="FILE" /> </root> </configuration> My logback config file works correctly for other logs. Any idea?

Tags (comma-separated) Cancel