logging sql per session

funky · **Joined:** Sat Nov 13, 2004 7:21 pm **Posts:** 24

Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 2.1

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using: SQL Server

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

Hi

Is there a way to log sql executed with a specified session, or at least to get last 20 executed sql statements with a session before close it?

tanks,

kochcp · **Posted:** Mon Jul 24, 2006 3:26 pm

configure log4j to debug

in your hibernate config file, set

Code:

hibernate.show_sql = true

funky · **Joined:** Sat Nov 13, 2004 7:21 pm **Posts:** 24

I know:

Code:

hibernate.show_sql = true

shows all sql statements, what I need is to see which sql is executet on which session.

funky · **Joined:** Sat Nov 13, 2004 7:21 pm **Posts:** 24

What about this?
org.hibernate.pretty Log the state of all entities (max 20 entities) associated with the session at flush time
can this help me? how I use it?