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

Google Groups | Unknown author | 2 months ago
  1. 0

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

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

    GitHub comment 412#219778062

    GitHub | 7 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 | 9 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 | 8 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