org.jboss.resteasy.spi.UnhandledException: org.hibernate.exception. SQLGrammarException: could not extract ResultSet

Google Groups | Unknown author | 5 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

    Problem upgrading dcm4chee-arc-light from 5.5.4-psql-secure to 5.6.0-psql-secure

    Google Groups | 5 months ago | Unknown author
    org.jboss.resteasy.spi.UnhandledException: org.hibernate.exception. SQLGrammarException: could not extract ResultSet
  2. 0

    GitHub comment 412#219778062

    GitHub | 9 months ago | rdp
    org.postgresql.util.PSQLException: ERROR: canceling statement due to user request
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    Passing an array into PreparedStatement for PostgreSQL Function

    Stack Overflow | 12 months ago | Vineet
    org.postgresql.util.PSQLException: ERROR: malformed record literal: "qwe" Detail: Missing left parenthesis.
  5. 0

    com.sun.faces.mgbean.ManagedBeanCreationException: Erreur lors de l’injection de ressources dans le bean géré «vehicules»

    Stack Overflow | 11 months ago | Jonathan Marchandise
    org.postgresql.util.PSQLException: ERREUR: la colonne « t_vehicules_carburant_fk » n'existe pas Indice : Peut-être que vous souhaitiez référencer la colonne « t_vehicules.t_vehicules_carburant_FK ». Position : 24 Error Code: 0 Call: SELECT t_vehicules_id, t_vehicules_carburant_FK, t_vehicules_annee_achat, t_vehicules_annee_fabrication, t_vehicules_actif, t_vehicules_marque_FK, t_vehicules_proprietaire_FK, t_vehicules_nb_kil FROM t_vehicules Query: ReadAllQuery(referenceClass=vehicules sql="SELECT t_vehicules_id, t_vehicules_carburant_FK, t_vehicules_annee_achat, t_vehicules_annee_fabrication, t_vehicules_actif, t_vehicules_marque_FK, t_vehicules_proprietaire_FK, t_vehicules_nb_kil FROM t_vehicules")
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: column patient1_.num_studies does not exist Position: 32

    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse()
  2. PostgreSQL JDBC Driver
    QueryExecutorImpl.execute
    1. org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2284)
    2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2003)
    3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:200)
    3 frames
  3. org.postgresql.jdbc
    PgPreparedStatement.executeQuery
    1. org.postgresql.jdbc.PgStatement.execute(PgStatement.java:424)
    2. org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:161)
    3. org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:114)
    3 frames
  4. IronJacamar
    WrappedPreparedStatement.executeQuery
    1. org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:504)
    1 frame
  5. Hibernate
    QueryImpl.scroll
    1. org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:70)
    2. org.hibernate.loader.Loader.getResultSet(Loader.java:2116)
    3. org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1899)
    4. org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1875)
    5. org.hibernate.loader.Loader.scroll(Loader.java:2687)
    6. org.hibernate.loader.hql.QueryLoader.scroll(QueryLoader.java:570)
    7. org.hibernate.hql.internal.ast.QueryTranslatorImpl.scroll(QueryTranslatorImpl.java:423)
    8. org.hibernate.engine.query.spi.HQLQueryPlan.performScroll(HQLQueryPlan.java:350)
    9. org.hibernate.internal.StatelessSessionImpl.scroll(StatelessSessionImpl.java:701)
    10. org.hibernate.internal.QueryImpl.scroll(QueryImpl.java:75)
    10 frames
  6. com.querydsl.jpa
    AbstractHibernateQuery.iterate
    1. com.querydsl.jpa.hibernate.AbstractHibernateQuery.iterate(AbstractHibernateQuery.java:163)
    1 frame
  7. org.dcm4chee.arc
    QidoRS$Proxy$_$$_WeldClientProxy.searchForStudiesJSON
    1. org.dcm4chee.arc.query.impl.AbstractQuery.executeQuery(AbstractQuery.java:91)
    2. org.dcm4chee.arc.qido.QidoRS.search(QidoRS.java:382)
    3. org.dcm4chee.arc.qido.QidoRS.searchForStudiesJSON(QidoRS.java:252)
    4. org.dcm4chee.arc.qido.QidoRS$Proxy$_$$_WeldClientProxy.searchForStudiesJSON(Unknown Source)
    4 frames
  8. 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
  9. RESTEasy JAX-RS Implementation
    HttpServletDispatcher.service
    1. org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:139)
    2. org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMethodInvoker.java:295)
    3. org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:249)
    4. org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:236)
    5. org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:395)
    6. org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:202)
    7. org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:221)
    8. org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)
    9. org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51)
    9 frames
  10. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
    1 frame
  11. Undertow Servlet
    ServletDispatchingHandler.handleRequest
    1. io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:85)
    2. io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
    3. io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
    3 frames
  12. WildFly: Undertow
    SecurityContextAssociationHandler.handleRequest
    1. org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78)
    1 frame
  13. Undertow Core
    PredicateHandler.handleRequest
    1. io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
    1 frame
  14. org.keycloak.adapters
    UndertowAuthenticatedActionsHandler.handleRequest
    1. org.keycloak.adapters.undertow.UndertowAuthenticatedActionsHandler.handleRequest(UndertowAuthenticatedActionsHandler.java:66)
    1 frame
  15. Undertow Servlet
    ServletAuthenticationCallHandler.handleRequest
    1. io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:131)
    2. io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
    2 frames
  16. Undertow Core
    AbstractConfidentialityHandler.handleRequest
    1. io.undertow.server.handlers.DisableCacheHandler.handleRequest(DisableCacheHandler.java:33)
    2. io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
    3. io.undertow.security.handlers.AuthenticationConstraintHandler.handleRequest(AuthenticationConstraintHandler.java:51)
    4. io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
    4 frames
  17. Undertow Servlet
    ServletSecurityConstraintHandler.handleRequest
    1. io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
    2. io.undertow.servlet.handlers.security.ServletSecurityConstraintHandler.handleRequest(ServletSecurityConstraintHandler.java:56)
    2 frames
  18. Undertow Core
    AuthenticationMechanismsHandler.handleRequest
    1. io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
    1 frame
  19. Undertow Servlet
    CachedAuthenticatedSessionHandler.handleRequest
    1. io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
    1 frame
  20. Undertow Core
    PredicateHandler.handleRequest
    1. io.undertow.security.handlers.NotificationReceiverHandler.handleRequest(NotificationReceiverHandler.java:50)
    2. io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
    3. io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
    3 frames
  21. WildFly: Undertow
    JACCContextIdHandler.handleRequest
    1. org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)
    1 frame
  22. Undertow Core
    PredicateHandler.handleRequest
    1. io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
    1 frame
  23. org.keycloak.adapters
    ServletPreAuthActionsHandler.handleRequest
    1. org.keycloak.adapters.undertow.ServletPreAuthActionsHandler.handleRequest(ServletPreAuthActionsHandler.java:69)
    1 frame
  24. Undertow Core
    PredicateHandler.handleRequest
    1. io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
    1 frame
  25. Undertow Servlet
    ServletInitialHandler$1.handleRequest
    1. io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:284)
    2. io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:263)
    3. io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:81)
    4. io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:174)
    4 frames
  26. Undertow Core
    HttpServerExchange$1.run
    1. io.undertow.server.Connectors.executeRootHandler(Connectors.java:202)
    2. io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:793)
    2 frames
  27. Java RT
    Thread.run
    1. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    3. java.lang.Thread.run(Thread.java:745)
    3 frames