Show generated SQL statements in console

[dho]

Hi,

Is it somehow possible that the SQL statements generated by JBoss (when I use CMP) will be shown in the console? I am using JBoss 3.2.5.

Thanks.

Daniel

[dev2gosoft]

Yes. Choose "DEBUG" (instead of "Info" )level of message in log4j.xml
../conf directory.


You will get a whole bunch of debug level messages in the console along with generated sql by the cmp.


hope it helps

[dho]

Thanks for the tip. I allowed me to solve my CMP problem quickly.

Regards,
Daniel

[dev2gosoft]

dho,

Actually Alexey pointed out how to turn on just the cmp queries instead of all the crap that gets out in the approach i mentioned.


I am posting what alexey posted in one of my topics. Hope it helps




--------------------------------------------------------------------------------

Reposting XML in the code block
Code:








_________________
Alexey Loubyansky
CMP Lead Developer
JBoss, Inc

[dev2gosoft]

Here is the code block. i forgot to put code tags around it

--------------------------------------------------------------------------------

<category name="org.jboss.ejb.plugins.cmp">
 <priority value="DEBUG"/>
 </category>