javax.servlet.ServletException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query

Atlassian JIRA | Charles Miller [Atlassian] | 8 years ago
  1. 0

    Clicked on "Approved Sites" in my OpenId profile, got 500 page: Cause : javax.servlet.ServletException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query Stack Trace : javax.servlet.ServletException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query at com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(DispatcherUtils.java:284) at com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:202) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.opensymphony.webwork.dispatcher.ActionContextCleanUp.doFilter(ActionContextCleanUp.java:88) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:350) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.crowd.integration.http.VerifyTokenFilter.doFilter(VerifyTokenFilter.java:172) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:183) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:33) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Thread.java:619) Referer : https://openid.atlassian.com/secure/profile/editprofiles!update.action Build Information : Version : 1.5-SNAPSHOT (Build:#320 - Aug 07, 2008) Memory Information : Total Memory : 88 MB Free Memory : 18 MB Used Memory : 69 MB Request Information : - Request URL : https://openid.atlassian.com/500.jsp - Scheme : https - Server : openid.atlassian.com - Port : 443 - URI : /500.jsp - Context Path : - - Servlet Path : /500.jsp - - Path Info : null - - Query String : Request Attributes : - javax.servlet.forward.request_uri : /secure/interaction/editallowalways!default.action - javax.servlet.forward.context_path : - javax.servlet.forward.servlet_path : /secure/interaction/editallowalways!default.action - javax.servlet.forward.path_info : /500.jsp - javax.servlet.error.message : - interface com.atlassian.crowd.integration.http.HttpAuthenticator.REQUEST_SSO_COOKIE_COMMITTED : true - javax.servlet.error.status_code : 500 - javax.servlet.error.servlet_name : default - webwork.valueStack : com.opensymphony.xwork.util.OgnlValueStack@73400a - sessioninview.FILTERED : true - __sitemesh__filterapplied : true - javax.servlet.error.exception : javax.servlet.ServletException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query - __cleanup_counter : 0 - javax.servlet.error.request_uri : /secure/interaction/editallowalways!default.action - com.atlassian.crowd.integration.http.VerifyTokenFilter.FILTER_RUN : true - crowd.token_key : KAcCaMllsaSnXltDlE0O8g00

    Atlassian JIRA | 8 years ago | Charles Miller [Atlassian]
    javax.servlet.ServletException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
  2. 0

    Clicked on "Approved Sites" in my OpenId profile, got 500 page: Cause : javax.servlet.ServletException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query Stack Trace : javax.servlet.ServletException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query at com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(DispatcherUtils.java:284) at com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:202) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.opensymphony.webwork.dispatcher.ActionContextCleanUp.doFilter(ActionContextCleanUp.java:88) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:350) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.crowd.integration.http.VerifyTokenFilter.doFilter(VerifyTokenFilter.java:172) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:183) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:33) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Thread.java:619) Referer : https://openid.atlassian.com/secure/profile/editprofiles!update.action Build Information : Version : 1.5-SNAPSHOT (Build:#320 - Aug 07, 2008) Memory Information : Total Memory : 88 MB Free Memory : 18 MB Used Memory : 69 MB Request Information : - Request URL : https://openid.atlassian.com/500.jsp - Scheme : https - Server : openid.atlassian.com - Port : 443 - URI : /500.jsp - Context Path : - - Servlet Path : /500.jsp - - Path Info : null - - Query String : Request Attributes : - javax.servlet.forward.request_uri : /secure/interaction/editallowalways!default.action - javax.servlet.forward.context_path : - javax.servlet.forward.servlet_path : /secure/interaction/editallowalways!default.action - javax.servlet.forward.path_info : /500.jsp - javax.servlet.error.message : - interface com.atlassian.crowd.integration.http.HttpAuthenticator.REQUEST_SSO_COOKIE_COMMITTED : true - javax.servlet.error.status_code : 500 - javax.servlet.error.servlet_name : default - webwork.valueStack : com.opensymphony.xwork.util.OgnlValueStack@73400a - sessioninview.FILTERED : true - __sitemesh__filterapplied : true - javax.servlet.error.exception : javax.servlet.ServletException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query - __cleanup_counter : 0 - javax.servlet.error.request_uri : /secure/interaction/editallowalways!default.action - com.atlassian.crowd.integration.http.VerifyTokenFilter.FILTER_RUN : true - crowd.token_key : KAcCaMllsaSnXltDlE0O8g00

    Atlassian JIRA | 8 years ago | Charles Miller [Atlassian]
    javax.servlet.ServletException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
  3. 0

    When a user visits the Crowd openid server and changes his/her password all works fine. But if I click another link there, I get the following error. I get it when i click one of the following: 'administration', 'profiles', 'approved sites', 'history'. I don't get the error when i click 'My OpenId', although there it says 'nullusers/USERNAME' (with my own username as USERNAME). System Error System Error A system error has occured please contact your administrator. If this problem continues to occur please contact Atlassian by opening a support request with the following information: - A description of your problem and what you were doing at the time it occurred - Cut & paste the error and system information found below - Attach the application server log file (if possible). Cause : javax.servlet.ServletException: Hibernate operation: could not execute query; bad SQL grammar [select this_.ID as ID22_0_, this_.NAME as NAME22_0_, this_.VALUE as VALUE22_0_ from SERVERPROPERTY this_ where this_.NAME=?]; nested exception is java.sql.SQLException: Table not found in statement [select this_.ID as ID22_0_, this_.NAME as NAME22_0_, this_.VALUE as VALUE22_0_ from SERVERPROPERTY this_ where this_.NAME=?] Stack Trace : javax.servlet.ServletException: Hibernate operation: could not execute query; bad SQL grammar [select this_.ID as ID22_0_, this_.NAME as NAME22_0_, this_.VALUE as VALUE22_0_ from SERVERPROPERTY this_ where this_.NAME=?]; nested exception is java.sql.SQLException: Table not found in statement [select this_.ID as ID22_0_, this_.NAME as NAME22_0_, this_.VALUE as VALUE22_0_ from SERVERPROPERTY this_ where this_.NAME=?] at com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(DispatcherUtils.java:236) at com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:202) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:174) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:77) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.opensymphony.webwork.dispatcher.ActionContextCleanUp.doFilter(ActionContextCleanUp.java:88) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:350) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.crowd.integration.http.VerifyTokenFilter.doFilter(VerifyTokenFilter.java:131) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:37) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595) Referer : https://crowd.luminis.net/openidserver/secure/profile/viewidentity.action Build Information : Version : 1.1.2 (Build:#185 - Sep 03, 2007) Memory Information : Total Memory : 33 MB Free Memory : 9 MB Used Memory : 24 MB Request Information : - Request URL : http://localhost:8095/openidserver/500.jsp - Scheme : http - Server : localhost - Port : 8095 - URI : /openidserver/500.jsp - Context Path : /openidserver - - Servlet Path : /500.jsp - - Path Info : null - - Query String : Request Attributes : - javax.servlet.forward.request_uri : /openidserver/secure/admin/viewoptions.action - javax.servlet.forward.context_path : /openidserver - javax.servlet.forward.servlet_path : /secure/admin/viewoptions.action - javax.servlet.forward.path_info : /500.jsp - javax.servlet.error.servlet_name : default - crowd.token_key : fdX4H3OhmmwuRzm8bsOZYA00 - javax.servlet.error.message : - javax.servlet.error.exception : javax.servlet.ServletException: Hibernate operation: could not execute query; bad SQL grammar [select this_.ID as ID22_0_, this_.NAME as NAME22_0_, this_.VALUE as VALUE22_0_ from SERVERPROPERTY this_ where this_.NAME=?]; nested exception is java.sql.SQLException: Table not found in statement [select this_.ID as ID22_0_, this_.NAME as NAME22_0_, this_.VALUE as VALUE22_0_ from SERVERPROPERTY this_ where this_.NAME=?] - webwork.valueStack : com.opensymphony.xwork.util.OgnlValueStack@3f0e71 - javax.servlet.error.request_uri : /openidserver/secure/admin/viewoptions.action - __cleanup_counter : 0 - javax.servlet.error.status_code : 500 - com.atlassian.crowd.integration.http.VerifyTokenFilter.FILTER_RUN : true - __sitemesh__filterapplied : true - sessioninview.FILTERED : true

    Atlassian JIRA | 9 years ago | Ronald Spierenburg
    javax.servlet.ServletException: Hibernate operation: could not execute query; bad SQL grammar [select this_.ID as ID22_0_, this_.NAME as NAME22_0_, this_.VALUE as VALUE22_0_ from SERVERPROPERTY this_ where this_.NAME=?]; nested exception is java.sql.SQLException: Table not found in statement [select this_.ID as ID22_0_, this_.NAME as NAME22_0_, this_.VALUE as VALUE22_0_ from SERVERPROPERTY this_ where this_.NAME=?]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    When a user visits the Crowd openid server and changes his/her password all works fine. But if I click another link there, I get the following error. I get it when i click one of the following: 'administration', 'profiles', 'approved sites', 'history'. I don't get the error when i click 'My OpenId', although there it says 'nullusers/USERNAME' (with my own username as USERNAME). System Error System Error A system error has occured please contact your administrator. If this problem continues to occur please contact Atlassian by opening a support request with the following information: - A description of your problem and what you were doing at the time it occurred - Cut & paste the error and system information found below - Attach the application server log file (if possible). Cause : javax.servlet.ServletException: Hibernate operation: could not execute query; bad SQL grammar [select this_.ID as ID22_0_, this_.NAME as NAME22_0_, this_.VALUE as VALUE22_0_ from SERVERPROPERTY this_ where this_.NAME=?]; nested exception is java.sql.SQLException: Table not found in statement [select this_.ID as ID22_0_, this_.NAME as NAME22_0_, this_.VALUE as VALUE22_0_ from SERVERPROPERTY this_ where this_.NAME=?] Stack Trace : javax.servlet.ServletException: Hibernate operation: could not execute query; bad SQL grammar [select this_.ID as ID22_0_, this_.NAME as NAME22_0_, this_.VALUE as VALUE22_0_ from SERVERPROPERTY this_ where this_.NAME=?]; nested exception is java.sql.SQLException: Table not found in statement [select this_.ID as ID22_0_, this_.NAME as NAME22_0_, this_.VALUE as VALUE22_0_ from SERVERPROPERTY this_ where this_.NAME=?] at com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(DispatcherUtils.java:236) at com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:202) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:174) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:77) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.opensymphony.webwork.dispatcher.ActionContextCleanUp.doFilter(ActionContextCleanUp.java:88) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:350) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.crowd.integration.http.VerifyTokenFilter.doFilter(VerifyTokenFilter.java:131) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:37) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595) Referer : https://crowd.luminis.net/openidserver/secure/profile/viewidentity.action Build Information : Version : 1.1.2 (Build:#185 - Sep 03, 2007) Memory Information : Total Memory : 33 MB Free Memory : 9 MB Used Memory : 24 MB Request Information : - Request URL : http://localhost:8095/openidserver/500.jsp - Scheme : http - Server : localhost - Port : 8095 - URI : /openidserver/500.jsp - Context Path : /openidserver - - Servlet Path : /500.jsp - - Path Info : null - - Query String : Request Attributes : - javax.servlet.forward.request_uri : /openidserver/secure/admin/viewoptions.action - javax.servlet.forward.context_path : /openidserver - javax.servlet.forward.servlet_path : /secure/admin/viewoptions.action - javax.servlet.forward.path_info : /500.jsp - javax.servlet.error.servlet_name : default - crowd.token_key : fdX4H3OhmmwuRzm8bsOZYA00 - javax.servlet.error.message : - javax.servlet.error.exception : javax.servlet.ServletException: Hibernate operation: could not execute query; bad SQL grammar [select this_.ID as ID22_0_, this_.NAME as NAME22_0_, this_.VALUE as VALUE22_0_ from SERVERPROPERTY this_ where this_.NAME=?]; nested exception is java.sql.SQLException: Table not found in statement [select this_.ID as ID22_0_, this_.NAME as NAME22_0_, this_.VALUE as VALUE22_0_ from SERVERPROPERTY this_ where this_.NAME=?] - webwork.valueStack : com.opensymphony.xwork.util.OgnlValueStack@3f0e71 - javax.servlet.error.request_uri : /openidserver/secure/admin/viewoptions.action - __cleanup_counter : 0 - javax.servlet.error.status_code : 500 - com.atlassian.crowd.integration.http.VerifyTokenFilter.FILTER_RUN : true - __sitemesh__filterapplied : true - sessioninview.FILTERED : true

    Atlassian JIRA | 9 years ago | Ronald Spierenburg
    javax.servlet.ServletException: Hibernate operation: could not execute query; bad SQL grammar [select this_.ID as ID22_0_, this_.NAME as NAME22_0_, this_.VALUE as VALUE22_0_ from SERVERPROPERTY this_ where this_.NAME=?]; nested exception is java.sql.SQLException: Table not found in statement [select this_.ID as ID22_0_, this_.NAME as NAME22_0_, this_.VALUE as VALUE22_0_ from SERVERPROPERTY this_ where this_.NAME=?]
  6. 0

    [CWD-1073] Suppress transaction rolled back servlet exceptions on LDAP-related errors - Atlassian JIRA

    atlassian.com | 1 year ago
    javax.servlet.ServletException: Transaction rolled back because it has been marked as rollback-only

    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. javax.servlet.ServletException

      could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query

      at com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction()
    2. WebWork
      FilterDispatcher.doFilter
      1. com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(DispatcherUtils.java:284)
      2. com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:202)
      2 frames
    3. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      2 frames
    4. Sitemesh
      PageFilter.doFilter
      1. com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118)
      2. com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52)
      2 frames
    5. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      2 frames
    6. Hibernate
      OpenSessionInViewFilter.doFilterInternal
      1. org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
      1 frame
    7. Spring
      OncePerRequestFilter.doFilter
      1. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)
      1 frame
    8. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      2 frames
    9. WebWork
      ActionContextCleanUp.doFilter
      1. com.opensymphony.webwork.dispatcher.ActionContextCleanUp.doFilter(ActionContextCleanUp.java:88)
      1 frame
    10. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      2 frames
    11. UrlRewriteFilter
      UrlRewriteFilter.doFilter
      1. org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:350)
      1 frame
    12. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      2 frames
    13. com.atlassian.crowd
      VerifyTokenFilter.doFilter
      1. com.atlassian.crowd.integration.http.VerifyTokenFilter.doFilter(VerifyTokenFilter.java:172)
      1 frame
    14. Spring
      DelegatingFilterProxy.doFilter
      1. org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:183)
      2. org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138)
      2 frames
    15. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      2 frames
    16. com.atlassian.core
      AbstractEncodingFilter.doFilter
      1. com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:33)
      1 frame
    17. Glassfish Core
      CoyoteAdapter.service
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
      4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
      5. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      6. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
      7. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
      8. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
      8 frames
    18. Embedded GlassFish Web
      ChannelSocket$SocketConnection.runIt
      1. org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
      2. org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
      3. org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773)
      4. org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703)
      5. org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895)
      5 frames
    19. Tomcat Util
      ThreadPool$ControlRunnable.run
      1. org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
      1 frame
    20. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:619)
      1 frame