Boa tarde!
Eu tenho uma aplicação usando o hibernate, o log4j configurado com o log4j.xml.
Eu consigo separar os sqls, mas nao consigo gerar o log do org.hibernate.type
Segue abaixo o log4j.xml que eu estou configurando.
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">
<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/" debug="false">
<appender name="CONSOLE" class="org.apache.log4j.ConsoleAppender">
<param name="Target" value="System.out"/>
<layout class="org.apache.log4j.PatternLayout">
<param name="ConversionPattern" value="[%d{dd-MM-yyyy HH:MM:SSSS}] [%5p] [%F:%L] [userId: %X{userId}] [%m%n]" />
</layout>
</appender>
<appender name="SQL" class="org.apache.log4j.DailyRollingFileAppender">
<param name="File" value="/home/administrator/Log/sql.log"/>
<param name="DatePattern" value="'.'dd-MM-yyyy"/>
<param name="Append" value="true"/>
<layout class="org.apache.log4j.PatternLayout">
<param name="ConversionPattern" value="[%d{dd-MM-yyyy HH:MM:SSSS}] [%5p] [%F:%L] [userId: %X{userId}] %m%n"/>
</layout>
<filter class="org.apache.log4j.varia.StringMatchFilter">
<param name="StringToMatch" value="insert"/>
<param name="AcceptOnMatch" value="true" />
</filter>
<filter class="org.apache.log4j.varia.StringMatchFilter">
<param name="StringToMatch" value="update"/>
<param name="AcceptOnMatch" value="true" />
</filter>
<filter class="org.apache.log4j.varia.StringMatchFilter">
<param name="StringToMatch" value="delete"/>
<param name="AcceptOnMatch" value="true" />
</filter>
<filter class="org.apache.log4j.varia.StringMatchFilter">
<param name="StringToMatch" value="binding"/>
<param name="AcceptOnMatch" value="true" />
</filter>
<filter class="org.apache.log4j.varia.DenyAllFilter" />
</appender>
<category name="org.hibernate.SQL">
<priority value="DEBUG"/>
<appender-ref ref="SQL"/>
</category>
<category name="org.hibernate.type">
<priority value="DEBUG"/>
<appender-ref ref="SQL"/>
</category>
</log4j:configuration>
Agradeço a ajuda e já olhei sobre, mas não entendo o motivo de não gerar, se esta logando apenas os insert, update e delete como configurei. Já testei no console e nem nele funciona.
Obrigado!