Event execute = (Event) hibernateTemplate.execute(new HibernateCallback() {

            @Override
            public Event doInHibernate(Session session) {

                Event result = null;


                Criteria criteria = session.createCriteria(Event.class);
                criteria.setProjection(Projections.rowCount());
                int count = ((Number) criteria.uniqueResult()).intValue();

                if (0 != count) {
                    int index = new Random().nextInt(count);
                    criteria = session.createCriteria(Event.class);

                    result = (Event) criteria.setFetchMode("city", FetchMode.JOIN).setFirstResult(index).setMaxResults(1).uniqueResult();
                }


                return result;
            }
        });



        return execute;