Hibernate Community • View topic - Show the insert/update/delete sql on log?

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Show the insert/update/delete sql on log?

Page 1 of 1

[ 4 posts ]

Previous topic | Next topic

Author

Message

mullin

Post subject: Show the insert/update/delete sql on log?

Posted: Sun Jul 29, 2007 9:38 pm

Newbie

Joined: Wed Jan 31, 2007 9:55 pm
Posts: 16

I just wonder is it possible to show only the insert/update/delete (not select) sql statements with values on log file?

I'm just interested in those statements for error tracing or rebuilding the database.

Thanks!

Top

pierre-henry

Post subject: SQL SPy

Posted: Mon Jul 30, 2007 3:17 am

Beginner

Joined: Wed Oct 25, 2006 9:05 am
Posts: 40
Location: France, Lieusaint

Hi,

Have you try SPY sql driver which wrapps your sql requests and allows you to configure a spy ?

Top

mullin

Post subject:

Posted: Mon Jul 30, 2007 5:36 am

Newbie

Joined: Wed Jan 31, 2007 9:55 pm
Posts: 16

can HibernateInception can do so if I'm using spring 2 + hibernate 3?

thanks!

Top

pierre-henry

Post subject:

Posted: Mon Jul 30, 2007 6:18 am

Beginner

Joined: Wed Oct 25, 2006 9:05 am
Posts: 40
Location: France, Lieusaint

Mullin,

You mean HibernateInterception ? sure you could...

But this is direct: just put

Code:

jdbc.driverClassName = com.p6spy.engine.spy.P6SpyDriver

in your environment.properties file, and run you app!

you then will have a SPY.LOG file where you model sits.

Top

Page 1 of 1

[ 4 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