2 Replies Latest reply on Apr 24, 2002 4:56 AM by miriam

    View sql generated by JBoss

    miriam Newbie

      Hello!
      I'am using JBoss3.0 beta with Oracle. In forums is written that the generated sql can be seen with p6spy. Could anybody tell me what files do I have to configure in order to make p6sy and JBos3.0 beta "work together"?
      Thank's.

        • 1. Re: View sql generated by JBoss
          Enrique Rodriguez Newbie

          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 Newbie

            Thank's a lot.