Re: [GENERAL] logging statements from hibernate to valid SQL

2010-02-10 Thread Willy-Bas Loos
On Wed, Feb 10, 2010 at 8:52 AM, Andy Dale wrote: > Hi, > > I would consider telling Hibernate to log the SQL it is generating to a > file. This can be done by setting the logging category org.hibernate.SQL to > debug, and for the parameters used in the prepared statements I think you > must also

Re: [GENERAL] logging statements from hibernate to valid SQL

2010-02-09 Thread Andy Dale
Hi, I would consider telling Hibernate to log the SQL it is generating to a file. This can be done by setting the logging category org.hibernate.SQL to debug, and for the parameters used in the prepared statements I think you must also enable org.hibernate.type on debug (I have not managed to get

[GENERAL] logging statements from hibernate to valid SQL

2010-02-09 Thread Willy-Bas Loos
Hi, I'm trying to log statements that are being fired from hibernate, so that i can benchmark them without hibernate itself. I want to fire the SQL at the database directly and see what difference i can make by tweaking things. But when i set log_statement = 'all', the logging looks like this: 20