Modify you Db-service.xml instead.
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 ?
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 !
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 ?
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