oracle database
### Cause: org.apache.ibatis.type.TypeException: Error setting null for parameter #10 with JdbcType OTHER . Try setting a different JdbcType for this parameter or a different jdbcTypeForNull configuration property. Cause: java.sql.SQLException: invalid column type of
When MyBatis inserts an empty value, you need to specify JdbcType
, because mybatis cannot convert it
In the insert
statement, add jdbcType
For example:
#{name,jdbcType=VARCHAR}