困扰了一晚上，早上还是找不出原因，求支援

Question

com.mysql.jdbc.exceptions.jdbc4.MySQLDataException: '2.83320140424E11' in column '5' is outside valid range for the datatype INTEGER.
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
java.lang.reflect.Constructor.newInstance(Constructor.java:513)
com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
com.mysql.jdbc.Util.getInstance(Util.java:386)
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1025)
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
com.mysql.jdbc.ResultSetImpl.throwRangeException(ResultSetImpl.java:7682)
com.mysql.jdbc.ResultSetImpl.parseIntAsDouble(ResultSetImpl.java:6911)
com.mysql.jdbc.ResultSetImpl.getInt(ResultSetImpl.java:2705)
com.mysql.jdbc.ResultSetImpl.getInt(ResultSetImpl.java:2816)
org.hibernate.type.IntegerType.get(IntegerType.java:28)
org.hibernate.type.NullableType.nullSafeGet(NullableType.java:163)
org.hibernate.type.NullableType.nullSafeGet(NullableType.java:154)
org.hibernate.type.ManyToOneType.hydrate(ManyToOneType.java:103)
org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2091)
org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1380)
org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1308)
org.hibernate.loader.Loader.getRow(Loader.java:1206)
org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:580)
org.hibernate.loader.Loader.doQuery(Loader.java:701)
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
org.hibernate.loader.Loader.doList(Loader.java:2217)
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2108)
org.hibernate.loader.Loader.list(Loader.java:2103)
org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:340)
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
org.hibernate.impl.SessionImpl.list(SessionImpl.java:1122)
org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
HMservice.problemService.displayProblem(problemService.java:24)
HM.action.HMAction.displayProblem(HMAction.java:197)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:453)
com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:292)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:255)
org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:256)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:176)
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:265)
org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:138)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:236)
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:236)
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:190)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:75)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:90)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:243)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:100)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:141)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:145)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:171)
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:176)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:192)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:187)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54)
org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:511)
org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:91)

Answer 1

配置文件如下：
<hibernate-mapping>
    <class name="HM.model.memberproblem" table="memberproblem">
        <id name="id" type="java.lang.Integer">
            <column name="id" />
            <generator class="native"></generator>
        </id>
        <property name="name" type="java.lang.String">
            <column name="name" length="20" not-null="true" />
        </property>
        <property name="time" type="java.lang.String">
            <column name="time" length="20" />
        </property>
         <property name="problem" type="java.lang.String">
            <column name="problem" length="100" />
        </property>
        <many-to-one name="person" class="HM.model.person" fetch="select" insert="true" update="true">
            <column name="ic" length="20" />
        </many-to-one>
    </class>
<hibernate-mapping>
    <class name="HM.model.person" table="person" >
        <id name="id" type="java.lang.Integer">
            <column name="id" />
            <generator class="native"></generator>
        </id>
        <many-to-one name="family" class="HM.model.family" fetch="select" insert="true" update="true" >
            <column name="hostid" length="20" />
        </many-to-one>
        <property name="name" type="java.lang.String">
            <column name="name" length="20" not-null="true" />
        </property>
        <property name="sex" type="java.lang.String">
            <column name="sex" length="10" />
        </property>
        <property name="age" type="java.lang.Integer">
            <column name="age" />
        </property>
        <property name="ic" type="java.lang.String">
            <column name="ic" length="20" />
        </property>
        <property name="birth" type="java.lang.String">
            <column name="birth" length="20" not-null="true" />
        </property>
        <property name="phone" type="java.lang.String">
            <column name="phone" length="20" not-null="true" />
        </property>
        <property name="nation" type="java.lang.String">
            <column name="nation" length="10" not-null="true" />
        </property>
        <property name="marry" type="java.lang.String">
            <column name="marry" length="10" not-null="true" />
        </property>
        <property name="address" type="java.lang.String">
            <column name="address" length="100" not-null="true" />
        </property>
        <set name="memberproblems" fetch="select" cascade="all" lazy="false" inverse="true">
            <key>
                <column name="ic" length="20"/>
            </key>
            <one-to-many class="HM.model.memberproblem" />
        </set>
    </class>
</hibernate-mapping>简单的查询语句：Session session = HibernateSessionFactory.getSession();
Query query = session.createQuery("from memberproblem"); 字数超了分批补上

Answer 2

'2.83320140424E11' in column '5' is outside valid range for the datatype INTEGER.
超出范围了

Answer 3

 '2.83320140424E11' in column '5' is outside valid range for the datatype INTEGER.超出范围了/ '2.83320140424E11' --------〉     INTEGER.

Answer 4

它说第五列超出范围，第五列是ic，String类型，不应该啊。而且数据可以在数据库里保存的。

Answer 5

<many-to-one name="person" class="HM.model.person" fetch="select" insert="true" update="true">
            <column name="ic" length="20" />
        </many-to-one>
你这个是 多对一。你这个person输入的是不是超出范围了啊

Answer 6

com.mysql.jdbc.exceptions.jdbc4.MySQLDataException: '2.83320140424E11' in column '5' is outside valid range for the datatype INTEGER.

Answer 7

应该是你接收到数据后的转换的类型长度不够。如果是Integer肯定超出！

Answer 8

<many-to-one name="person" class="HM.model.person" fetch="select" insert="true" update="true">
            <column name="ic" length="20" />
        </many-to-one>
    </class>
<hibernate-mapping>
    <class name="HM.model.person" table="person" >
        <id name="id" type="java.lang.Integer">
            <column name="id" />
            <generator class="native"></generator>
        </id>
有什么不明白的，配个外键，外键找主键，主键是数字，所以要把值放到many-to-one实体的id里去，放不进去。

Answer 9

 <many-to-one name="person" class="HM.model.person" fetch="select" insert="true" update="true">
            <column name="ic" length="20" />
        </many-to-one>
person你没指定列默认用id对应你memberproblem的ic列,类型是错的