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}                 )      
     

 

参考：