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.