Service Builder Issues with Liferay 7

[7年前 に Stephen Hardesty によって更新されました。]

We are currenlty using Liferay 7 and are trying to access a second datasource using hibernate/Spring. We have configured the second datasource in the portal-ext.properties file on the server. We have repeatedly and exhaustively run through the steps to create an MVC portlet using service builder.
Can anyone please provide some insight into what this stack trace means?

19:59:10,089 ERROR [http-nio-8080-exec-4][render_portlet_jsp:131] null
org.hibernate.QueryException: in expected: damAsset [SELECT damAsset FROM DamAsset damAsset]
at org.hibernate.hql.classic.FromParser.token(FromParser.java:154)
at org.hibernate.hql.classic.ClauseParser.token(ClauseParser.java:109)
at org.hibernate.hql.classic.PreprocessingParser.end(PreprocessingParser.java:144)
at org.hibernate.hql.classic.ParserHelper.parse(ParserHelper.java:52)
at org.hibernate.hql.classic.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:240)
at org.hibernate.hql.classic.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:209)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:124)
at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)
at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)
at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1770)
at com.liferay.portal.dao.orm.hibernate.SessionImpl.createQuery(SessionImpl.java:87)
at com.liferay.portal.dao.orm.hibernate.SessionImpl.createQuery(SessionImpl.java:77)
at edu.cmu.sei.ewp.teamwork.service.persistence.impl.DamAssetPersistenceImpl.findAll(DamAssetPersistenceImpl.java:617)
at edu.cmu.sei.ewp.teamwork.service.persistence.impl.DamAssetPersistenceImpl.findAll(DamAssetPersistenceImpl.java:548)
at edu.cmu.sei.ewp.teamwork.service.persistence.impl.DamAssetPersistenceImpl.findAll(DamAssetPersistenceImpl.java:530)
at edu.cmu.sei.ewp.teamwork.service.base.DamAssetLocalServiceBaseImpl.getDamAssets(DamAssetLocalServiceBaseImpl.java:287)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:153)
at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:85)

[7年前 に Arnaud Charpentier によって更新されました。]

Hi Stephen,

I currently have the exact same issue.
Did you provide a solution for it ?
Thanks for you report.

Regards
Arnaud

[7年前 に David H Nebinger によって更新されました。]

There's a blog to explain how to get er done: https://web.liferay.com/web/user.26526/blog/-/blogs/liferay-7-service-builder-and-external-databases

[7年前 に Arnaud Charpentier によって更新されました。]

I was currently reading it !
Thanks for the quick answer

Regards
Arnaud