org.springframework.dao.DataRetrievalFailureException: Error loading user details for: sysadmin; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query

Google Groups | chrismarx | 5 years ago
  1. 0

    tomcat error - java.sql.SQLException: Connection has already been closed.

    Google Groups | 5 years ago | chrismarx
    org.springframework.dao.DataRetrievalFailureException: Error loading user details for: sysadmin; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query
  2. 0

    Jtrac + postgres issue

    j-trac | 9 years ago | nobody
    org.hibernate.exception.SQLGrammarException: could not execute query
  3. 0

    ERROR : column "this_.date" must appear in the GROUP BY clause or be used in an aggregate function

    Stack Overflow | 1 year ago | Chengappa
    org.postgresql.util.PSQLException: ERROR: column "this_.date" must appear in the GROUP BY clause or be used in an aggregate function Position: 296
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    PostgreSQL 8.3 support

    GitHub | 3 years ago | flyway
    org.apache.maven.lifecycle.LifecycleExecutionException: Flyway Error: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select typname from pg_catalog.pg_type where typcategory in ('P', 'U') and typnamespace in (select oid from pg_catalog.pg_namespace where nspname = ?)]; nested exception is org.postgresql.util.PSQLException: ERROR: column "typcategory" does not exist
  6. 0

    Obscure error reporting

    GitHub | 3 years ago | omj
    org.postgresql.util.PSQLException: ERROR: relation "project" does not exist org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
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 person0_.additionalproperties does not exist

    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse()
  2. PostgreSQL JDBC Driver
    AbstractJdbc2Statement.executeQuery
    1. org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
    2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
    3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
    4. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
    5. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
    6. org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
    6 frames
  3. Commons DBCP
    DelegatingPreparedStatement.executeQuery
    1. org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
    1 frame
  4. Hibernate
    QueryLoader.list
    1. org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
    2. org.hibernate.loader.Loader.getResultSet(Loader.java:1812)
    3. org.hibernate.loader.Loader.doQuery(Loader.java:697)
    4. org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
    5. org.hibernate.loader.Loader.doList(Loader.java:2232)
    6. org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129)
    7. org.hibernate.loader.Loader.list(Loader.java:2124)
    8. org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
    8 frames
  5. Hibernate HQL/JP-QL Parser
    QueryTranslatorImpl.list
    1. org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
    1 frame
  6. Hibernate
    QueryImpl.list
    1. org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
    2. org.hibernate.impl.SessionImpl.list(SessionImpl.java:1149)
    3. org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
    3 frames
  7. Hibernate EJB
    QueryImpl.getResultList
    1. org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:67)
    1 frame
  8. org.eurekastreams.server
    OpenAccessAuthenticationProvider.authenticate
    1. org.eurekastreams.server.persistence.PersonMapper.findByAccountId(PersonMapper.java:78)
    2. org.eurekastreams.server.service.security.userdetails.UserDetailsServiceImpl.loadUserByUsername(UserDetailsServiceImpl.java:135)
    3. org.eurekastreams.server.service.security.openaccess.OpenAccessAuthenticationProvider.authenticate(OpenAccessAuthenticationProvider.java:62)
    3 frames
  9. org.springframework.security
    SpringSecurityFilter.doFilter
    1. org.springframework.security.providers.ProviderManager.doAuthentication(ProviderManager.java:188)
    2. org.springframework.security.AbstractAuthenticationManager.authenticate(AbstractAuthenticationManager.java:46)
    3. org.springframework.security.ui.webapp.AuthenticationProcessingFilter.attemptAuthentication(AuthenticationProcessingFilter.java:82)
    4. org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:258)
    5. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    5 frames
  10. spring-security-core
    FilterChainProxy$VirtualFilterChain.doFilter
    1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    1 frame
  11. org.springframework.security
    SpringSecurityFilter.doFilter
    1. org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89)
    2. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    2 frames
  12. spring-security-core
    FilterChainProxy$VirtualFilterChain.doFilter
    1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    1 frame
  13. Spring Security - Portlet support
    HttpSessionContextIntegrationFilter.doFilterHttp
    1. org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
    1 frame
  14. org.springframework.security
    SpringSecurityFilter.doFilter
    1. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    1 frame
  15. spring-security-core
    FilterChainProxy.doFilter
    1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    2. org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)
    2 frames
  16. Spring
    DelegatingFilterProxy.doFilter
    1. org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
    2. org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
    2 frames
  17. Glassfish Core
    CoyoteAdapter.service
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
    4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
    5. org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
    6. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
    7. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
    8. org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:947)
    9. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
    10. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
    10 frames
  18. Grizzly HTTP
    JIoEndpoint$SocketProcessor.run
    1. org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1009)
    2. org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
    3. org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
    3 frames
  19. Java RT
    Thread.run
    1. java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    2. java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    3. java.lang.Thread.run(Unknown Source)
    3 frames