Re: [basedb-devel] Query tracing

2009-06-08 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. This

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-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 expression HAVING restriction /Nicklas

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