oracle 无效的列类型: 1111

问萍2214

oracle 数据库出现
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
只需在mybatis xml 文件中 添加jdbcType 即可，原因是 插入空值时 mybatis 无法转换
<insert id="insertCustomerLog1" parameterType="com.diyicai.customer.domain.CustomerLog">  
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}  
)  
解决办法参考以下博客 谢谢奉献 http://makemyownlife.iyunv.com/blog/1610021