Tag Archives: org.springframework.dao.DataIntegrityViolationException

[Solved] org.springframework.dao.DataIntegrityViolationException: Error attempting to get column…

error

dao.DataIntegrityViolationException: Error attempting to get column 'owner_name' from result set.  Cause: java.sql.SQLDataException: Cannot determine value type from string '大老板'

reason:

Database field does not match entity class field type

If union is used in the code, each SQL field in the union must correspond one by one. When the corresponding data type is wrong, the above exception will be reported