mybatis mysql insert 空值_mybatis插入语句空值没有设置jdbcType报错

Exception in thread "main" org.springframework.jdbc.UncategorizedSQLException: Error setting null for parameter #6 with JdbcType OTHER . Try setting a different JdbcType for this parameter or a different jdbcTypeForNull configuration property. Cause: java.sql.SQLException: 无效的列类型: 1111

; uncategorized SQLException for SQL []; SQL state [99999]; error code [17004]; 无效的列类型: 1111; nested exception is java.sql.SQLException: 无效的列类型: 1111

需要在插入语句中设置jdbcType

如下

insert into customer_log

(

ID,

CUSTOMER_SERVICE_USER_NAME,

user_name ,

CONTENT,

LOG_FIRST_TYPE,

STATUS,

LINKED_ID,

FEE,

ACCOUNT_FIRST_TYPE,

ACCOUNT_SECOND_TYPE,

ACCOUNT_THIRD_TYPE,

LOG_SECOND_TYPE,

LOG_IP,

MEMO

)

values

(

seq_customer_log.nextval ,

#{customerServiceUserName,jdbcType=VARCHAR} ,

#{username,jdbcType=VARCHAR},

#{content,jdbcType=VARCHAR},

#{logFirstType,jdbcType=NUMERIC},

#{status,jdbcType=NUMERIC},

#{linkedId,jdbcType=VARCHAR},

#{fee,jdbcType=NUMERIC},

#{accountFirstType,jdbcType=NUMERIC},

#{accountSecondType,jdbcType=NUMERIC},

#{accountThirdType,jdbcType=NUMERIC},

#{logSecondType,jdbcType=NUMERIC},

#{logIp,jdbcType=VARCHAR},

#{memo,jdbcType=VARCHAR}

)