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 | 2 months ago
  1. 0

    propertyRaw

    Google Groups | 2 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

    Play 2.4 Deployment error Table not found

    Stack Overflow | 8 months ago | nbz
    javax.persistence.PersistenceException: Query threw SQLException:Table "CLIENT" not found; SQL statement: select count(*) from client t0 [42102-187] Bind values:[null] Query was: select count(*) from client t0
  3. 0

    SqlQuery with named parameter and limit/offset gives SQL exception

    GitHub | 5 months ago | rbygrave
    javax.persistence.PersistenceException: Query threw SQLException:Syntax error in SQL statement "SELECT * FROM O_ORDER WHERE O_ORDER.ID > :[*]ID ORDER BY ID LIMIT 10 "; expected "ALL, ANY, SOME, SELECT, FROM"; SQL statement: select * from o_order where o_order.id > :id order by id limit 10 [42001-189] Query was: select * from o_order where o_order.id > :id order by id limit 10
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Should not generate "FOR UPDATE" for delete query

    GitHub | 1 year ago | wjtan
    javax.persistence.PersistenceException: Query threw SQLException:Syntax error in SQL statement "DELETE FROM CEMETERY T0 WHERE T0.CEMETRY_PORTAL = ? FOR[*] UPDATE "; SQL statement: delete from cemetery t0 where t0.cemetry_portal = ? for update [42000-187] Bind values:[null] Query was: delete from cemetery t0 where t0.cemetry_portal = ? for update , took 0.006 sec
  6. 0

    MS SQL Server - javax.persistence.PersistenceException: Query threw SQLException:Incorrect syntax near the keyword distinct

    GitHub | 1 year ago | rbygrave
    javax.persistence.PersistenceException: Query threw SQLException:Incorrect syntax near the keyword &apos;distinct&apos;. Bind values:[0] Query was: select top 3 distinct t0.id c0, t0.status c1, t0.order_date c2, t0.ship_date c3, t1.name c4, t0.cretime c5, t0.updtime c6, t0.kcustomer_id c7 from o_order t0 join o_customer t1 on t1.id = t0.kcustomer_id join o_order_detail u1 on u1.order_id = t0.id where u1.id &gt; ?

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    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