JBoss and p6spy

[ali-gator]

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.

[fbiaggi]

Modify you Db-service.xml instead.
Ciao.

[ali-gator]

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

[fbiaggi]

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.

[ali-gator]

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

[ali-gator]

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