org.hibernate.exception.SQLGrammarException: could not extract ResultSet

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

    REST/query with 6.3.0.Final throws SQLGrammarException

    Google Groups | 2 years ago | Imro
    org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  2. 0

    Aplicação Web Completa JSF EJB JPA JAAS | uaiHebert (: | Page 7

    uaihebert.com | 8 months ago
    javax.security.auth.login.LoginException: Query failed
  3. 0

    my Quartz doesn't resume processing jobs after connections to db are restored

    terracotta.org | 1 year ago
    org.postgresql.util.PSQLException: This connection has been closed.]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Geovise BVBA

    hibernatespatial.org | 1 year ago
    javax.servlet.ServletException: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not extract ResultSet
  6. 0

    Geovise BVBA

    hibernatespatial.org | 1 year ago
    javax.servlet.ServletException: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not extract ResultSet
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. org.postgresql.util.PSQLException

    ERROR: missing FROM-clause entry for table "organizati2_" Position: 741

    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse()
  2. PostgreSQL JDBC Driver
    AbstractJdbc2Statement.executeQuery
    1. org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2182)
    2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1911)
    3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:173)
    4. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:615)
    5. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:465)
    6. org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:350)
    6 frames
  3. IronJacamar
    WrappedPreparedStatement.executeQuery
    1. org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)
    1 frame
  4. Hibernate
    QueryImpl.list
    1. org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:80)[hibernate-core-4.3.5.Final.jar:4.3.5.Final]
    2. org.hibernate.loader.Loader.getResultSet(Loader.java:2065)[hibernate-core-4.3.5.Final.jar:4.3.5.Final]
    3. org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1862)[hibernate-core-4.3.5.Final.jar:4.3.5.Final]
    4. org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1838)[hibernate-core-4.3.5.Final.jar:4.3.5.Final]
    5. org.hibernate.loader.Loader.doQuery(Loader.java:909)[hibernate-core-4.3.5.Final.jar:4.3.5.Final]
    6. org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:354)[hibernate-core-4.3.5.Final.jar:4.3.5.Final]
    7. org.hibernate.loader.Loader.doList(Loader.java:2553)[hibernate-core-4.3.5.Final.jar:4.3.5.Final]
    8. org.hibernate.loader.Loader.doList(Loader.java:2539)[hibernate-core-4.3.5.Final.jar:4.3.5.Final]
    9. org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2369)[hibernate-core-4.3.5.Final.jar:4.3.5.Final]
    10. org.hibernate.loader.Loader.list(Loader.java:2364)[hibernate-core-4.3.5.Final.jar:4.3.5.Final]
    11. org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:496)[hibernate-core-4.3.5.Final.jar:4.3.5.Final]
    12. org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:387)[hibernate-core-4.3.5.Final.jar:4.3.5.Final]
    13. org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:231)[hibernate-core-4.3.5.Final.jar:4.3.5.Final]
    14. org.hibernate.internal.SessionImpl.list(SessionImpl.java:1264)[hibernate-core-4.3.5.Final.jar:4.3.5.Final]
    15. org.hibernate.internal.QueryImpl.list(QueryImpl.java:103)[hibernate-core-4.3.5.Final.jar:4.3.5.Final]
    15 frames
  5. org.hibernate.jpa
    CriteriaQueryTypeQueryAdapter.getResultList
    1. org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:573)[hibernate-entitymanager-4.3.5.Final.jar:4.3.5.Final]
    2. org.hibernate.jpa.internal.QueryImpl.getResultList(QueryImpl.java:449)[hibernate-entitymanager-4.3.5.Final.jar:4.3.5.Final]
    3. org.hibernate.jpa.criteria.compile.CriteriaQueryTypeQueryAdapter.getResultList(CriteriaQueryTypeQueryAdapter.java:67)[hibernate-entitymanager-4.3.5.Final.jar:4.3.5.Final]
    3 frames
  6. KIE
    RemoteServicesTaskQueryCriteriaUtil.createQueryAndCallApplyMetaCriteriaAndGetResult
    1. org.kie.remote.services.rest.query.RemoteServicesCriteriaUtil.sharedCreateQueryAndCallApplyMetaCriteriaAndGetResult(RemoteServicesCriteriaUtil.java:273)[kie-remote-services-6.3.0.Final.jar:6.3.0.Final]
    2. org.kie.remote.services.rest.query.RemoteServicesTaskQueryCriteriaUtil.createQueryAndCallApplyMetaCriteriaAndGetResult(RemoteServicesTaskQueryCriteriaUtil.java:115)[kie-remote-services-6.3.0.Final.jar:6.3.0.Final]
    2 frames
  7. jBPM :: JPA Human Task Persistence
    TaskQueryCriteriaUtil.doCriteriaQuery
    1. org.jbpm.services.task.persistence.TaskQueryCriteriaUtil.doCriteriaQuery(TaskQueryCriteriaUtil.java:222)[jbpm-human-task-jpa-6.3.0.Final.jar:6.3.0.Final]
    1 frame
  8. KIE
    RemoteServicesQueryJPAService.doTaskSummaryQuery
    1. org.kie.remote.services.rest.query.RemoteServicesQueryJPAService.doTaskSummaryQuery(RemoteServicesQueryJPAService.java:65)[kie-remote-services-6.3.0.Final.jar:6.3.0.Final]
    1 frame
  9. org.kie.remote
    AbstractInternalQueryHelper.queryTaskOrProcInstAndAssociatedVariables
    1. org.kie.remote.services.rest.query.helpers.InternalTaskQueryHelper.doQueryAndCreateResultObjects(InternalTaskQueryHelper.java:129)[kie-remote-services-6.3.0.Final.jar:6.3.0.Final]
    2. org.kie.remote.services.rest.query.helpers.InternalTaskQueryHelper.doQueryAndCreateResultObjects(InternalTaskQueryHelper.java:48)[kie-remote-services-6.3.0.Final.jar:6.3.0.Final]
    3. org.kie.remote.services.rest.query.helpers.AbstractInternalQueryHelper.queryTaskOrProcInstAndAssociatedVariables(AbstractInternalQueryHelper.java:159)[kie-remote-services-6.3.0.Final.jar:6.3.0.Final]
    3 frames
  10. KIE
    QueryResourceImpl$Proxy$_$$_WeldClientProxy.queryTasks
    1. org.kie.remote.services.rest.QueryResourceImpl.queryTasks(QueryResourceImpl.java:88)[kie-remote-services-6.3.0.Final.jar:6.3.0.Final]
    2. org.kie.remote.services.rest.QueryResourceImpl$Proxy$_$$_WeldClientProxy.queryTasks(Unknown Source)[kie-remote-services-6.3.0.Final.jar:6.3.0.Final]
    2 frames
  11. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[rt.jar:1.8.0_60]
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)[rt.jar:1.8.0_60]
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[rt.jar:1.8.0_60]
    4. java.lang.reflect.Method.invoke(Method.java:497)[rt.jar:1.8.0_60]
    4 frames
  12. RESTEasy JAX-RS Implementation
    HttpServletDispatcher.service
    1. org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:137)[resteasy-jaxrs-3.0.8.Final.jar:]
    2. org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMethodInvoker.java:296)[resteasy-jaxrs-3.0.8.Final.jar:]
    3. org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:250)[resteasy-jaxrs-3.0.8.Final.jar:]
    4. org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:237)[resteasy-jaxrs-3.0.8.Final.jar:]
    5. org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:356)[resteasy-jaxrs-3.0.8.Final.jar:]
    6. org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:179)[resteasy-jaxrs-3.0.8.Final.jar:]
    7. org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:220)[resteasy-jaxrs-3.0.8.Final.jar:]
    8. org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)[resteasy-jaxrs-3.0.8.Final.jar:]
    9. org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51)[resteasy-jaxrs-3.0.8.Final.jar:]
    9 frames
  13. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:790)[jboss-servlet-api_3.1_spec-1.0.0.Final.jar:1.0.0.Final]
    1 frame
  14. Undertow Servlet
    FilterHandler$FilterChainImpl.doFilter
    1. io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:85)[undertow-servlet-1.0.15.Final.jar:1.0.15.Final]
    2. io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:130)[undertow-servlet-1.0.15.Final.jar:1.0.15.Final]
    2 frames
  15. KIE
    DynamicJaxbContextFilter.doFilter
    1. org.kie.remote.services.rest.jaxb.DynamicJaxbContextFilter.doFilter(DynamicJaxbContextFilter.java:63)[kie-remote-services-6.3.0.Final.jar:6.3.0.Final]
    1 frame
  16. Undertow Servlet
    FilterHandler$FilterChainImpl.doFilter
    1. io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60)[undertow-servlet-1.0.15.Final.jar:1.0.15.Final]
    2. io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132)[undertow-servlet-1.0.15.Final.jar:1.0.15.Final]
    2 frames
  17. org.uberfire.ext
    BasicAuthSecurityFilter.doFilter
    1. org.uberfire.ext.security.server.BasicAuthSecurityFilter.doFilter(BasicAuthSecurityFilter.java:61)[uberfire-servlet-security-0.7.3.Final.jar:0.7.3.Final]
    1 frame
  18. Undertow Servlet
    FilterHandler$FilterChainImpl.doFilter
    1. io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60)[undertow-servlet-1.0.15.Final.jar:1.0.15.Final]
    2. io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132)[undertow-servlet-1.0.15.Final.jar:1.0.15.Final]
    2 frames
  19. org.uberfire.ext
    SecureHeadersFilter.doFilter
    1. org.uberfire.ext.security.server.SecureHeadersFilter.doFilter(SecureHeadersFilter.java:53)[uberfire-servlet-security-0.7.3.Final.jar:0.7.3.Final]
    1 frame
  20. Undertow Servlet
    FilterHandler$FilterChainImpl.doFilter
    1. io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60)[undertow-servlet-1.0.15.Final.jar:1.0.15.Final]
    2. io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132)[undertow-servlet-1.0.15.Final.jar:1.0.15.Final]
    2 frames
  21. org.uberfire.ext
    SecurityIntegrationFilter.doFilter
    1. org.uberfire.ext.security.server.SecurityIntegrationFilter.doFilter(SecurityIntegrationFilter.java:45)[uberfire-servlet-security-0.7.3.Final.jar:0.7.3.Final]
    1 frame
  22. Undertow Servlet
    ServletDispatchingHandler.handleRequest
    1. io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60)[undertow-servlet-1.0.15.Final.jar:1.0.15.Final]
    2. io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132)[undertow-servlet-1.0.15.Final.jar:1.0.15.Final]
    3. io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:85)[undertow-servlet-1.0.15.Final.jar:1.0.15.Final]
    4. io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:61)[undertow-servlet-1.0.15.Final.jar:1.0.15.Final]
    5. io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)[undertow-servlet-1.0.15.Final.jar:1.0.15.Final]
    5 frames
  23. WildFly: Undertow
    SecurityContextAssociationHandler.handleRequest
    1. org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78)
    1 frame
  24. Undertow Core
    PredicateHandler.handleRequest
    1. io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:25)[undertow-core-1.0.15.Final.jar:1.0.15.Final]
    1 frame
  25. Undertow Servlet
    ServletAuthenticationCallHandler.handleRequest
    1. io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:113)[undertow-servlet-1.0.15.Final.jar:1.0.15.Final]
    2. io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:56)[undertow-servlet-1.0.15.Final.jar:1.0.15.Final]
    2 frames
  26. Undertow Core
    AbstractConfidentialityHandler.handleRequest
    1. io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:25)[undertow-core-1.0.15.Final.jar:1.0.15.Final]
    2. io.undertow.security.handlers.AuthenticationConstraintHandler.handleRequest(AuthenticationConstraintHandler.java:51)[undertow-core-1.0.15.Final.jar:1.0.15.Final]
    3. io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:45)[undertow-core-1.0.15.Final.jar:1.0.15.Final]
    3 frames
  27. Undertow Servlet
    ServletSecurityConstraintHandler.handleRequest
    1. io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:61)[undertow-servlet-1.0.15.Final.jar:1.0.15.Final]
    2. io.undertow.servlet.handlers.security.ServletSecurityConstraintHandler.handleRequest(ServletSecurityConstraintHandler.java:56)[undertow-servlet-1.0.15.Final.jar:1.0.15.Final]
    2 frames
  28. Undertow Core
    AuthenticationMechanismsHandler.handleRequest
    1. io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:58)[undertow-core-1.0.15.Final.jar:1.0.15.Final]
    1 frame
  29. Undertow Servlet
    CachedAuthenticatedSessionHandler.handleRequest
    1. io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:70)[undertow-servlet-1.0.15.Final.jar:1.0.15.Final]
    1 frame
  30. Undertow Core
    PredicateHandler.handleRequest
    1. io.undertow.security.handlers.SecurityInitialHandler.handleRequest(SecurityInitialHandler.java:76)[undertow-core-1.0.15.Final.jar:1.0.15.Final]
    2. io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:25)[undertow-core-1.0.15.Final.jar:1.0.15.Final]
    2 frames
  31. WildFly: Undertow
    JACCContextIdHandler.handleRequest
    1. org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)
    1 frame
  32. Undertow Core
    PredicateHandler.handleRequest
    1. io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:25)[undertow-core-1.0.15.Final.jar:1.0.15.Final]
    2. io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:25)[undertow-core-1.0.15.Final.jar:1.0.15.Final]
    2 frames
  33. Undertow Servlet
    ServletInitialHandler$1.handleRequest
    1. io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:240)[undertow-servlet-1.0.15.Final.jar:1.0.15.Final]
    2. io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:227)[undertow-servlet-1.0.15.Final.jar:1.0.15.Final]
    3. io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:73)[undertow-servlet-1.0.15.Final.jar:1.0.15.Final]
    4. io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:146)[undertow-servlet-1.0.15.Final.jar:1.0.15.Final]
    4 frames
  34. Undertow Core
    HttpServerExchange$1.run
    1. io.undertow.server.Connectors.executeRootHandler(Connectors.java:177)[undertow-core-1.0.15.Final.jar:1.0.15.Final]
    2. io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:727)[undertow-core-1.0.15.Final.jar:1.0.15.Final]
    2 frames
  35. Java RT
    Thread.run
    1. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)[rt.jar:1.8.0_60]
    2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)[rt.jar:1.8.0_60]
    3. java.lang.Thread.run(Thread.java:745)[rt.jar:1.8.0_60]
    3 frames