6 Replies Latest reply on Oct 19, 2009 5:12 PM by luxspes

How to log the values assigned to the SQL parameters?

dzakharov Oct 16, 2009 10:59 PM

Hi,

On my jboss-logj4.xml:

   <category name="org.hibernate.type">
      <priority value="DEBUG"></priority>
   </category>

and persistence.xml:

<property name="show_sql">true</property>

and I can't get my queryparameters, on which I am interested in.

Can anyone help me understand what am I doing wrong for the hibernate not being logged?
Is it possible to see the values of a used query with Hibernate?

I use JBoss 4.2.3, Seam 2.1.2

Thanks in advance.

1. Re: How to log the values assigned to the SQL parameters?

elmarweber.seam.elmarweber.org Oct 17, 2009 1:27 AM (in response to dzakharov)

I haven't tried this, but I remember reading somewhere, that the log category changed from DEBUG to TRACE to show the values in some hibernate version.
Actions
2. Re: How to log the values assigned to the SQL parameters?

elmarweber.seam.elmarweber.org Oct 17, 2009 1:27 AM (in response to dzakharov)

Elmar Weber wrote on Oct 17, 2009 01:27:

log category changed from DEBUG to TRACE

log severity of course
Actions
3. Re: How to log the values assigned to the SQL parameters?

gardellajuan Oct 17, 2009 2:41 AM (in response to dzakharov)

Try with

1)http://www.elvyx.com/
2)P6Spy
3) http://www.google.com.ar/search?q=jdbc++logger
Actions
4. Re: How to log the values assigned to the SQL parameters?

dzakharov Oct 18, 2009 11:07 AM (in response to dzakharov)

Elvyx good tool for debugging of interaction of a Seam and DB.

Thanks.
Actions
5. Re: How to log the values assigned to the SQL parameters?

jeanluc Oct 19, 2009 5:00 PM (in response to dzakharov)
You can do it without any tool, just enable TRACE (which is finer than DEBUG) logging for Hibernate and you'll the parameters (both when reading and writing to the db).

Make sure you change the threshold as well for the appender in jboss-log4j.xml, as the default setting (<param name="Threshold" value="${jboss.server.log.threshold}"/>) doesn't include TRACE. Use:

<appender name="FILE" class="org.jboss.logging.appender.DailyRollingFileAppender"> <param name="Threshold" value="TRACE"/>
Actions
6. Re: How to log the values assigned to the SQL parameters?

luxspes Oct 19, 2009 5:12 PM (in response to dzakharov)

Jean Luc wrote on Oct 19, 2009 17:00:

You can do it without any tool, just enable TRACE (which is finer than DEBUG) logging for Hibernate and you'll the parameters (both when reading and writing to the db).

Hibernate's TRACE does the job, but in a hard to read and hard to understand format (query and values are logged separately). IMO the best tool for this job is log4jdbc
Actions

Go to original post