-
1. Re: View sql generated by JBoss
lasterra Apr 22, 2002 11:28 AM (in response to miriam)Hi Miriam,
I don't use p6spy, but i know two ways to see what SQL genrate Jboss.
1.- See the server.log file in the log folder. There search for JawsPersistenceManager and you will look what SQL Code generate JBoss. The problem is that this file only is updated when you resastart Jboss.
2.-Change the log4j.properties to see de TRACER level logs for this Jboss Plugin, JAWS. I'm not a log4j expert, but this go for me: (Add at the end of log4j.properties in your conf directory)
#Define new appender Console2
log4j.appender.Console2=org.jboss.logging.log4j.ConsoleAppender
log4j.appender.Console2.layout=org.apache.log4j.PatternLayout
log4j.appender.Console2.layout.ConversionPattern=[%p,%c{1}](%F:%L) %m%n
#log the trace level for jaws pluggin
log4j.category.org.jboss.ejb.plugins.jaws=TRACE ,Console2
#end
If anybody have a better solution, tell us ;-)
Regards, Enrique -
2. Re: View sql generated by JBoss
miriam Apr 24, 2002 4:56 AM (in response to miriam)Thank's a lot.