how to sovle this problem

songy · **Joined:** Mon Aug 09, 2010 1:15 am **Posts:** 2

We have develop a system based B/S,this system is developed based upon hibernte3.0 and struts1.2 framework, Now, Customer require that each user operate relate sql should loged into database,table structure is sqllog(userid,username,operatetype,sqltext,logdate),
I want to know how to implement this requirement?
thank you....

shynate26 · **Posted:** Mon Aug 09, 2010 4:04 am

Hello songy,

Assuming your project has a framework . Write a method in a Utility file, which wraps the session and calls the query. This method looks like,

public methodQuery(String s){
...save the query withtimestamp before calling or after calling the query....
}

Logging the query , only for HQL , SQL queries or even the hibernate generated queires,when it is fired when accessing a new object ?

Hope this helps.

songy · **Joined:** Mon Aug 09, 2010 1:15 am **Posts:** 2

shynate26 wrote:

Hello songy,

Assuming your project has a framework . Write a method in a Utility file, which wraps the session and calls the query. This method looks like,

public methodQuery(String s){
...save the query withtimestamp before calling or after calling the query....
}

Logging the query , only for HQL , SQL queries or even the hibernate generated queires,when it is fired when accessing a new object ?

Hope this helps.

thank you for you advise,can you tell me details??