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=?]

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web4324

  • via Atlassian JIRA by Ronald Spierenburg, 11 months ago
    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
  • via Atlassian JIRA by Ronald Spierenburg, 1 year ago
    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
  • javax.servlet.jsp.JspException: org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: could not execute query; bad SQL grammar \[select distinct roleassoci2\_.person\_id as col\_0\_0\_, roleassoci2\_.project\_id as col\_1\_0
  • 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)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    You’re the first here who have seen this exception.