'2.587426955E9' in column '2' is outside valid range for the datatype INTEGER.
来源:互联网 发布:淘宝开虚拟网店流程 编辑:程序博客网 时间:2024/06/09 04:39
今天在展现人员信息时遇到这个错误,'2.587426955E9' in column '2' is outside valid range for the datatype INTEGER.
在网上查了,说是超出了INTEGER的最大长度,后经实践检验后并非如此。
原因:
因为这里是使用mybatis做的,这个sql的resultMap的返回值是一个实体类
于是想到了与该实体类中该属性的类型有关
果然,它原来的类型是int
修改为String后问题解决。
总结:
就是说你数据库,是int,你在定义POJO的时候要定义为String类型
因为如过你定义为int的话,它去查询的时候会默认给你转换为科学记数法
所以就会报如上的错误了。
1 0
- '2.587426955E9' in column '2' is outside valid range for the datatype INTEGER.
- '4.294967295E9' in column '7' is outside valid range for the datatype INTEGER.
- ERROR: '1.838150639E10' in column '6' is outside valid range for the datatype INTEGER.
- Mybatis 调试 range for the datatype
- Dynamics CRM2016 The value of field on record of type entity is outside the valid range问题的解决方法
- The stack `XdataStack`()is outside the stack range
- In company code XX, the number range 01 is missing for the year XXXX
- The method setStatus(int) in the type Goods is not applicable for the arguments (Integer)
- MySQL - Entity : The value for column 'IsPrimaryKey' in table 'TableDetails' is DBNull
- iOS7 BUG:Your account is not valid for use in the ***Store...
- The dollar ($) prefixed field '$inc' in '$inc' is not valid for storage
- Typically this problem occurs when you are putting in a data that is too long for the column. In t
- C++ 使用oci访问数据库出现“Column: 2<DOUBLE>, datatype in operator <</>>: CHAR”
- The run destination''''is not valid for Running the scheme
- What Column Number Is It in the EXCEL?
- The First Column in a Table Is Always Left-Aligned
- Detected Maven Version: 3.0.2 is not in the allowed range 3.0.3.
- Detected Maven Version: 3.0.2 is not in the allowed range 3.0.3
- 多线程
- C 基础练习
- USACO 2.3Money Systems(简单DP)
- 模仿常用框架Builder初始化数据,如何优雅地装逼
- Android XPosed框架 hook 中的IllegalAccessError: Class ref in pre-verified class resolved to unexpected
- '2.587426955E9' in column '2' is outside valid range for the datatype INTEGER.
- LSDyna在土木工程静力问题中的应用
- GNU m4
- 初认LoadCursor
- 软总线组件代码说明
- @Controller和@RestController的区别?
- Home work
- cmd中文乱码
- Java I/O 系统中的 File 类详解