如何通过自定义插件portlet中的自定义查找器获取lifera

如何通过自定义插件portlet中的自定义查找器获取lifera

本文介绍了如何通过自定义插件portlet中的自定义查找器获取liferay实体?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我们如何使用自定义SQL通过自定义查找器来获取liferay实体?

How can we fetch liferay entities through custom-finder using custom SQL?

  1. 以下是我用default.xml():

  1. Following is my sql query written in default.xml ():

SELECT
    grp.*
FROM
    Group_
WHERE
    site = 1
    AND active_ = 1
    AND type_ <> 3

  • MyCustomGroupFinderImpl.java中的相关代码:

  • Relevant code in MyCustomGroupFinderImpl.java:

    Session session = null;
    
    try {
        session = openSession();
    
        // fetches the query string from the default.xml
        String sql = CustomSQLUtil.get(FIND_ONLY_ACTIVE_SITES);
    
        SQLQuery sqlQuery = session.createSQLQuery(sql);
    
        sqlQuery.addEntity("Group_", GroupImpl.class);
        // sqlQuery.addEntity("Group_", PortalClassLoaderUtil.getClassLoader().loadClass("com.liferay.portal.model.impl.GroupImpl"));
    
        return (List<Group>) QueryUtil.list(sqlQuery, getDialect(), 0, QueryUtil.ALL_POS);
    }
    catch (Exception e) {
        throw new SystemException(e);
    }
    finally {
        closeSession(session);
    }
    

  • 上面的代码将不起作用,因为portal-impl.jar中存在GroupImpl类,并且该jar无法在自定义portlet中使用.

    This above code won't work as the GroupImpl class is present in portal-impl.jar and this jar cannot be used in custom portlet.

    我也尝试使用sqlQuery.addEntity("Group_", PortalClassLoaderUtil.getClassLoader().loadClass("com.liferay.portal.model.impl.GroupImpl"))
    但这上面的代码引发了异常:

    I also tried using sqlQuery.addEntity("Group_", PortalClassLoaderUtil.getClassLoader().loadClass("com.liferay.portal.model.impl.GroupImpl"))
    But this above code throws exception:

    com.liferay.portal.kernel.exception.SystemException:
        com.liferay.portal.kernel.dao.orm.ORMException:
            org.hibernate.MappingException:
                Unknown entity: com.liferay.portal.model.impl.GroupImpl
    

    但是,如果我们编写sqlQuery.addEntity("MyCustomGroup", MyCustomGroupImpl.class);,则相同的代码也适用于我们的自定义实体.

    But the same code works for our custom-entity, if we write sqlQuery.addEntity("MyCustomGroup", MyCustomGroupImpl.class);.

    谢谢

    推荐答案

    我从 liferay论坛线程中获取liferay门户实体,而不是session = openSession();我们需要按照以下步骤从liferaySessionFactory获取会话以使其正常工作:

    I found out from the liferay forum thread that instead of session = openSession();we would need to fetch the session from liferaySessionFactory as follows to make it work:

    // fetch liferay's session factory
    SessionFactory sessionFactory = (SessionFactory) PortalBeanLocatorUtil.locate("liferaySessionFactory");
    
    Session session = null;
    
    try {
        // open session using liferay's session factory
        session = sessionFactory.openSession();
    
        // fetches the query string from the default.xml
        String sql = CustomSQLUtil.get(FIND_ONLY_ACTIVE_SITES);
    
        SQLQuery sqlQuery = session.createSQLQuery(sql);
    
        // use portal class loader, since this is portal entity
        sqlQuery.addEntity("Group_", PortalClassLoaderUtil.getClassLoader().loadClass("com.liferay.portal.model.impl.GroupImpl"));
    
        return (List<Group>) QueryUtil.list(sqlQuery, getDialect(), 0, QueryUtil.ALL_POS);
    }
    catch (Exception e) {
        throw new SystemException(e);
    }
    finally {
        sessionFactory.closeSession(session); // edited as per the comment on this answer
        // closeSession(session);
    }
    

    希望这对栈溢出有所帮助,我也找到了一个不错的关于自定义SQL的教程,该方法也使用相同的方法.

    Hope this helps somebody on stackoverflow, also I found a nice tutorial regarding custom-sql which also uses the same approach.

    这篇关于如何通过自定义插件portlet中的自定义查找器获取liferay实体?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

    08-14 09:46