数据库异常——超出列范围

最近遇到的一个坑，我开发的项目竟然遇到了字符串过长的坑，先看下日志

十载的中牟网站建设经验，针对设计、前端、开发、售后、文案、推广等六对一服务，响应快，48小时及时工作处理。营销型网站的优势是能够根据用户设备显示端的尺寸不同，自动调整中牟建站的显示方式，使网站能够适用不同显示终端，在浏览器中调整网站的宽度，无论在任何一种浏览器上浏览网站，都能展现优雅布局与设计，从而大程度地提升浏览体验。创新互联从事“中牟网站设计”,“中牟网站推广”以来，每个客户项目都认真落实执行。

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)
9/19/2019 5:27:35 PM at com.alibaba.druid.filter.FilterAdapter.resultSet_getLong(FilterAdapter.java:1655)
9/19/2019 5:27:35 PM at com.alibaba.druid.filter.FilterChainImpl.resultSet_getLong(FilterChainImpl.java:1180)
9/19/2019 5:27:35 PM at com.alibaba.druid.filter.FilterAdapter.resultSet_getLong(FilterAdapter.java:1655)
9/19/2019 5:27:35 PM at com.alibaba.druid.filter.FilterChainImpl.resultSet_getLong(FilterChainImpl.java:1180)
9/19/2019 5:27:35 PM at org.hibernate.loader.Loader.getRow(Loader.java:1562)
9/19/2019 5:27:35 PM at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:732)
9/19/2019 5:27:35 PM at org.hibernate.loader.Loader.proce***esultSet(Loader.java:991)
9/19/2019 5:27:35 PM at org.hibernate.loader.Loader.doQuery(Loader.java:949)
9/19/2019 5:27:35 PM at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341)
9/19/2019 5:27:35 PM at org.hibernate.loader.Loader.doList(Loader.java:2692)

日志中说到数据库值过大，看的我一愣一愣的，什么鬼！一个id居然过大？？明明记得我在数据库设置的字符长度为512啊！不管了，面向谷歌运维

分享文章：数据库异常——超出列范围
本文来源：http://shouzuofang.com/article/ipcdps.html