Service Builder Issues with Liferay 7

[Stephen Hardesty, modificado hace 7 años.]

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)

[Arnaud Charpentier, modificado hace 7 años.]

Hi Stephen,

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

Regards
Arnaud

[David H Nebinger, modificado hace 7 años.]

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

[Arnaud Charpentier, modificado hace 7 años.]

I was currently reading it !
Thanks for the quick answer

Regards
Arnaud