mysql - Hibernate delete query is not working? -

i use following code delete record table. able insert data table. delete operation not work.

 @override     public int deletebutterflycountdata(int recordid) {         session session = this.sessionfactory.opensession();         session.begintransaction();         string query = "delete butterflycountdata record_id="+recordid+"";         query q = session.createquery(query);         int result = q.executeupdate();         session.close();         return result;     } 

result returns 1 data table record not deleted. issue in here?

you have commit transaction:

transaction transaction = session.begintransaction(); ... transaction.commit(); session.close();