oracle无效列的列类型,oracle 无效的列类型: 1111
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 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.iteye.com/blog/1610021
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 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.iteye.com/blog/1610021