nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

How to run Hibernate queries ?

greglenain

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 ?

Find more posts tagged with

Comments

greglenain

Nobody knows ?

Is Hibernate really part of the Alfresco project ?

derek

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

greglenain

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.

derek

Hi,

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

Regards