This content has been marked as final.
Show 3 replies
-
1. Re: Showing the SQL Queries from EJB CMP
stateri Sep 15, 2004 6:22 PM (in response to 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, -
2. Re: Showing the SQL Queries from EJB CMP
nickman Dec 1, 2004 11:03 AM (in response to stateri)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. -
3. Re: Showing the SQL Queries from EJB CMP
ssmithstone Dec 1, 2004 11:08 AM (in response to stateri)if you using Mysql and Mysql-ConnectorJ you can add ?profileSql=true on the end of the jdbc-url