Foren
Service Builder Issues with Liferay 7
Stephen Hardesty, geändert vor 7 Jahren.
Service Builder Issues with Liferay 7
New Member Beiträge: 14 Beitrittsdatum: 31.05.16 Neueste Beiträge
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)
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, geändert vor 7 Jahren.
RE: Service Builder Issues with Liferay 7
New Member Beiträge: 11 Beitrittsdatum: 08.04.15 Neueste Beiträge
Hi Stephen,
I currently have the exact same issue.
Did you provide a solution for it ?
Thanks for you report.
Regards
Arnaud
I currently have the exact same issue.
Did you provide a solution for it ?
Thanks for you report.
Regards
Arnaud
David H Nebinger, geändert vor 7 Jahren.
RE: Service Builder Issues with Liferay 7
Liferay Legend Beiträge: 14919 Beitrittsdatum: 02.09.06 Neueste Beiträge
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, geändert vor 7 Jahren.
RE: Service Builder Issues with Liferay 7
New Member Beiträge: 11 Beitrittsdatum: 08.04.15 Neueste Beiträge
I was currently reading it !
Thanks for the quick answer
Regards
Arnaud
Thanks for the quick answer
Regards
Arnaud