Mysql query default value '' not equal java ""

Question

I'm using Mybatis query database

mysql table structure

parent_id default is ''

insert value is

Mybatis get value seem error? , parent_id should be "" instead null value?

Adrián García Campos · Accepted Answer · 2018-01-02 14:02:15Z

1

if your value in DB is empty string and in your Java object is int/Integer, MyBatis cannot cast the column. To solve this, you can either:

Modify your database to make parent_id default null
Modify your select query and change column parent_id to IF(parent_id = '', null, parent_id) as parent_id

answered Jan 2, 2018 at 14:02

4094 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1