Olivier Lefevre wrote:
I am developing a service. How can I enable query tracing so that
Query.list() appends the SQL or HQL form of the query to one of the
Tomcat log files? My 'or' queries (Restrictions.or) seem to work
ok but not my 'and' queries and I'd like to see what's going on.
This
Thanks. By the way, why were WHERE SQL clauses mapped to the
unintuitive Restriction rather than Where, like ORDER was
mapped to Order?
-- O.L.
--
OpenSolaris 2009.06 is a cutting edge operating system for enterprises
Olivier Lefevre wrote:
Thanks. By the way, why were WHERE SQL clauses mapped to the
unintuitive Restriction rather than Where, like ORDER was
mapped to Order?
Restrictions can appear in other places also. For example in
queries with GROUP BY expression HAVING restriction
/Nicklas
OK, so I enabled that and it did not show me all I wanted at
first. In case someone should hit this thread using the search
function in the future, I think I'd finish the story.
If a WHERE clauses involves a constant string, the HQL log will
shows some kind of hash instead of the string because