Can I view the generated SQL Statements by EJB-QL?

romanofabian Mar 20, 2003 10:50 PM

Can I view the generated SQL Statements by EJB-QL? If yes, how?

I can't find a bug on my related cmp's and JBoss is complaining about a ParseException on one of my EJB-QL Queries.I need to check the generated SQL to find out (I Think) what the problem is. Please help. Thanks

Romano

1. Re: Can I view the generated SQL Statements by EJB-QL?

stuermer_g Mar 21, 2003 10:52 AM (in response to romanofabian)

The best way is to the usage of a Profiler-Tool of you Database.

Another way is to check out the server-log in JBOSS_HOME/default/log/server.log where JBoss writes the executed SQL-Statements on Log.debug

Greetings Peda
Actions
2. Re: Can I view the generated SQL Statements by EJB-QL?

mozheyko_d Mar 23, 2003 4:49 AM (in response to romanofabian)

$(JBOSS_DIST)/server/default/conf/log4j.xml
turn all levels from ... to DEBUG
Actions

Go to original post