-
1. Re: JBoss and p6spy
fbiaggi Jul 23, 2003 8:20 AM (in response to ali-gator)Modify you Db-service.xml instead.
Ciao. -
2. Re: JBoss and p6spy
ali-gator Jul 24, 2003 7:10 AM (in response to 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 -
3. Re: JBoss and p6spy
fbiaggi Jul 24, 2003 7:30 AM (in response to ali-gator)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 Jul 24, 2003 9:29 AM (in response to 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 -
5. Re: JBoss and p6spy
ali-gator Jul 24, 2003 12:10 PM (in response to 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