javax.servlet.ServletException: StatementCallback; bad SQL grammar [SELECT username, passwd, (SELECT pe.string_val FROM os_propertyentry pe WHERE pe.entity_name='OSUser_user' AND pe.entity_id = osu.id AND pe.entity_key = 'email') AS email, (SELECT pe.string_val FROM os_propertyentry pe WHERE pe.entity_name='OSUser_user' AND pe.entity_id = osu.id AND pe.entity_key = 'fullName') AS fullname FROM os_user osu]; nested exception is java.sql.SQLException: Table 'confluence.os_propertyentry' doesn't exist

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Atlassian JIRA by Justen Stepka [Atlassian], 1 year ago
os_propertyentry pe WHERE pe.entity_name='OSUser_user' AND pe.entity_id = osu.id AND pe.entity_key = 'fullName') AS fullname FROM os_user osu]; nested exception is java.sql.SQLException: Table 'confluence.os_propertyentry' doesn't exist
via Atlassian JIRA by Justen Stepka [Atlassian], 1 year ago
os_propertyentry pe WHERE pe.entity_name='OSUser_user' AND pe.entity_id = osu.id AND pe.entity_key = 'fullName') AS fullname FROM os_user osu]; nested exception is java.sql.SQLException: Table 'confluence.os_propertyentry' doesn't exist
via Atlassian JIRA by Donna McGahan [Atlassian], 1 year ago
Transaction rolled back because it has been marked as rollback-only
via Atlassian JIRA by Donna McGahan [Atlassian], 1 year ago
Transaction rolled back because it has been marked as rollback-only
via atlassian.com by Unknown author, 2 years ago
via Atlassian JIRA by Donna McGahan [Atlassian], 1 year ago
Transaction rolled back because it has been marked as rollback-only
javax.servlet.ServletException: StatementCallback; bad SQL grammar [SELECT username, passwd, (SELECT pe.string_val FROM os_propertyentry pe WHERE pe.entity_name='OSUser_user' AND pe.entity_id = osu.id AND pe.entity_key = 'email') AS email, (SELECT pe.string_val FROM os_propertyentry pe WHERE pe.entity_name='OSUser_user' AND pe.entity_id = osu.id AND pe.entity_key = 'fullName') AS fullname FROM os_user osu]; nested exception is java.sql.SQLException: Table 'confluence.os_propertyentry' doesn't exist
at com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(DispatcherUtils.java:284)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at com.atlassian.crowd.integration.http.VerifyTokenFilter.doFilter(VerifyTokenFilter.java:152)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at com.atlassian.core.filters.gzip.GzipFilter.doFilter(GzipFilter.java:55)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:33)
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.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:754)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:684)
at java.lang.Thread.run(Thread.java:595)

Users with the same issue

You are the first who have seen this exception.

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.