bug之Cannot determine value type from string ‘xxxxxx‘

问题描述

com.mysql.cj.exceptions.DataConversionException: Cannot determine value type from string 'oy7Y_5agiD4iiFffJdPC39Ov6jxw'
	at com.mysql.cj.result.AbstractNumericValueFactory.createFromBytes(AbstractNumericValueFactory.java:66) ~[mysql-connector-java-8.0.23.jar!/:8.0.23]
	at com.mysql.cj.protocol.a.MysqlTextValueDecoder.decodeByteArray(MysqlTextValueDecoder.java:143) ~[mysql-connector-java-8.0.23.jar!/:8.0.23]
	at com.mysql.cj.protocol.result.AbstractResultsetRow.decodeAndCreateReturnValue(AbstractResultsetRow.java:135) ~[mysql-connector-java-8.0.23.jar!/:8.0.23]
	at com.mysql.cj.protocol.result.AbstractResultsetRow.getValueFromBytes(AbstractResultsetRow.java:243) ~[mysql-connector-java-8.0.23.jar!/:8.0.23]
	at com.mysql.cj.protocol.a.result.ByteArrayRow.getValue(ByteArrayRow.java:91) ~[mysql-connector-java-8.0.23.jar!/:8.0.23]
	at com.mysql.cj.jdbc.result.ResultSetImpl.getObject(ResultSetImpl.java:1310) ~[mysql-connector-java-8.0.23.jar!/:8.0.23]
	at com.mysql.cj.jdbc.result.ResultSetImpl.getInt(ResultSetImpl.java:816) ~[mysql-connector-java-8.0.23.jar!/:8.0.23]
	at com.mysql.cj.jdbc.result.ResultSetImpl.getInt(ResultSetImpl.java:837) ~[mysql-connector-java-8.0.23.jar!/:8.0.23]
	at com.zaxxer.hikari.pool.HikariProxyResultSet.getInt(HikariProxyResultSet.java) ~[HikariCP-3.4.5.jar!/:na]
	at sun.reflect.GeneratedMethodAccessor158.invoke(Unknown Source) ~[na:na]

即

解决方案

实体类加上无参的构造方法
构造函数问题，是否有无参构造参数，有参构造参数是否是全部参数

参考资料

参考链接1
参考链接2