public void jdbcInsert(final String sql) {
getHibernateTemplate().execute(new HibernateCallback(){
public Object doInHibernate(Session session) throws HibernateException, SQLException
{
session=getSessionFactory().openSession();
Transaction tran=session.beginTransaction();
Query query= session.createSQLQuery(sql);
query.executeUpdate();
session.getTransaction().commit();
session.close();
return null;
}
});
}