On Wed, Feb 10, 2010 at 8:52 AM, Andy Dale
<andy.dale@gmail.com> 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 enable org.hibernate.type on debug (I have not managed to get this working under JBoss though).
The produced output should look something like so:
2010-02-10 08:04:18,726 DEBUG [org.hibernate.SQL]
/* named HQL query MessagingSession.findMessages */ select
message0_.ID_ as col_0_0_
from
JBPM_MESSAGE message0_
where
message0_.DESTINATION_=?
and message0_.ISSUSPENDED_<>true
and (
message0_.EXCEPTION_ is null
)
Cheers,
Andy
Hi Andy, thanks for replying.
I tried logging from hibernate before i tried in postgres logging, but there the values are replaced with question marks.
I tried what you suggested (added <logger name="org.hibernate.SQL" level="debug"/> and <logger name="org.hibernate.type" level="debug"/> to logback.xml)
but there are no messages from org.hibernate.type in the log, and there are still question marks instead of values.
2010-02-10 09:44:04,228 DEBUG org.hibernate.SQL:401 - select nextval ('schema.sequence')
2010-02-10 09:44:04,231 DEBUG org.hibernate.SQL:401 - insert into schema.tabe (field1, field2, field3, ...) values (?, ?, ?, ...)
The actual values are not even logged at all. I'm looking to improve that somehow, but to no success so far.
So i was hoping that i could use postgresql logging to catch the SQL that i need..
Cheers,
WBL
--
"Patriotism is the conviction that your country is superior to all others because you were born in it." -- George Bernard Shaw