Re: [basedb-devel] Query tracing

2009-06-08 Thread Olivier Lefevre
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

Re: [basedb-devel] Query tracing

2009-06-08 Thread Nicklas Nordborg
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 HAVING /Nicklas --

Re: [basedb-devel] Query tracing

2009-06-08 Thread Olivier Lefevre
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

Re: [basedb-devel] Query tracing

2009-06-07 Thread Nicklas Nordborg
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. T