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 of how Expressions.string works. Then, too, apparently the SQL is a stored proc and it is shown with '?' in lieu of actual parameters, so again you don't see your string. In order to get the full scoop you need log4j.logger.net.sf.basedb.core.query.bind=debug -- O.L. ------------------------------------------------------------------------------ OpenSolaris 2009.06 is a cutting edge operating system for enterprises looking to deploy the next generation of Solaris that includes the latest innovations from Sun and the OpenSource community. Download a copy and enjoy capabilities such as Networking, Storage and Virtualization. Go to: http://p.sf.net/sfu/opensolaris-get _______________________________________________ basedb-devel mailing list basedb-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/basedb-devel