org.postgresql.util.PSQLException: The column name c_sm_vnm2_15_0_ was not found in this ResultSet.

Stack Overflow | Ilesh Patel | 5 months ago
  1. 0

    @SqlResultSetMapping thows strange exception with Spring JPA

    Stack Overflow | 5 months ago | Ilesh Patel
    org.postgresql.util.PSQLException: The column name c_sm_vnm2_15_0_ was not found in this ResultSet.
  2. 0

    How to retrieve data from Postgresql index using java

    Database Administrators | 3 years ago | Neeraj
    org.postgresql.util.PSQLException: The column name person_name was not found in this ResultSet.
  3. 0

    Failing VM backups with version 4.0.4

    GitHub | 1 month ago | vinaobraga
    org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select \* from getdiskvmelementbydiskvmelementid(?, ?)]; nested exception is org.postgresql.util.PSQLException: The column name logical_name was not found in this ResultSet.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Exception always thrown in method called from JSP page

    Stack Overflow | 4 years ago | Josh
    org.postgresql.util.PSQLException: ResultSet not positioned properly, perhaps you need to call next.
  6. 0

    PgSQL Exception: column name not found

    Stack Overflow | 7 years ago
    org.postgresql.util.PSQLException: The column name sender_id was not found in this ResultSet.

  1. RoiOtero 3 times, last 7 months ago
3 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

    The column name c_sm_vnm2_15_0_ was not found in this ResultSet.

    at org.postgresql.jdbc2.AbstractJdbc2ResultSet.findColumn()
  2. PostgreSQL JDBC Driver
    AbstractJdbc2ResultSet.getString
    1. org.postgresql.jdbc2.AbstractJdbc2ResultSet.findColumn(AbstractJdbc2ResultSet.java:2727)
    2. org.postgresql.jdbc2.AbstractJdbc2ResultSet.getString(AbstractJdbc2ResultSet.java:2567)
    2 frames
  3. HikariCP-java6
    HikariProxyResultSet.getString
    1. com.zaxxer.hikari.pool.HikariProxyResultSet.getString(HikariProxyResultSet.java)
    1 frame
  4. Hibernate
    SQLQueryImpl.list
    1. org.hibernate.type.descriptor.sql.VarcharTypeDescriptor$2.doExtract(VarcharTypeDescriptor.java:74)
    2. org.hibernate.type.descriptor.sql.BasicExtractor.extract(BasicExtractor.java:64)
    3. org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:267)
    4. org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:263)
    5. org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:253)
    6. org.hibernate.type.AbstractStandardBasicType.hydrate(AbstractStandardBasicType.java:338)
    7. org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2969)
    8. org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1695)
    9. org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1627)
    10. org.hibernate.loader.Loader.getRow(Loader.java:1514)
    11. org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:725)
    12. org.hibernate.loader.Loader.processResultSet(Loader.java:952)
    13. org.hibernate.loader.Loader.doQuery(Loader.java:920)
    14. org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:354)
    15. org.hibernate.loader.Loader.doList(Loader.java:2553)
    16. org.hibernate.loader.Loader.doList(Loader.java:2539)
    17. org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2369)
    18. org.hibernate.loader.Loader.list(Loader.java:2364)
    19. org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:353)
    20. org.hibernate.internal.SessionImpl.listCustomQuery(SessionImpl.java:1873)
    21. org.hibernate.internal.AbstractSessionImpl.list(AbstractSessionImpl.java:311)
    22. org.hibernate.internal.SQLQueryImpl.list(SQLQueryImpl.java:141)
    22 frames
  5. org.hibernate.jpa
    QueryImpl.getResultList
    1. org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:573)
    2. org.hibernate.jpa.internal.QueryImpl.getResultList(QueryImpl.java:449)
    2 frames
  6. com.vinayak.education
    SchoolServiceImpl.getAllSchoolsWithAdvanceSearch
    1. com.vinayak.education.dao.impl.SchoolDaoImpl.getAllSchoolsWithAdvanceSearch(SchoolDaoImpl.java:39)
    2. com.vinayak.education.service.impl.SchoolServiceImpl.getAllSchoolsWithAdvanceSearch(SchoolServiceImpl.java:29)
    2 frames
  7. 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:497)
    4 frames
  8. Spring AOP
    ReflectiveMethodInvocation.proceed
    1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
    2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
    3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
    3 frames
  9. Spring Tx
    TransactionInterceptor.invoke
    1. org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:98)
    2. org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:266)
    3. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95)
    3 frames
  10. Spring AOP
    JdkDynamicAopProxy.invoke
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
    2 frames
  11. com.sun.proxy
    $Proxy115.getAllSchoolsWithAdvanceSearch
    1. com.sun.proxy.$Proxy115.getAllSchoolsWithAdvanceSearch(Unknown Source)
    1 frame
  12. com.vinayak.education
    SchoolController$$FastClassBySpringCGLIB$$aea67306.invoke
    1. com.vinayak.education.rest.SchoolController.getAllSchoolsWithAdvanceSearch(SchoolController.java:112)
    2. com.vinayak.education.rest.SchoolController$$FastClassBySpringCGLIB$$aea67306.invoke(<generated>)
    2 frames
  13. Spring Core
    MethodProxy.invoke
    1. org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
    1 frame
  14. Spring AOP
    ReflectiveMethodInvocation.proceed
    1. org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:717)
    2. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
    2 frames
  15. spring-security-core
    MethodSecurityInterceptor.invoke
    1. org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:64)
    1 frame
  16. Spring AOP
    CglibAopProxy$DynamicAdvisedInterceptor.intercept
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    2. org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:653)
    2 frames
  17. com.vinayak.education
    SchoolController$$EnhancerBySpringCGLIB$$bbb7f604.getAllSchoolsWithAdvanceSearch
    1. com.vinayak.education.rest.SchoolController$$EnhancerBySpringCGLIB$$bbb7f604.getAllSchoolsWithAdvanceSearch(<generated>)
    1 frame
  18. 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:497)
    4 frames
  19. Spring
    InvocableHandlerMethod.invokeForRequest
    1. org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215)
    2. org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
    2 frames
  20. Spring MVC
    FrameworkServlet.doPost
    1. org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
    2. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:781)
    3. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:721)
    4. org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:83)
    5. org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:943)
    6. org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:877)
    7. org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966)
    8. org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:868)
    8 frames
  21. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
    1 frame
  22. Spring MVC
    FrameworkServlet.service
    1. org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)
    1 frame
  23. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    1 frame
  24. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    2 frames
  25. CORS Filter
    CORSFilter.doFilter
    1. com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:174)
    2. com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:237)
    2 frames
  26. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    2 frames
  27. Spring Security
    FilterChainProxy$VirtualFilterChain.doFilter
    1. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
    2. org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
    3. org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
    4. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    5. org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
    6. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    7. org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
    8. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    9. org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:154)
    10. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    10 frames
  28. com.vinayak.life
    AuthenticationTokenProcessingFilter.doFilter
    1. com.vinayak.life.security.AuthenticationTokenProcessingFilter.doFilter(AuthenticationTokenProcessingFilter.java:97)
    1 frame
  29. Spring Security
    FilterChainProxy.doFilter
    1. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    2. org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
    3. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    4. org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
    5. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    6. org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
    7. org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
    7 frames
  30. Spring
    DelegatingFilterProxy.doFilter
    1. org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:344)
    2. org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:261)
    2 frames
  31. Glassfish Core
    CoyoteAdapter.service
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    5. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    6. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    7. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    8. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
    8 frames
  32. Grizzly HTTP
    JIoEndpoint$Worker.run
    1. org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
    2. org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
    3. org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    3 frames
  33. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:745)
    1 frame