数据库不寻常——超出列范围
发布时间：2022-03-24 22:11:10 所属栏目：MySql教程 来源：互联网
导读：最近遇到的一个坑，我开发的项目竟然遇到了字符串过长的坑，先看下日志 9/19/2019 5:27:35 org.springframework.beans.BeanInstantiationException: Failed to instantiate : Constructor threw exception; nested exception is org.springframework.dao.Dat
|
最近遇到的一个坑，我开发的项目竟然遇到了字符串过长的坑，先看下日志 9/19/2019 5:27:35 org.springframework.beans.BeanInstantiationException: Failed to instantiate : Constructor threw exception; nested exception is org.springframework.dao.DataIntegrityViolationException: could not execute query; SQL [select business0_.id as id119, business0_.b_id as b_id219, business0_.branch as branch419, business0_.description as descript419, business0_.jhi_level as jhi_leve519, business0_.name as name619, business0_.parent_id as parent_i819, business0_.tag as tag719 from business business0_]; nested exception is org.hibernate.exception.DataException: could not execute query 9/19/2019 5:27:35 PMCaused by: java.sql.SQLException: Out of range value for column 'parent_i819' : value 9/19/2019 5:27:35 PM at org.mariadb.jdbc.internal.com.read.resultset.rowprotocol.TextRowProtocol.getInternalLong(TextRowProtocol.java:312) 9/19/2019 5:27:35 PM at org.mariadb.jdbc.internal.com.read.resultset.SelectResultSet.getLong(SelectResultSet.java:1004) 9/19/2019 5:27:35 PM at org.mariadb.jdbc.internal.com.read.resultset.SelectResultSet.getLong(SelectResultSet.java:996) 9/19/2019 5:27:35 PM at com.alibaba.druid.filter.FilterChainImpl.resultSet_getLong(FilterChainImpl.java:1184) 日志中说到数据库值过大，看的我一愣一愣的，什么鬼！一个id居然过大？？明明记得我在数据库设置的字符长度为512啊！  （编辑：财气旺网 - 财气网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
站长推荐