Showing the SQL Queries from EJB CMP

[stateri]

Hi,

I´m trying to see the queries that JBoss 3.2.5 is doing when I use a EJB CMP, then I have put the following tag in the $JBoss_Home/server/default/conf/log4j.xml :

<category name="org.jboss.ejb.plugins.cmp">
 <priority value="TRACE" class="org.jboss.logging.XLevel" />
</category>

I have seen a site (http://www.jboss.org/index.html?module=bb&op=viewtopic&t=53055) that this change would show the SQL Queries make by EJB CMP and a lot of things more...

Is the tag (category) correct ?
Is the file (log4j.xml) in the correct place ($JBoss_Home/server/default/conf) ?

Thanks in advance,

Sergio Stateri Jr
[e-mail]

[stateri]

Log4J is working fine now (it was logging on a file only, and not in the console). Now I have another problem: JBoss only shows me a SQL Query like a PreparedStatement ( with ? as parameters. example: SELECT id from table where id = ? ). Is there any way to know what JBoss is putting in the place of any parameter (?) ?

Thanks in advance,

[nickman]

You can use the P6 driver.
http://www.p6spy.com/
It is a wrapper around your JDBC driver and it shows you exactly what is being executed and the values of the bind variables.

[ssmithstone]

if you using Mysql and Mysql-ConnectorJ you can add ?profileSql=true on the end of the jdbc-url