5 Replies Latest reply on Jul 24, 2003 12:10 PM by ali-gator

    JBoss and p6spy

    ali-gator Newbie

      Hello does anyone know how to install p6spy driver with JBoss 3.x ?

      According to the doc, I have to create a p6spy-service.xml, but I don't know how to configure the MBean inside...

      Here is what I've already tried without any success (it's told to take an a JCA example):

      <?xml version="1.0" encoding="UTF-8"?>





      P6spy


      <config-property name="ConnectionURL" type="java.lang.String">p6spy:jdbc:oracle:thin:@pcdell17:1521:WAS603</config-property>
      <config-property name="DriverClass" type="java.lang.String">com.p6spy.engine.spy.P6SpyDriver</config-property>







      Does anyone know what's wrong ?
      Thanks by advance.

        • 1. Re: JBoss and p6spy
          Franco Apprentice

          Modify you Db-service.xml instead.
          Ciao.

          • 2. Re: JBoss and p6spy
            ali-gator Newbie

            Thank you.

            I took my db-service.xml, made the the modifications and renamed it in p6spy-service.xml.

            It worked fine but just one time !!!
            I don't change anything but I just had the log at the first time and never after.

            Have you met this problem ?

            Thank you

            • 3. Re: JBoss and p6spy
              Franco Apprentice

              No,
              but the only think that I changed in my DB-service.xml is the driver class, nothing other, no new attribute, no rename, etc.
              Try this way, copy the p6spy files in jboss, configure the property file of p6spy, and it should work. I use it from jboss 2.x to 3.2.1.
              I you like try IronEYESql (from IronGrid) to see graphical results on it, very nice !
              Ciao.

              • 4. Re: JBoss and p6spy
                ali-gator Newbie

                I did what you wrote.

                Now the file spy.log appears each time, I can see the SQL request.

                But, I can't have the result of the request and JBoss returns a Java Exception...

                however I write this in the properties file:

                # oracle driver
                realdriver = oracle.jdbc.driver.OracleDriver

                It seems JBoss can't find the driver (I had no pb with them before)

                Do I forget something ?

                Thank you

                • 5. Re: JBoss and p6spy
                  ali-gator Newbie

                  I try IronEyeSQL and it works very fine :o)

                  I think my problem was due to my p6spy.jar which was not the same than the one given with IronEyeSQL (mine was smaller).

                  Thanks a lot for all you advices !!!


                  PS: I did like you said and work directly with my db-service.xml