hi ALL.
I tried to log sql command and params from hibernate with slf4j and logback
i added the jars to web app for slf4j and logback-classic and
logback-core into web-inf/lib.
into some method of my web app i added some log with
logger.debug("message") and logger.trace("message").
the messages are writed into the file log successfully at path
${catalina.base}/logs/WineBackboneJEE.log
But i not get the log statement of query and params created from hibernate.
Please help me to resolve.
i googled many blog but i not can resolve.
hibernate not write any statement into log file at :
${catalina.base}/logs/WineBackboneJEE.log
THIS BELOW is my logback.xml file configuration for slf4J logback for
hibernate
<?xml version="1.0" encoding="UTF-8"?>
<configuration debug="true">
<!-- COMMENTED FOR WRITE LOG ONLY TO FILE
<appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
<encoder
class="ch.qos.logback.classic.encoder.PatternLayoutEncoder">
<Pattern>%d{yyyy-MM-dd_HH:mm:ss.SSS} %-5level %logger{36} -
%msg%n
</Pattern>
</encoder>
</appender>
-->
<appender name="FILE"
class="ch.qos.logback.core.rolling.RollingFileAppender">
<file>${catalina.base}/logs/WineBackboneJEE.log</file>
<encoder
class="ch.qos.logback.classic.encoder.PatternLayoutEncoder">
<Pattern>%d{yyyy-MM-dd_HH:mm:ss.SSS} [%thread] %-5level
%logger{36} - %msg%n
</Pattern>
</encoder>
<rollingPolicy
class="ch.qos.logback.core.rolling.FixedWindowRollingPolicy">
<FileNamePattern>${catalina.base}/logs/WineBackboneJEE.%i.zip</FileNamePattern>
<MaxIndex>30</MaxIndex>
</rollingPolicy>
<triggeringPolicy
class="ch.qos.logback.core.rolling.SizeBasedTriggeringPolicy">
<MaxFileSize>2MB</MaxFileSize>
</triggeringPolicy>
</appender>
<logger name="org.hibernate" level="TRACE" additivity="false">
<appender-ref ref="FILE"/>
</logger>
<logger name="org.hibernate.SQL" level="debug" additivity="false">
<appender-ref ref="FILE"/>
</logger>
<logger name="org.hibernate.type.descriptor.sql" level="trace"
additivity="false">
<appender-ref ref="FILE"/>
</logger>
<root level="TRACE">
<appender-ref ref="FILE" />
<!-- COMMENTED FOR WRITE LOG ONLY TO FILE
<appender-ref ref="STDOUT" />
-->
</root>
</configuration>
------------------------------------------------------------------
i paste some messges writed into my file log:
2021-12-28_22:53:00.923 [http-nio-8080-exec-2] TRACE
o.c.c.e.s.WinesFacadeBackboneRESTWithUpload - trace message : called the
method for get all wines...
2021-12-28_22:53:00.967 [http-nio-8080-exec-2] DEBUG
o.c.c.e.s.WinesFacadeBackboneRESTWithUpload - debug message: called the
method for get all wines...
2021-12-28_22:53:19.789 [http-nio-8080-exec-6] TRACE
o.c.c.e.s.WinesFacadeBackboneRESTWithUpload - trace message : called the
method for get all wines...
2021-12-28_22:53:19.793 [http-nio-8080-exec-6] DEBUG
o.c.c.e.s.WinesFacadeBackboneRESTWithUpload - debug message: called the
method for get all wines...
2021-12-28_22:53:21.702 [http-nio-8080-exec-9] TRACE
o.c.c.e.s.WinesFacadeBackboneRESTWithUpload - trace message : called the
method for get all wines...
2021-12-28_22:53:21.704 [http-nio-8080-exec-9] DEBUG
o.c.c.e.s.WinesFacadeBackboneRESTWithUpload - debug message: called the
method for get all wines...
........................................................................................................
the messages with level TRACE and debug are logged from my method into
rest resource.
but the statement and params generated from hibernate are not present
into my file log.
--
Questa e-mail è stata controllata per individuare virus con Avast antivirus.
https://www.avast.com/antivirus
