Hibernate Community • View topic - logging sql parameters in jboss

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

logging sql parameters in jboss

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

kemikol

Post subject: logging sql parameters in jboss

Posted: Tue May 16, 2006 7:05 am

Newbie

Joined: Tue May 16, 2006 6:57 am
Posts: 1

Hello, I'm using hibernate with jboss. Hibernate logs sql like following:
select * from ....... where someId=?
and I'd like to know values of this '?', value of someId. Is it possible to set logging to log file to log this information? I tried ShowSqlEnabled to true in jboss-service.xml but it is not enough, also CommentsEnabled didn't help. Thanks

Top

r1ch

Post subject:

Posted: Tue May 16, 2006 7:36 am

Regular

Joined: Wed Aug 25, 2004 6:23 am
Posts: 91

You can enable it with a Log4j config something like this:-

Code:

<!-- Log the SQL generated by Hibernate -->
<category name="org.hibernate.SQL">
<priority value="debug">
</category>
<!-- Log the parameter substitutions in the SQL statement.  -->
<category name="org.hibernate.type">
<priority value="debug">
</category>

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum