HTTP Status 500-求大牛帮助

u010384595 2015-10-14 03:55:23

type Exception report

message

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

exception

org.apache.jasper.JasperException: org.springframework.dao.DataIntegrityViolationException: (Hibernate operation): data integrity violated by SQL ''; nested exception is java.sql.SQLException: Prepared or callable statement has more than 2000 parameter markers.
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:548)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:471)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:389)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:333)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
cn.com.resoft.sogims.common.AuthorizationFilter.doFilter(AuthorizationFilter.java:82)
cn.com.resoft.sogims.common.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:115)
org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:171)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

root cause

org.springframework.dao.DataIntegrityViolationException: (Hibernate operation): data integrity violated by SQL ''; nested exception is java.sql.SQLException: Prepared or callable statement has more than 2000 parameter markers.
org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:93)
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:228)
org.springframework.orm.hibernate.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:249)
org.springframework.orm.hibernate.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:231)
org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:317)
org.springframework.orm.hibernate.HibernateTemplate.executeFind(HibernateTemplate.java:293)
cn.com.resoft.sogims.publication.service.impl.PublicationQueryStatServiceImpl.queryPublishedPublication(PublicationQueryStatServiceImpl.java:2726)
sun.reflect.GeneratedMethodAccessor140.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:282)
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
$Proxy18.queryPublishedPublication(Unknown Source)
org.apache.jsp.mainIndex_jsp._jspService(mainIndex_jsp.java:353)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:433)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:389)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:333)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
cn.com.resoft.sogims.common.AuthorizationFilter.doFilter(AuthorizationFilter.java:82)
cn.com.resoft.sogims.common.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:115)
org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:171)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

root cause

java.sql.SQLException: Prepared or callable statement has more than 2000 parameter markers.
net.sourceforge.jtds.jdbc.SQLParser.parse(SQLParser.java:1139)
net.sourceforge.jtds.jdbc.SQLParser.parse(SQLParser.java:156)
net.sourceforge.jtds.jdbc.JtdsPreparedStatement.<init>(JtdsPreparedStatement.java:104)
net.sourceforge.jtds.jdbc.ConnectionJDBC2.prepareStatement(ConnectionJDBC2.java:2221)
net.sourceforge.jtds.jdbc.ConnectionJDBC2.prepareStatement(ConnectionJDBC2.java:2179)
org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:185)
org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:278)
net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:263)
net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:236)
net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:67)
net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:784)
net.sf.hibernate.loader.Loader.doQuery(Loader.java:269)
net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138)
net.sf.hibernate.loader.Loader.doList(Loader.java:1063)
net.sf.hibernate.loader.Loader.list(Loader.java:1054)
net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854)
net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1554)
net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:49)
cn.com.resoft.sogims.common.HibernateCallbackByPageImpl.doInHibernate(HibernateCallbackByPageImpl.java:144)
org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:312)
org.springframework.orm.hibernate.HibernateTemplate.executeFind(HibernateTemplate.java:293)
cn.com.resoft.sogims.publication.service.impl.PublicationQueryStatServiceImpl.queryPublishedPublication(PublicationQueryStatServiceImpl.java:2726)
sun.reflect.GeneratedMethodAccessor140.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:282)
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
$Proxy18.queryPublishedPublication(Unknown Source)
org.apache.jsp.mainIndex_jsp._jspService(mainIndex_jsp.java:353)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:433)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:389)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:333)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
cn.com.resoft.sogims.common.AuthorizationFilter.doFilter(AuthorizationFilter.java:82)
cn.com.resoft.sogims.common.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:115)
org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:171)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

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

--------------------------------------------------------------------------------

Apache Tomcat/7.0.21

...全文