javax.persistence.PersistenceException: Query threw SQLException:ERROR: missing FROM-clause entry for table "c" Position: 62 Query was: select count(*) from order t0 where CAST(ARRAY[c.id] AS UUID[]) <@ (select some_array FROM another_table WHERE param = ?)

Google Groups | Gustavo Bilert | 8 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    propertyRaw

    Google Groups | 8 months ago | Gustavo Bilert
    javax.persistence.PersistenceException: Query threw SQLException:ERROR: missing FROM-clause entry for table "c" Position: 62 Query was: select count(*) from order t0 where CAST(ARRAY[c.id] AS UUID[]) <@ (select some_array FROM another_table WHERE param = ?)
  2. 0

    Hibernate dependency conflicts with JBoss

    apache.org | 2 years ago
    javax.persistence.PersistenceException: [PersistenceUnit: RollerPU] Unable to build EntityManagerFactory at org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1.run(PersistenceUnitServiceImpl.java:103) [jboss-as-jpa-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146) [rt.jar:1.6.0_27] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.6.0_27]
  3. 0

    dev-roller.apache.org - Re: Hibernate dependency conflicts with JBoss - msg#00019 - Recent Discussion OSDir.com

    osdir.com | 1 year ago
    javax.persistence.PersistenceException: [PersistenceUnit: RollerPU] Unable to build EntityManagerFactory at org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1.run(PersistenceUnitServiceImpl.java:103) [jboss-as-jpa-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146) [rt.jar:1.6.0_27] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.6.0_27]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Re: Hibernate dependency conflicts with JBoss

    apache.org | 2 years ago
    javax.persistence.PersistenceException: [PersistenceUnit: RollerPU] Unable to build EntityManagerFactory at org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1.run(PersistenceUnitServiceImpl.java:103) [jboss-as-jpa-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146) [rt.jar:1.6.0_27] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.6.0_27]

    Root Cause Analysis

    1. javax.persistence.PersistenceException

      Query threw SQLException:ERROR: missing FROM-clause entry for table "c" Position: 62 Query was: select count(*) from order t0 where CAST(ARRAY[c.id] AS UUID[]) <@ (select some_array FROM another_table WHERE param = ?)

      at com.avaje.ebeaninternal.server.query.CQuery.createPersistenceException()
    2. avaje-ebeanorm
      LimitOffsetPagedList.getTotalCount
      1. com.avaje.ebeaninternal.server.query.CQuery.createPersistenceException(CQuery.java:670)
      2. com.avaje.ebeaninternal.server.query.CQueryEngine.findRowCount(CQueryEngine.java:158)
      3. com.avaje.ebeaninternal.server.query.DefaultOrmQueryEngine.findRowCount(DefaultOrmQueryEngine.java:64)
      4. com.avaje.ebeaninternal.server.core.OrmQueryRequest.findRowCount(OrmQueryRequest.java:304)
      5. com.avaje.ebeaninternal.server.core.DefaultServer.findRowCountWithCopy(DefaultServer.java:1186)
      6. com.avaje.ebeaninternal.server.core.DefaultServer.findCount(DefaultServer.java:1174)
      7. com.avaje.ebeaninternal.server.query.LimitOffsetPagedList.getTotalCount(LimitOffsetPagedList.java:100)
      7 frames
    3. com.mycompany.commons
      AbstractDAO.getPagedList
      1. com.mycompany.commons.persistence.AbstractDAO.getPagedList(AbstractDAO.java:393)
      1 frame
    4. com.mycompany.archetype
      OrderDAO$Proxy$_$$_WeldClientProxy.list
      1. com.mycompany.archetype.order.OrderDAO.list(OrderDAO.java:133)
      2. com.mycompany.archetype.order.OrderDAO$Proxy$_$$_WeldClientProxy.list(Unknown Source)
      2 frames
    5. com.mycompany.commons
      AbstractResource.list
      1. com.mycompany.commons.server.AbstractService.list(AbstractService.java:77)
      2. com.mycompany.commons.server.AbstractResource.list(AbstractResource.java:129)
      2 frames
    6. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:498)
      4 frames
    7. jersey-core-server
      ServerRuntime$2.run
      1. org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
      2. org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144)
      3. org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161)
      4. org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$ResponseOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:160)
      5. org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99)
      6. org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389)
      7. org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347)
      8. org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)
      9. org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326)
      9 frames
    8. Jersey Core
      RequestScope.runInScope
      1. org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
      2. org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
      3. org.glassfish.jersey.internal.Errors.process(Errors.java:315)
      4. org.glassfish.jersey.internal.Errors.process(Errors.java:297)
      5. org.glassfish.jersey.internal.Errors.process(Errors.java:267)
      6. org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317)
      6 frames
    9. jersey-core-server
      ApplicationHandler.handle
      1. org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305)
      2. org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154)
      2 frames
    10. jersey-container-servlet-core
      ServletContainer.service
      1. org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:471)
      2. org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:425)
      3. org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:383)
      4. org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:336)
      5. org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:223)
      5 frames
    11. Jetty
      ServletHandler$CachedChain.doFilter
      1. org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:835)
      2. org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1685)
      2 frames
    12. Shiro
      OncePerRequestFilter.doFilter
      1. org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)
      2. org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)
      3. org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
      4. org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
      5. org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383)
      6. org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)
      7. org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
      7 frames
    13. Jetty
      SelectChannelEndPoint$2.run
      1. org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1668)
      2. org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:581)
      3. org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
      4. org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)
      5. org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:226)
      6. org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1158)
      7. org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:511)
      8. org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
      9. org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1090)
      10. org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
      11. org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:109)
      12. org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:119)
      13. org.eclipse.jetty.server.Server.handle(Server.java:517)
      14. org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:308)
      15. org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:242)
      16. org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:273)
      17. org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:95)
      18. org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:75)
      18 frames
    14. org.eclipse.jetty
      ExecuteProduceConsume.run
      1. org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceAndRun(ExecuteProduceConsume.java:213)
      2. org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:147)
      2 frames
    15. Jetty
      QueuedThreadPool$3.run
      1. org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:654)
      2. org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:572)
      2 frames
    16. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:745)
      1 frame