jsp显示500错误

lmzpp lmzpp 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select this_.resCode as resCode15_3_, this_.createTime as createTime15_3_, this_.creator as creator15_3_, this_.description as descript4_15_3_, this_.lastUpdateTime as lastUpda5_15_3_, this_.lastUpdater as lastUpda6_15_3_, this_.optimisticLock as optimist7_15_3_, this_.remark as remark15_3_, this_.resIcon as resIcon15_3_, this_.resName as resName15_3_, this_.resUrl as resUrl15_3_, this_.sequence as sequence15_3_, this_1_.parentFunctionNo as parentFu2_16_3_, this_2_.functionNo as functionNo17_3_, case when this_1_.resCode is not null then 1 when this_2_.resCode is not null then 2 when this_.resCode is not null then 0 end as clazz_3_, roles2_.resources_resCode as resources2_5_, role3_.roleCode as roles1_5_, role3_.roleCode as roleCode13_0_, role3_.createTime as createTime13_0_, role3_.creator as creator13_0_, role3_.description as descript4_13_0_, role3_.lastUpdateTime as lastUpda5_13_0_, role3_.lastUpdater as lastUpda6_13_0_, role3_.optimisticLock as optimist7_13_0_, role3_.remark as remark13_0_, role3_.roleName as roleName13_0_, function4_.resCode as resCode15_1_, function4_1_.createTime as createTime15_1_, function4_1_.creator as creator15_1_, function4_1_.description as descript4_15_1_, function4_1_.lastUpdateTime as lastUpda5_15_1_, function4_1_.lastUpdater as lastUpda6_15_1_, function4_1_.optimisticLock as optimist7_15_1_, function4_1_.remark as remark15_1_, function4_1_.resIcon as resIcon15_1_, function4_1_.resName as resName15_1_, function4_1_.resUrl as resUrl15_1_, function4_1_.sequence as sequence15_1_, function4_.parentFunctionNo as parentFu2_16_1_, function5_.resCode as resCode15_2_, function5_1_.createTime as createTime15_2_, function5_1_.creator as creator15_2_, function5_1_.description as descript4_15_2_, function5_1_.lastUpdateTime as lastUpda5_15_2_, function5_1_.lastUpdater as lastUpda6_15_2_, function5_1_.optimisticLock as optimist7_15_2_, function5_1_.remark as remark15_2_, function5_1_.resIcon as resIcon15_2_, function5_1_.resName as resName15_2_, function5_1_.resUrl as resUrl15_2_, function5_1_.sequence as sequence15_2_, function5_.parentFunctionNo as parentFu2_16_2_ from Resource this_ left outer join Function this_1_ on this_.resCode=this_1_.resCode left outer join Operation this_2_ on this_.resCode=this_2_.resCode left outer join Role_Resource roles2_ on this_.resCode=roles2_.resources_resCode left outer join Role role3_ on roles2_.roles_roleCode=role3_.roleCode left outer join Function function4_ on this_1_.parentFunctionNo=function4_.resCode left outer join Resource function4_1_ on function4_.resCode=function4_1_.resCode left outer join Function function5_ on this_2_.functionNo=function5_.resCode left outer join Resource function5_1_ on function5_.resCode=function5_1_.resCode where this_.resUrl=?]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query

org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:356)

org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:356)
org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:150)
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)


root cause

org.hibernate.exception.SQLGrammarException: could not execute query
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
org.hibernate.loader.Loader.doList(Loader.java:2235)
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129)
org.hibernate.loader.Loader.list(Loader.java:2124)
org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:117)
org.hibernate.impl.SessionImpl.list(SessionImpl.java:1532)
org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)
org.springframework.orm.hibernate3.HibernateTemplate$36.doInHibernate(HibernateTemplate.java:1056)
org.springframework.orm.hibernate3.HibernateTemplate$36.doInHibernate(HibernateTemplate.java:1)
org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)
org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:1046)
org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:1039)
com.sinba.common.dao.BaseDAOImplHibernate.findUniqueBy(BaseDAOImplHibernate.java:297)
com.sinba.common.security.service.ResourceSecurityMetaDataSource.getAttributes(ResourceSecurityMetaDataSource.java:49)
org.springframework.security.access.intercept.AbstractSecurityInterceptor.beforeInvocation(AbstractSecurityInterceptor.java:172)
org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:98)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:356)
org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:95)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:356)
Proxy$VirtualFilterChain.doFilter(FilterChainProxy.java:356)
org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:106)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:356)
org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:80)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:356)
org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:150)
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)


root cause

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'student11.resource' doesn't exist
sun.reflect.GeneratedConstructorAccessor34.newInstance(Unknown Source)
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
java.lang.reflect.Constructor.newInstance(Constructor.java:513)
com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
com.mysql.jdbc.Util.getInstance(Util.java:381)
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
org.hibernate.loader.Loader.getResultSet(Loader.java:1810)
org.hibernate.loader.Loader.doQuery(Loader.java:695)
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:257)
org.hibernate.loader.Loader.doList(Loader.java:2232)
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129)
org.hibernate.loader.Loader.list(Loader.java:2124)
org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:117)
org.hibernate.impl.SessionImpl.list(SessionImpl.java:1532)
org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)
org.springframework.orm.hibernate3.HibernateTemplate$36.doInHibernate(HibernateTemplate.java:1056)
org.springframework.orm.hibernate3.HibernateTemplate$36.doInHibernate(HibernateTemplate.java:1)
org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)
org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:1046)
org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:1039)
com.sinba.common.dao.BaseDAOImplHibernate.findUniqueBy(BaseDAOImplHibernate.java:297)


org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:356)
org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:150)
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)

...全文

相关推荐

在web.xml中设置错误处理页面.docx

请在web.xml文件中使用元素为整个web应用程序设置错误处理页面。已知:处理状态码为404的页面为404.jsp,处理状态码为500的页面为500.jsp。

爱喝柠檬水的小崽子

JSP中内建exception对象时出现500错误的解决方法

本文实例讲述了JSP中内建exception对象时出现500错误的解决方法。分享给大家供大家参考,具体如下: 尝试使用JSP的内建exception对象,写了下面三个文件。思路很简单,文件index若提交字串为空,则get抛出异常,交由error.jsp处理。但实际却不能正常运行,会出现IE的500错误页面。环境为Tomcat 5.5,IE6.0。 在sun的论坛上有人贴出了原因,是IE的某个设置。Tomcat5.0以后的版本error page在处理时会返回error code 500。而IE得到code 500后会检查该页面的长度,当长度低于某个值时,它会用自己默认的500出错页面来代替制

weixin_38699613

HTTP 500错误是什么意思?

HTTP 500错误是什么意思?

weixin_38722164

web工程中404/500错误页面配置+404页面模板

web工程中404/500错误页面配置+404页面模板

vip_wst

servlet/jsp自定义错误页面

这种写法在ie浏览器下有问题. <error-page> <error-code>404 </error-code> <location>/error404.jsp </location> </error-page> <error-page> <error-code>500 </error-code> <location>/error500.jsp </location> </error-page>

jsjzy123123
评论 23
收藏 已收藏
分享
返回顶部
lmzpp
Java EE 67,535 成员 225,843 内容