HTTP Status 500 -


type Exception report

message

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

exception

org.apache.jasper.JasperException: Data truncation: Data truncated for column 'search_text' at row 1
	org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:476)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
	filters.SetCharacterEncodingFilter.doFilter(Unknown Source)

root cause

javax.servlet.ServletException: Data truncation: Data truncated for column 'search_text' at row 1
	org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:846)
	org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)
	org.apache.jsp.search.search_005fmain_jsp._jspService(search_005fmain_jsp.java:1561)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:328)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
	filters.SetCharacterEncodingFilter.doFilter(Unknown Source)

root cause

com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data truncated for column 'search_text' at row 1
	com.mysql.jdbc.SQLError.convertShowWarningsToSQLWarnings(SQLError.java:695)
	com.mysql.jdbc.MysqlIO.scanForAndThrowDataTruncation(MysqlIO.java:3321)
	com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1744)
	com.mysql.jdbc.Connection.execSQL(Connection.java:2297)
	com.mysql.jdbc.Connection.execSQL(Connection.java:2226)
	com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1812)
	com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1906)
	com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1831)
	com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1693)
	org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
	com.dizzo.health.util.TotSearch.insertSearchTxt(TotSearch.java:438)
	org.apache.jsp.search.search_005fmain_jsp._jspService(search_005fmain_jsp.java:388)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:328)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
	filters.SetCharacterEncodingFilter.doFilter(Unknown Source)

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


Apache Tomcat/5.5.23