Group_concat in a Custom query
I'm having a difficulty regarding creating a custom query in my development environment, I did the following query:
SELECT
o.codigoChamado,
o.codigoOrcamento,
group_concat(o.conteudoOrcamento separator ','),
o.observacaoOrcamento
FROM
Orcamentos as o
group by
o.codigoChamado,
o.codigoOrcamento,
o.observacaoOrcamento
order by
o.codigoOrcamento
o.codigoChamado,
o.codigoOrcamento,
group_concat(o.conteudoOrcamento separator ','),
o.observacaoOrcamento
FROM
Orcamentos as o
group by
o.codigoChamado,
o.codigoOrcamento,
o.observacaoOrcamento
order by
o.codigoOrcamento
When I execute this query in the Browse Data of the H2 console I get the desired return, however when I try to create a custom query with this command this gives the following error:
An error occurred while deploying the Business Data Model in engine
org.bonitasoft.engine.api.HTTPServerAPI.invokeMethod(HTTPServerAPI.java:143)
org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:86)
com.sun.proxy.$Proxy31.resume(Unknown Source)
org.bonitasoft.studio.businessobject.core.operation.DeployBDMOperation.doDeployBDM(DeployBDMOperation.java:138)
org.bonitasoft.studio.businessobject.core.operation.DeployBDMOperation.run(DeployBDMOperation.java:88)
org.bonitasoft.studio.businessobject.ui.wizard.ManageBusinessDataModelWizard$2.run(ManageBusinessDataModelWizard.java:188)
org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122)
< ========== Beginning of the server stack trace ========== >. ( )
org.bonitasoft.engine.api.impl.TenantAdministrationAPIImpl.handleResult(TenantAdministrationAPIImpl.java:200)
org.bonitasoft.engine.api.impl.TenantAdministrationAPIImpl.setTenantClassloaderAndUpdateStateOfTenantServicesWithLifecycle(TenantAdministrationAPIImpl.java:184)
org.bonitasoft.engine.api.impl.TenantAdministrationAPIImpl.resumeServicesForTenant(TenantAdministrationAPIImpl.java:165)
org.bonitasoft.engine.api.impl.TenantAdministrationAPIImpl.setTenantPaused(TenantAdministrationAPIImpl.java:128)
org.bonitasoft.engine.api.impl.TenantAdministrationAPIImpl.resume(TenantAdministrationAPIImpl.java:100)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:498)
org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:462)
org.bonitasoft.engine.api.impl.ServerAPIImpl$2.call(ServerAPIImpl.java:431)
org.bonitasoft.engine.transaction.JTATransactionServiceImpl.executeInTransaction(JTATransactionServiceImpl.java:274)
org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPIInTransaction(ServerAPIImpl.java:438)
org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:272)
org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:124)
org.bonitasoft.engine.api.internal.servlet.HttpAPIServletCall.doPost(HttpAPIServletCall.java:112)
org.bonitasoft.engine.api.internal.servlet.HttpAPIServlet.doPost(HttpAPIServlet.java:35)
javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)
org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)
org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)
org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:394)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1087)
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
java.lang.Thread.run(Thread.java:745)
Caused by: javax.persistence.PersistenceException.: Unable to build entity manager factory ( )
org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:83)
org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:54)
javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:55)
org.bonitasoft.engine.business.data.impl.JPABusinessDataRepositoryImpl.createEntityManagerFactory(JPABusinessDataRepositoryImpl.java:97)
org.bonitasoft.engine.business.data.impl.JPABusinessDataRepositoryImpl.start(JPABusinessDataRepositoryImpl.java:91)
org.bonitasoft.engine.business.data.impl.JPABusinessDataRepositoryImpl.resume(JPABusinessDataRepositoryImpl.java:146)
org.bonitasoft.engine.api.impl.transaction.ResumeServiceStrategy.changeState(ResumeServiceStrategy.java:33)
org.bonitasoft.engine.api.impl.transaction.SetServiceState.call(SetServiceState.java:79)
org.bonitasoft.engine.api.impl.transaction.SetServiceState.call(SetServiceState.java:40)
org.bonitasoft.engine.service.impl.BroadcastServiceLocal.executeOnAllNodes(BroadcastServiceLocal.java:65)
org.bonitasoft.engine.api.impl.TenantAdministrationAPIImpl.setTenantClassloaderAndUpdateStateOfTenantServicesWithLifecycle(TenantAdministrationAPIImpl.java:183)
... 42 more. ( )
Caused by: java.lang.NullPointerException.: null ( )
org.hibernate.hql.internal.antlr.HqlBaseParser.identPrimary(HqlBaseParser.java:4285)
org.hibernate.hql.internal.antlr.HqlBaseParser.primaryExpression(HqlBaseParser.java:980)
org.hibernate.hql.internal.antlr.HqlBaseParser.atom(HqlBaseParser.java:3609)
org.hibernate.hql.internal.antlr.HqlBaseParser.unaryExpression(HqlBaseParser.java:3387)
org.hibernate.hql.internal.antlr.HqlBaseParser.multiplyExpression(HqlBaseParser.java:3259)
org.hibernate.hql.internal.antlr.HqlBaseParser.additiveExpression(HqlBaseParser.java:2964)
org.hibernate.hql.internal.antlr.HqlBaseParser.concatenation(HqlBaseParser.java:597)
org.hibernate.hql.internal.antlr.HqlBaseParser.relationalExpression(HqlBaseParser.java:2730)
org.hibernate.hql.internal.antlr.HqlBaseParser.equalityExpression(HqlBaseParser.java:2591)
org.hibernate.hql.internal.antlr.HqlBaseParser.negatedExpression(HqlBaseParser.java:2555)
org.hibernate.hql.internal.antlr.HqlBaseParser.logicalAndExpression(HqlBaseParser.java:2471)
org.hibernate.hql.internal.antlr.HqlBaseParser.logicalOrExpression(HqlBaseParser.java:2436)
org.hibernate.hql.internal.antlr.HqlBaseParser.expression(HqlBaseParser.java:2146)
org.hibernate.hql.internal.antlr.HqlBaseParser.aliasedExpression(HqlBaseParser.java:2389)
org.hibernate.hql.internal.antlr.HqlBaseParser.selectedPropertiesList(HqlBaseParser.java:1422)
org.hibernate.hql.internal.antlr.HqlBaseParser.selectClause(HqlBaseParser.java:1325)
org.hibernate.hql.internal.antlr.HqlBaseParser.selectFrom(HqlBaseParser.java:1062)
org.hibernate.hql.internal.antlr.HqlBaseParser.queryRule(HqlBaseParser.java:731)
org.hibernate.hql.internal.antlr.HqlBaseParser.selectStatement(HqlBaseParser.java:323)
org.hibernate.hql.internal.antlr.HqlBaseParser.statement(HqlBaseParser.java:186)
org.hibernate.hql.internal.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:295)
org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:203)
org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:158)
org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:131)
org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:93)
org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:167)
org.hibernate.internal.NamedQueryRepository.checkNamedQueries(NamedQueryRepository.java:161)
org.hibernate.internal.SessionFactoryImpl.checkNamedQueries(SessionFactoryImpl.java:1090)
org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:536)
org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1859)
org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl$4.perform(EntityManagerFactoryBuilderImpl.java:857)
org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl$4.perform(EntityManagerFactoryBuilderImpl.java:850)
org.hibernate.boot.registry.classloading.internal.ClassLoaderServiceImpl.withTccl(ClassLoaderServiceImpl.java:425)
org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:849)
org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:75)
... 52 more. ( )
org.bonitasoft.engine.api.HTTPServerAPI.invokeMethod(HTTPServerAPI.java:143)
org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:86)
com.sun.proxy.$Proxy31.resume(Unknown Source)
org.bonitasoft.studio.businessobject.core.operation.DeployBDMOperation.doDeployBDM(DeployBDMOperation.java:138)
org.bonitasoft.studio.businessobject.core.operation.DeployBDMOperation.run(DeployBDMOperation.java:88)
org.bonitasoft.studio.businessobject.ui.wizard.ManageBusinessDataModelWizard$2.run(ManageBusinessDataModelWizard.java:188)
org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122)
< ========== Beginning of the server stack trace ========== >. ( )
org.bonitasoft.engine.api.impl.TenantAdministrationAPIImpl.handleResult(TenantAdministrationAPIImpl.java:200)
org.bonitasoft.engine.api.impl.TenantAdministrationAPIImpl.setTenantClassloaderAndUpdateStateOfTenantServicesWithLifecycle(TenantAdministrationAPIImpl.java:184)
org.bonitasoft.engine.api.impl.TenantAdministrationAPIImpl.resumeServicesForTenant(TenantAdministrationAPIImpl.java:165)
org.bonitasoft.engine.api.impl.TenantAdministrationAPIImpl.setTenantPaused(TenantAdministrationAPIImpl.java:128)
org.bonitasoft.engine.api.impl.TenantAdministrationAPIImpl.resume(TenantAdministrationAPIImpl.java:100)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:498)
org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:462)
org.bonitasoft.engine.api.impl.ServerAPIImpl$2.call(ServerAPIImpl.java:431)
org.bonitasoft.engine.transaction.JTATransactionServiceImpl.executeInTransaction(JTATransactionServiceImpl.java:274)
org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPIInTransaction(ServerAPIImpl.java:438)
org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:272)
org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:124)
org.bonitasoft.engine.api.internal.servlet.HttpAPIServletCall.doPost(HttpAPIServletCall.java:112)
org.bonitasoft.engine.api.internal.servlet.HttpAPIServlet.doPost(HttpAPIServlet.java:35)
javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)
org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)
org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)
org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:394)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1087)
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
java.lang.Thread.run(Thread.java:745)
Caused by: javax.persistence.PersistenceException.: Unable to build entity manager factory ( )
org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:83)
org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:54)
javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:55)
org.bonitasoft.engine.business.data.impl.JPABusinessDataRepositoryImpl.createEntityManagerFactory(JPABusinessDataRepositoryImpl.java:97)
org.bonitasoft.engine.business.data.impl.JPABusinessDataRepositoryImpl.start(JPABusinessDataRepositoryImpl.java:91)
org.bonitasoft.engine.business.data.impl.JPABusinessDataRepositoryImpl.resume(JPABusinessDataRepositoryImpl.java:146)
org.bonitasoft.engine.api.impl.transaction.ResumeServiceStrategy.changeState(ResumeServiceStrategy.java:33)
org.bonitasoft.engine.api.impl.transaction.SetServiceState.call(SetServiceState.java:79)
org.bonitasoft.engine.api.impl.transaction.SetServiceState.call(SetServiceState.java:40)
org.bonitasoft.engine.service.impl.BroadcastServiceLocal.executeOnAllNodes(BroadcastServiceLocal.java:65)
org.bonitasoft.engine.api.impl.TenantAdministrationAPIImpl.setTenantClassloaderAndUpdateStateOfTenantServicesWithLifecycle(TenantAdministrationAPIImpl.java:183)
... 42 more. ( )
Caused by: java.lang.NullPointerException.: null ( )
org.hibernate.hql.internal.antlr.HqlBaseParser.identPrimary(HqlBaseParser.java:4285)
org.hibernate.hql.internal.antlr.HqlBaseParser.primaryExpression(HqlBaseParser.java:980)
org.hibernate.hql.internal.antlr.HqlBaseParser.atom(HqlBaseParser.java:3609)
org.hibernate.hql.internal.antlr.HqlBaseParser.unaryExpression(HqlBaseParser.java:3387)
org.hibernate.hql.internal.antlr.HqlBaseParser.multiplyExpression(HqlBaseParser.java:3259)
org.hibernate.hql.internal.antlr.HqlBaseParser.additiveExpression(HqlBaseParser.java:2964)
org.hibernate.hql.internal.antlr.HqlBaseParser.concatenation(HqlBaseParser.java:597)
org.hibernate.hql.internal.antlr.HqlBaseParser.relationalExpression(HqlBaseParser.java:2730)
org.hibernate.hql.internal.antlr.HqlBaseParser.equalityExpression(HqlBaseParser.java:2591)
org.hibernate.hql.internal.antlr.HqlBaseParser.negatedExpression(HqlBaseParser.java:2555)
org.hibernate.hql.internal.antlr.HqlBaseParser.logicalAndExpression(HqlBaseParser.java:2471)
org.hibernate.hql.internal.antlr.HqlBaseParser.logicalOrExpression(HqlBaseParser.java:2436)
org.hibernate.hql.internal.antlr.HqlBaseParser.expression(HqlBaseParser.java:2146)
org.hibernate.hql.internal.antlr.HqlBaseParser.aliasedExpression(HqlBaseParser.java:2389)
org.hibernate.hql.internal.antlr.HqlBaseParser.selectedPropertiesList(HqlBaseParser.java:1422)
org.hibernate.hql.internal.antlr.HqlBaseParser.selectClause(HqlBaseParser.java:1325)
org.hibernate.hql.internal.antlr.HqlBaseParser.selectFrom(HqlBaseParser.java:1062)
org.hibernate.hql.internal.antlr.HqlBaseParser.queryRule(HqlBaseParser.java:731)
org.hibernate.hql.internal.antlr.HqlBaseParser.selectStatement(HqlBaseParser.java:323)
org.hibernate.hql.internal.antlr.HqlBaseParser.statement(HqlBaseParser.java:186)
org.hibernate.hql.internal.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:295)
org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:203)
org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:158)
org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:131)
org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:93)
org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:167)
org.hibernate.internal.NamedQueryRepository.checkNamedQueries(NamedQueryRepository.java:161)
org.hibernate.internal.SessionFactoryImpl.checkNamedQueries(SessionFactoryImpl.java:1090)
org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:536)
org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1859)
org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl$4.perform(EntityManagerFactoryBuilderImpl.java:857)
org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl$4.perform(EntityManagerFactoryBuilderImpl.java:850)
org.hibernate.boot.registry.classloading.internal.ClassLoaderServiceImpl.withTccl(ClassLoaderServiceImpl.java:425)
org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:849)
org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:75)
... 52 more. ( )
Has this ever happened to you? Is there any way to resolve this?
My goal is simply to group the field conteudoOrcamento
Thank you so much for everything
No answers yet.