Get the App
SLTechnology News&Howtos  ›  Database  › 

Database exception-out of column range

Shulou Source: shulou.com Published: 2022-06-01 05:03:23 11月02日 Update

Recently encountered a pit, my development project actually encountered a long string of the pit, first take a look at the log

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

5:27:35 PMCaused by: java.sql.SQLException: Out of range value for column 'parent_i819': value

9, 9, 19, 20, 9, 5:27:35 PM at org.mariadb.jdbc.internal.com.read.resultset.rowprotocol.TextRowProtocol.getInternalLong (TextRowProtocol.java:312)

9, 9, 19, 20, 9, 5:27:35 PM at org.mariadb.jdbc.internal.com.read.resultset.SelectResultSet.getLong (SelectResultSet.java:1004)

9, 9, 19, 20, 9, 5:27:35 PM at org.mariadb.jdbc.internal.com.read.resultset.SelectResultSet.getLong (SelectResultSet.java:996)

9, 9, 19, 20, 9, 5:27:35 PM at com.alibaba.druid.filter.FilterChainImpl.resultSet_getLong (FilterChainImpl.java:1184)

9, 9, 19, 20, 9, 5:27:35 PM at com.alibaba.druid.filter.FilterAdapter.resultSet_getLong (FilterAdapter.java:1655)

9, 9, 19, 20, 9, 5:27:35 PM at com.alibaba.druid.filter.FilterChainImpl.resultSet_getLong (FilterChainImpl.java:1180)

9, 9, 19, 20, 9, 5:27:35 PM at com.alibaba.druid.filter.FilterAdapter.resultSet_getLong (FilterAdapter.java:1655)

9, 9, 19, 20, 9, 5:27:35 PM at com.alibaba.druid.filter.FilterChainImpl.resultSet_getLong (FilterChainImpl.java:1180)

9, 9, 19, 20, 9, 5:27:35 PM at org.hibernate.loader.Loader.getRow (Loader.java:1562)

9, 9, 19, 20, 9, 5:27:35 PM at org.hibernate.loader.Loader.getRowFromResultSet (Loader.java:732)

9, 9, 19, 20, 9, 5:27:35 PM at org.hibernate.loader.Loader.proce***esultSet (Loader.java:991)

9, 9, 19, 20, 9, 5:27:35 PM at org.hibernate.loader.Loader.doQuery (Loader.java:949)

9, 9, 19, 20, 9, 5:27:35 PM at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections (Loader.java:341)

9, 9, 19, 20, 9, 5:27:35 PM at org.hibernate.loader.Loader.doList (Loader.java:2692)

The log said that the value of the database is too large, I am in a daze, what the devil! An id is too big. I clearly remember that the character length I set in the database is 512! Anyway, it's for Google operators.

Tags: Data database character log string length project development scope Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Huawei MariaDB vpn Redmi Shulou Information