HTTP Status 500 - org.springframework.dao.DataIntegrityViolationException: could not execute query; nested exception is org.hibernate.exception.DataException: could not execute query


type Exception report

message org.springframework.dao.DataIntegrityViolationException: could not execute query; nested exception is org.hibernate.exception.DataException: could not execute query

description The server encountered an internal error that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: org.springframework.dao.DataIntegrityViolationException: could not execute query; nested exception is org.hibernate.exception.DataException: could not execute query
	org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535)
	org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:433)
	org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
	org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
	org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
	org.tuckey.web.filters.urlrewrite.NormalRewrittenUrl.doRewrite(NormalRewrittenUrl.java:195)
	org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:159)
	org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:141)
	org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:90)
	org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:406)
	com.magtech.filter.XssFilter.doFilter(XssFilter.java:57)
	com.lyt.util.web.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:44)
	com.lyt.util.filter.JournalIDFilter.doFilter(JournalIDFilter.java:146)
	com.lyt.util.filter.ReadRequestRefererFilter.doFilter(ReadRequestRefererFilter.java:32)

root cause

org.springframework.dao.DataIntegrityViolationException: could not execute query; nested exception is org.hibernate.exception.DataException: could not execute query
	org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:639)
	org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
	org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424)
	org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339)
	com.wkxt.Cited.dao.hibernate.ArticleCitedDaoImpl.listArticleCited(ArticleCitedDaoImpl.java:84)
	com.wkxt.Cited.ArticleCitedServiceImpl$8.doInTransaction(ArticleCitedServiceImpl.java:164)
	org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128)
	com.wkxt.Cited.ArticleCitedServiceImpl.listArticleCited(ArticleCitedServiceImpl.java:161)
	com.wkxt.article.web.action.ShowBeiyincishuListAction.execute(ShowBeiyincishuListAction.java:56)
	org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
	org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
	org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
	org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
	org.tuckey.web.filters.urlrewrite.NormalRewrittenUrl.doRewrite(NormalRewrittenUrl.java:195)
	org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:159)
	org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:141)
	org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:90)
	org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:406)
	com.magtech.filter.XssFilter.doFilter(XssFilter.java:57)
	com.lyt.util.web.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:44)
	com.lyt.util.filter.JournalIDFilter.doFilter(JournalIDFilter.java:146)
	com.lyt.util.filter.ReadRequestRefererFilter.doFilter(ReadRequestRefererFilter.java:32)

root cause

org.hibernate.exception.DataException: could not execute query
	org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:75)
	org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
	org.hibernate.loader.Loader.doList(Loader.java:2150)
	org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2026)
	org.hibernate.loader.Loader.list(Loader.java:2021)
	org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:369)
	org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:296)
	org.hibernate.impl.SessionImpl.list(SessionImpl.java:992)
	org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
	com.wkxt.Cited.dao.hibernate.ArticleCitedDaoImpl$2.doInHibernate(ArticleCitedDaoImpl.java:95)
	org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419)
	org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339)
	com.wkxt.Cited.dao.hibernate.ArticleCitedDaoImpl.listArticleCited(ArticleCitedDaoImpl.java:84)
	com.wkxt.Cited.ArticleCitedServiceImpl$8.doInTransaction(ArticleCitedServiceImpl.java:164)
	org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128)
	com.wkxt.Cited.ArticleCitedServiceImpl.listArticleCited(ArticleCitedServiceImpl.java:161)
	com.wkxt.article.web.action.ShowBeiyincishuListAction.execute(ShowBeiyincishuListAction.java:56)
	org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
	org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
	org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
	org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
	org.tuckey.web.filters.urlrewrite.NormalRewrittenUrl.doRewrite(NormalRewrittenUrl.java:195)
	org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:159)
	org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:141)
	org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:90)
	org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:406)
	com.magtech.filter.XssFilter.doFilter(XssFilter.java:57)
	com.lyt.util.web.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:44)
	com.lyt.util.filter.JournalIDFilter.doFilter(JournalIDFilter.java:146)
	com.lyt.util.filter.ReadRequestRefererFilter.doFilter(ReadRequestRefererFilter.java:32)

root cause

java.sql.SQLException: Only dates between January 1, 1753 and December 31, 9999 are accepted.
	net.sourceforge.jtds.jdbc.DateTime.packDate(DateTime.java:300)
	net.sourceforge.jtds.jdbc.DateTime.<init>(DateTime.java:121)
	net.sourceforge.jtds.jdbc.JtdsPreparedStatement.setParameter(JtdsPreparedStatement.java:361)
	net.sourceforge.jtds.jdbc.JtdsPreparedStatement.setTimestamp(JtdsPreparedStatement.java:757)
	org.apache.commons.dbcp.DelegatingPreparedStatement.setTimestamp(DelegatingPreparedStatement.java:143)
	org.hibernate.type.TimestampType.set(TimestampType.java:45)
	org.hibernate.type.NullableType.nullSafeSet(NullableType.java:85)
	org.hibernate.type.NullableType.nullSafeSet(NullableType.java:63)
	org.hibernate.loader.Loader.bindPositionalParameters(Loader.java:1514)
	org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1576)
	org.hibernate.loader.Loader.doQuery(Loader.java:661)
	org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:223)
	org.hibernate.loader.Loader.doList(Loader.java:2147)
	org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2026)
	org.hibernate.loader.Loader.list(Loader.java:2021)
	org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:369)
	org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:296)
	org.hibernate.impl.SessionImpl.list(SessionImpl.java:992)
	org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
	com.wkxt.Cited.dao.hibernate.ArticleCitedDaoImpl$2.doInHibernate(ArticleCitedDaoImpl.java:95)
	org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419)
	org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339)
	com.wkxt.Cited.dao.hibernate.ArticleCitedDaoImpl.listArticleCited(ArticleCitedDaoImpl.java:84)
	com.wkxt.Cited.ArticleCitedServiceImpl$8.doInTransaction(ArticleCitedServiceImpl.java:164)
	org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128)
	com.wkxt.Cited.ArticleCitedServiceImpl.listArticleCited(ArticleCitedServiceImpl.java:161)
	com.wkxt.article.web.action.ShowBeiyincishuListAction.execute(ShowBeiyincishuListAction.java:56)
	org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
	org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
	org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
	org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
	org.tuckey.web.filters.urlrewrite.NormalRewrittenUrl.doRewrite(NormalRewrittenUrl.java:195)
	org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:159)
	org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:141)
	org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:90)
	org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:406)
	com.magtech.filter.XssFilter.doFilter(XssFilter.java:57)
	com.lyt.util.web.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:44)
	com.lyt.util.filter.JournalIDFilter.doFilter(JournalIDFilter.java:146)
	com.lyt.util.filter.ReadRequestRefererFilter.doFilter(ReadRequestRefererFilter.java:32)

note The full stack trace of the root cause is available in the Apache Tomcat/6.0.48 logs.


Apache Tomcat/6.0.48