topic Re: How to run Hibernate queries ? in Alfresco Archive

How to run Hibernate queries ?

greglenain — Sun, 12 Nov 2006 21:29:18 GMT

Hi,In order to run Hibernate queries against the repository, I'd like to get access to an Hibernate session from a foundation or JCR client (V1.4).How to do ?

Re: How to run Hibernate queries ?

greglenain — Wed, 15 Nov 2006 16:22:27 GMT

Nobody knows ?

Is Hibernate really part of the Alfresco project ?

Re: How to run Hibernate queries ?

derek — Mon, 04 Dec 2006 14:04:39 GMT


org.alfresco.repo.admin.patch.impl.InvalidNameEndingPatch
org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl
‍‍‍‍

Re: How to run Hibernate queries ?

greglenain — Wed, 06 Dec 2006 12:01:24 GMT

Do you mean some code like that ?

HibernateNodeDaoServiceImpl hibernateService = (HibernateNodeDaoServiceImpl) context.getBean("nodeDaoServiceImpl");
SessionFactory hibernateSessionFactory = hibernateService.getSessionFactory();
org.hibernate.Session hibernateSession = hibernateSessionFactory.getCurrentSession();

String query = "select_whatever_I_need_to_query";
Iterator results = hibernateSession.createQuery(query).list().iterator();
‍‍‍‍‍‍‍

It does work.

Thanks.

Re: How to run Hibernate queries ?

derek — Wed, 06 Dec 2006 12:14:38 GMT

Hi,

I had the same pattern in mind i.e. derive from HibernateDaoSupport, otherwise just inject sessionFactory bean directly.

Regards