Ask Questions and Find Answers

JournalArticleImpl is not in the portal's class loader.  With using PortalClassLoaderUtil.getClassLoader(), you are asking for the portal's class loader which will not have the JournalArticleImpl class in it.

I'm not sure what you're doing, but you may find it a bit easier to just use a dynamic query.

Hi david,

I am trying to get result from multiple table with inner join. So created custom sql for the journal article table.

<custom-sql>
    <sql id = "com.acc.bby.service.persistence.ConfigurationFinder.findJournalArticleByCategoryIds">
    SELECT * FROM journalarticle ja 
    INNER JOIN assetentry ae ON ae.classPK = ja.resourcePrimKey
    INNER JOIN assetentryassetcategoryrel ae_at ON ae.entryId = ae_at.assetEntryId
    INNER JOIN assetcategory tags ON ae_at.assetCategoryId = tags.categoryId 
    WHERE tags.categoryId IN (?) AND  ja.status = (?);
    </sql>
</custom-sql>

Attached is my FinderImpl class.

I am facing issue on adding the entity :

query.addEntity("JournalArticle", JournalArticleImpl.class));

I have tried accessing the JournalArticleImpl class using the class loader as well as the above line, but m facing the dependency issues.