[Error Note] MyBatis SQLException: Invalid column type: 1111,

[Error Note] MyBatis SQLException: Invalid column type: 1111,

Problem description:

Org. springframework. jdbc. uncategorizedSQLException: Error setting null for parameter #1 with JdbcType OTHER. try setting a different JdbcType for this parameter or a different jdbcTypeForNull configuration property. cause: java. SQL. SQLException: Invalid column type: 1111

Problem Analysis:

This problem occurs because we did not specify the parameter type when writing SQL in the xml file. When we pass a null value, the program cannot automatically match according to the input parameter type, but can only match to the OTHER. If this parameter is required, it will run incorrectly because of inconsistent types.

Solution:

Add the type, for example, jdbcType = VARCHAR, jdbcType = NUMERIC ......, modify the input parameter code: # {param, jdbcType = specific type}, instead of # {param}

Suggestion:

It is best to display the specified parameter type to develop a good coding habit and avoid unnecessary exceptions.