HTTP Status 500 -
jeebbs3 修改帖子时如标题太长,会报500错误,同时会把update 语句也一并带出来,很不友好
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; SQL [update BBS_TOPIC set TITLE=?, CREATE_TIME=?, LAST_TIME=?, SORT_TIME=?, VIEW_COUNT=?, REPLY_COUNT=?, TOP_LEVEL=?, PRIME_LEVEL=?, STYLE_BOLD=?, STYLE_ITALIC=?, STYLE_COLOR=?, STYLE_TIME=?, OUTER_URL=?, STATUS=?, IS_AFFIX=?, moderator_reply=?, HAVA_REPLY=?, ALLAY_REPLY=?, HAS_SOFAED=?, FIRST_POST_ID=?, site_id=?, FORUM_ID=?, LAST_POST_ID=?, creater_id=?, replyer_id=?, TYPE_ID=? where TOPIC_ID=?]; nested exception is org.hibernate.exception.DataException: Could not execute JDBC batch update
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:656)
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:560)
javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
com.jeecms.common.web.ProcessTimeFilter.doFilter(ProcessTimeFilter.java:38)
root cause
org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; SQL [update BBS_TOPIC set TITLE=?, CREATE_TIME=?, LAST_TIME=?, SORT_TIME=?, VIEW_COUNT=?, REPLY_COUNT=?, TOP_LEVEL=?, PRIME_LEVEL=?, STYLE_BOLD=?, STYLE_ITALIC=?, STYLE_COLOR=?, STYLE_TIME=?, OUTER_URL=?, STATUS=?, IS_AFFIX=?, moderator_reply=?, HAVA_REPLY=?, ALLAY_REPLY=?, HAS_SOFAED=?, FIRST_POST_ID=?, site_id=?, FORUM_ID=?, LAST_POST_ID=?, creater_id=?, replyer_id=?, TYPE_ID=? where TOPIC_ID=?]; nested exception is org.hibernate.exception.DataException: Could not execute JDBC batch update
org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:642)
org.springframework.orm.hibernate3.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:793)
org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:664)
org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:754)
org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:723) |
|