i want configure jboss 7 save 2 categories in different file, file sql_hib.log empty when start jboss. file_sql handler doesn't working. don't know why... if place file_sql root loggers - sql_hib.log starts grow, in case contains lot of redundant logs. part of standalone.xml
<subsystem xmlns="urn:jboss:domain:logging:1.1"> <console-handler name="console"> ... </console-handler> <periodic-rotating-file-handler name="file"> ... </periodic-rotating-file-handler> <periodic-rotating-file-handler name="file_sql" autoflush="true"> <level name="trace"/> <formatter> <pattern-formatter pattern="%d{yyyy-mm-dd hh:mm:ss} %-5p [%c] (%t) %s%e%n"/> </formatter> <file relative-to="jboss.server.log.dir" path="sql_hib.log"/> <suffix value=".yyyy-mm-dd"/> <append value="true"/> </periodic-rotating-file-handler> <logger category="org.hibernate.sql"> <level name="trace"/> <handlers> <handler name="file_sql"/> </handlers> </logger> <logger category="org.hibernate"> <level name="trace"/> <handlers> <handler name="file_sql"/> </handlers> </logger> <root-logger> <level name="trace"/> <handlers> <handler name="console"/> <handler name="file"/> </handlers> </root-logger> </subsystem>
i've made setting debug sql queries , parameters. that's why i've decided use separate file. made more categories, because 1 class making text. abstractresultsetproxyhandler mentioned before - settings starts working... change them bit - avoid ocean unnecessary text. result settings:
<subsystem xmlns="urn:jboss:domain:logging:1.1"> <console-handler name="console"> <level name="info"/> <formatter> <pattern-formatter pattern="%d{yyyy-mm-dd hh:mm:ss.sss} %-5p [%c] (%t) %s%e%n"/> </formatter> </console-handler> <periodic-rotating-file-handler name="file"> <formatter> <pattern-formatter pattern="%d{yyyy-mm-dd hh:mm:ss.sss} %-5p [%c] (%t) %s%e%n"/> </formatter> <file relative-to="jboss.server.log.dir" path="server.log"/> <suffix value=".yyyy-mm-dd"/> <append value="true"/> </periodic-rotating-file-handler> <periodic-rotating-file-handler name="file_sql" autoflush="true"> <level name="trace"/> <formatter> <pattern-formatter pattern="%d{yyyy-mm-dd hh:mm:ss} %-5p [%c] (%t) %s%e%n"/> </formatter> <file relative-to="jboss.server.log.dir" path="sql_hib.log"/> <suffix value=".yyyy-mm-dd"/> <append value="true"/> </periodic-rotating-file-handler> <logger category="org.hibernate.sql"> <level name="trace"/> <handlers> <handler name="file_sql"/> </handlers> </logger> <logger category="org.hibernate.type"> <level name="trace"/> <handlers> <handler name="file_sql"/> </handlers> </logger> <logger category="org.hibernate.loader"> <level name="trace"/> <handlers> <handler name="file_sql"/> </handlers> </logger> <logger category="org.hibernate.persister"> <level name="trace"/> <handlers> <handler name="file_sql"/> </handlers> </logger> <logger category="org.hibernate.hql"> <level name="trace"/> <handlers> <handler name="file_sql"/> </handlers> </logger> <logger category="org.hibernate.cfg"> <level name="trace"/> <handlers> <handler name="file_sql"/> </handlers> </logger> <logger category="org.hibernate.dialect"> <level name="trace"/> <handlers> <handler name="file_sql"/> </handlers> </logger> <logger category="org.hibernate.service"> <level name="trace"/> <handlers> <handler name="file_sql"/> </handlers> </logger> <logger category="org.hibernate.engine.jdbc.internal.proxy.preparedstatementproxyhandler"> <level name="trace"/> <handlers> <handler name="file_sql"/> </handlers> </logger> <root-logger> <level name="debug"/> <handlers> <handler name="console"/> <handler name="file"/> </handlers> </root-logger> </subsystem> i know it's better filter 1 abstractresultsetproxyhandler place every other category settings. don't know how filter. , settings works. hibernate logs written in server.log too. don't understand why
Comments
Post a Comment