I tried this:
category name=org.jboss.ejb.plugins.cmp
priority value=DEBUG/
/category
but I don't get any SQL requests displayed :( I use
JBoss 3.0. Do you know why?
tia,
Wonder Sonic
--- Dain Sundstrom [EMAIL PROTECTED] a écrit :
Set the org.jboss.ejb.plugins.cmp category in the
What do you mean by displayed? Do you mean console?
To have the sql messages appear on the console you need to reduce the
logging threshold on the console appended to DEBUG. You will also want
to increase the priority of the org.jboss category to INFO, or you will
get a ton of messages.
Set the org.jboss.ejb.plugins.cmp category in the log4.xml file to debug
and you will see all of the executed sql. If you want to see every
parameter and loaded column, set the level to trace. Documentation is
in the file.
-dain
Greg Turner wrote:
One way to do this is that most databases
Have you looked at p6spy ?
http://p6spy.sourceforge.net/
Formerly known as just P6Spy, P6Log intercepts and logs the database
statements of any application that uses JDBC. This application is
particularly useful for developers to monitor the SQL statements
produced by EJB servers, enabling
Okay so:
-1- how to do that with mysql? :)
-2- is there a way to do that with log4j or by
modifying any parameter in a xml file? :|
thank you in advance,
Wonder Sonic
One way to do this is that most databases have a way
to turn on trace
info, so that you can see the sql statements that
the
1. As I said, its probably in the docs specific to your db. Look it up.
2. Don't know.
wonder sonic wrote:
Okay so:
-1- how to do that with mysql? :)
-2- is there a way to do that with log4j or by
modifying any parameter in a xml file? :|
thank you in advance,
Wonder Sonic
One way
Hi,
Is there a way to read the SQL requests generated and
executed by JBoss for CMP entities?
A sort of debug level to setup in a config file...
TIA,
Wonder Sonic
___
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
One way to do this is that most databases have a way to turn on trace
info, so that you can see the sql statements that the database is
receiving from the JDBC driver. I would look at your database docs.
wonder sonic wrote:
Hi,
Is there a way to read the SQL requests generated and
executed