0 Replies Latest reply on Jul 15, 2005 1:38 AM by chaloupka

    How to display real SQL query generated by JBoss

    chaloupka

      Hallo,
      I am solving performance problem with database queries. In JBoss, I have dynamic SQL as e.g.
      SELECT OBJECT(o) FROM organizations as o , in (o.persons) as p where o.masterOrg is null and p.name = 'John'

      Of course, I know how to display it in this form, but I'd like to see it in form which is sent to database, for prepare materialized views, tune indexes etc.

      How to configure log4j.xml to display it? I found nothing usual in Admin Devel doc, but maybe I looked for bad keywords ...

      Thanks, Jiri