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.