Hi all,

I am creating a web application using hibernate and struts. in that i have requirement that when i update something it has to reflect in database after specific interval of time, i need to use mysql event scheduler

My query is like this

create event.... On SCHEDULE AT CURRENT_TIMESTAMP + Some interval DO sql Query

but when i use this query in function session.createQuery(");

it gives exception : Unexpected Token Create

and when u use this query in function session.createSQLQuery("); it gives native batch update Exception

How can resolve this problem can anybody help me.

Thanks in advance.