java.sql.SQLException: '2.0100417164402E13' in column '13' is outside valid range for the datatype

Question

我在Dreamweaver里面测试的我的讨论区的主界面，不知道为什么报错了？之前是可以正常显示的，但是隔了一段时间怎么就不行了呢？下面是错误提示，说是超出了数据类型为整型的有效范围，那要怎么改呢？我用的EMS SQL Manager管理MYsql数据库 但是现在打开EMS SQL Manager2010 后打开我建的数据库却显示cannot load dynamic library libmysql.dll jsp 这是怎么回事呢 是不是和我之前用的评估版的有关系？具体怎么解决 请说的详细点 我是菜鸟 不太懂 。谢谢！！！
description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: '2.0100417164402E13' in column '13' is outside valid range for the datatype INTEGER.
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:848)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
org.apache.jsp.members.forum_jsp._jspService(org.apache.jsp.members.forum_jsp:522)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

java.sql.SQLException: '2.0100417164402E13' in column '13' is outside valid range for the datatype INTEGER.
com.mysql.jdbc.ResultSet.throwRangeException(ResultSet.java:6632)
com.mysql.jdbc.ResultSet.parseIntAsDouble(ResultSet.java:5989)
com.mysql.jdbc.ResultSet.getInt(ResultSet.java:2422)
com.mysql.jdbc.ResultSet.getObject(ResultSet.java:4118)
com.mysql.jdbc.ResultSet.getObject(ResultSet.java:4298)
org.apache.jsp.members.forum_jsp._jspService(org.apache.jsp.members.forum_jsp:420)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

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

Answer 1

你那个数据太大了

超出了MYSQL INTEGER的范围。。。不熟悉MYSQL，更改一个大一点的datatype吧

Answer 2

数据格式错误，换一个类型，或者大小，int默认11，可能存入的东西太大

Answer 3

'2.0100417164402E13' in column '13' is outside valid range for the datatype INTEGER

Answer 4

你这没有开始事务和关闭事务
当然，数据库中就不会有什么变化
在代码的上方开启事务，在代码的下方关闭事务 就行了

Answer 5

找找