java.sql.SQLException: Invalid column name

Google Groups | EvenAngel007 | 9 months ago
  1. 0

    SQLException with Portofino 4.2.1

    Google Groups | 9 months ago | EvenAngel007
    java.sql.SQLException: Invalid column name
  2. 0

    java.sql.SQLException: Invalid column name when calling sql

    Oracle Community | 3 years ago | mm07
    java.sql.SQLException: Invalid column name
  3. 0

    ignore null values

    Oracle Community | 3 years ago | mm07
    java.sql.SQLException: Invalid column name
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Dashboard statistics problem still persist on Oracle

    GitHub | 4 years ago | graz1an0
    net.sf.hibernate.exception.SQLGrammarException: error performing findBySQL
  6. 0

    I'm getting error "Invalid column name"

    Stack Overflow | 5 years ago | vijaya kumar
    org.hibernate.exception.GenericJDBCException: could not execute query

  1. pnaranja 6 times, last 4 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. java.sql.SQLException

    Invalid column name

    at oracle.jdbc.driver.OracleStatement.getColumnIndex()
  2. Oracle jdbc
    OracleResultSet.getString
    1. oracle.jdbc.driver.OracleStatement.getColumnIndex(OracleStatement.java:3711)[ojdbc6.jar:11.2.0.3.0]
    2. oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:2763)[ojdbc6.jar:11.2.0.3.0]
    3. oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:494)[ojdbc6.jar:11.2.0.3.0]
    3 frames
  3. com.manydesigns.portofino
    ApplicationWizard.configureConnectionProvider
    1. com.manydesigns.portofino.database.platforms.AbstractDatabasePlatform.getSchemaNames(AbstractDatabasePlatform.java:138)[portofino-database-4.2.1.jar:4.2.1]
    2. com.manydesigns.portofino.database.platforms.OracleDatabasePlatform.getSchemaNames(OracleDatabasePlatform.java:71)[portofino-oracle-4.2.1.jar:4.2.1]
    3. com.manydesigns.portofino.actions.admin.appwizard.ApplicationWizard.configureEditSchemas(ApplicationWizard.java:358)[portofino-admin-4.2.1.jar:4.2.1]
    4. com.manydesigns.portofino.actions.admin.appwizard.ApplicationWizard.afterCreateConnectionProvider(ApplicationWizard.java:339)[portofino-admin-4.2.1.jar:4.2.1]
    5. com.manydesigns.portofino.actions.admin.appwizard.ApplicationWizard.configureConnectionProvider(ApplicationWizard.java:331)[portofino-admin-4.2.1.jar:4.2.1]
    5 frames
  4. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[na:1.7.0_67]
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)[na:1.7.0_67]
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[na:1.7.0_67]
    4. java.lang.reflect.Method.invoke(Method.java:606)[na:1.7.0_67]
    4 frames
  5. Stripes
    ExecutionContext.proceed
    1. net.sourceforge.stripes.controller.DispatcherHelper$6.intercept(DispatcherHelper.java:456)[stripes-1.6.0.jar:1.6.0]
    2. net.sourceforge.stripes.controller.ExecutionContext.proceed(ExecutionContext.java:176)[stripes-1.6.0.jar:1.6.0]
    2 frames
  6. com.manydesigns.portofino
    GuardsInterceptor.intercept
    1. com.manydesigns.portofino.interceptors.GuardsInterceptor.intercept(GuardsInterceptor.java:61)[portofino-base-4.2.1.jar:4.2.1]
    1 frame
  7. Stripes
    DispatcherServlet.service
    1. net.sourceforge.stripes.controller.ExecutionContext.proceed(ExecutionContext.java:173)[stripes-1.6.0.jar:1.6.0]
    2. net.sourceforge.stripes.controller.BeforeAfterMethodInterceptor.intercept(BeforeAfterMethodInterceptor.java:113)[stripes-1.6.0.jar:1.6.0]
    3. net.sourceforge.stripes.controller.ExecutionContext.proceed(ExecutionContext.java:173)[stripes-1.6.0.jar:1.6.0]
    4. net.sourceforge.stripes.controller.ExecutionContext.wrap(ExecutionContext.java:86)[stripes-1.6.0.jar:1.6.0]
    5. net.sourceforge.stripes.controller.DispatcherHelper.invokeEventHandler(DispatcherHelper.java:454)[stripes-1.6.0.jar:1.6.0]
    6. net.sourceforge.stripes.controller.DispatcherServlet.invokeEventHandler(DispatcherServlet.java:278)[stripes-1.6.0.jar:1.6.0]
    7. net.sourceforge.stripes.controller.DispatcherServlet.service(DispatcherServlet.java:160)[stripes-1.6.0.jar:1.6.0]
    7 frames
  8. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:729)[servlet-api.jar:na]
    1 frame
  9. com.manydesigns.portofino
    SimpleDynamicMappingFilter.doFilter
    1. com.manydesigns.portofino.stripes.SimpleDynamicMappingFilter.doFilter(SimpleDynamicMappingFilter.java:60)[portofino-stripes-4.2.1.jar:4.2.1]
    1 frame
  10. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)[catalina.jar:8.0.30]
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)[catalina.jar:8.0.30]
    2 frames
  11. com.manydesigns.portofino
    I18nFilter.doFilter
    1. com.manydesigns.portofino.servlets.I18nFilter.doFilter(I18nFilter.java:60)[portofino-base-4.2.1.jar:4.2.1]
    1 frame
  12. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)[catalina.jar:8.0.30]
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)[catalina.jar:8.0.30]
    2 frames
  13. Stripes
    StripesFilter.doFilter
    1. net.sourceforge.stripes.controller.StripesFilter.doFilter(StripesFilter.java:260)[stripes-1.6.0.jar:1.6.0]
    1 frame
  14. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)[catalina.jar:8.0.30]
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)[catalina.jar:8.0.30]
    2 frames
  15. com.manydesigns.portofino
    CleanupFilter.doFilter
    1. com.manydesigns.portofino.servlets.CleanupFilter.doFilter(CleanupFilter.java:46)[portofino-database-4.2.1.jar:4.2.1]
    1 frame
  16. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)[catalina.jar:8.0.30]
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)[catalina.jar:8.0.30]
    2 frames
  17. com.manydesigns.portofino
    DispatcherFilter.doFilter
    1. com.manydesigns.portofino.servlets.DispatcherFilter.doFilter(DispatcherFilter.java:61)[portofino-pageactions-4.2.1.jar:4.2.1]
    1 frame
  18. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)[catalina.jar:8.0.30]
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)[catalina.jar:8.0.30]
    2 frames
  19. Shiro
    OncePerRequestFilter.doFilter
    1. org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)[shiro-web-1.2.3.jar:1.2.3]
    2. org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)[shiro-web-1.2.3.jar:1.2.3]
    3. org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)[shiro-core-1.2.3.jar:1.2.3]
    4. org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)[shiro-core-1.2.3.jar:1.2.3]
    5. org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383)[shiro-core-1.2.3.jar:1.2.3]
    6. org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)[shiro-web-1.2.3.jar:1.2.3]
    7. org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)[shiro-web-1.2.3.jar:1.2.3]
    7 frames
  20. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)[catalina.jar:8.0.30]
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)[catalina.jar:8.0.30]
    2 frames
  21. com.manydesigns.elements
    ElementsFilter.doFilter
    1. com.manydesigns.elements.servlet.ElementsFilter.doHttpFilter(ElementsFilter.java:132)[elements-4.2.1.jar:4.2.1]
    2. com.manydesigns.elements.servlet.ElementsFilter.doFilter(ElementsFilter.java:83)[elements-4.2.1.jar:4.2.1]
    2 frames
  22. Glassfish Core
    CoyoteAdapter.service
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)[catalina.jar:8.0.30]
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)[catalina.jar:8.0.30]
    3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)[catalina.jar:8.0.30]
    4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)[catalina.jar:8.0.30]
    5. org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)[catalina.jar:8.0.30]
    6. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)[catalina.jar:8.0.30]
    7. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)[catalina.jar:8.0.30]
    8. org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)[catalina.jar:8.0.30]
    9. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)[catalina.jar:8.0.30]
    10. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:521)[catalina.jar:8.0.30]
    10 frames
  23. Grizzly HTTP
    NioEndpoint$SocketProcessor.run
    1. org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1096)[tomcat-coyote.jar:8.0.30]
    2. org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:674)[tomcat-coyote.jar:8.0.30]
    3. org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1500)[tomcat-coyote.jar:8.0.30]
    4. org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1456)[tomcat-coyote.jar:8.0.30]
    4 frames
  24. Java RT
    ThreadPoolExecutor$Worker.run
    1. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)[na:1.7.0_67]
    2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)[na:1.7.0_67]
    2 frames
  25. Tomcat Util
    TaskThread$WrappingRunnable.run
    1. org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)[tomcat-util.jar:8.0.30]
    1 frame
  26. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:745)[na:1.7.0_67]
    1 frame