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. Also make sure to increase the org.jboss category before reducing the org.jboss.ejb.plugins.cml category.
-dain wonder sonic wrote: > 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 > >>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 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 by JBoss for CMP entities? >>>>A sort of debug level to setup in a config file... >>>> >>>>TIA, >>>>Wonder Sonic >>>> >>> ------------------------------------------------------- Sponsored by: ThinkGeek at http://www.ThinkGeek.com/ _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
