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

Google Groups | Imro | 1 year ago
  1. 0

    REST/query with 6.3.0.Final throws SQLGrammarException

    Google Groups | 1 year 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 | 4 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 | 12 months ago
    javax.servlet.ServletException: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not extract ResultSet
  6. 0

    Geovise BVBA

    hibernatespatial.org | 12 months ago
    javax.servlet.ServletException: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not extract ResultSet

  1. csanyigabor 4 times, last 3 months ago
  2. Tahir 1 times, last 3 months ago
  3. RoiOtero 3 times, last 5 months ago
  4. haerick 8 times, last 5 months ago
  5. silex 15 times, last 6 months ago
2 more registered users
33 unregistered visitors
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