how can i get the SQL than JBoss generates to show in the log ? I'm using JBoss 4.0.3RC2 with EJB 3.0 RC3 and i have a (EQL) query that's taking ages to complete, i want to try it directly on the database in SQL to see who's the culprit (me, jboss or database)..
ive already looked at de docs and addes hbm.show.sql=true to both persistence.properties in the deploy dir as to the persistence.xml file in my ear file. that doesn't seem enough
thanks a lot in advance!