MyBatis异常——"Caused by: java.sql.SQLException: 无效的列类型: 1111"

JDK1.8+Tomcat8.5+SSM+Eclipse  

2019-07-23 09:33:23 DEBUG [org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator:281]- Unable to translate SQLException with Error code '17004', will now try the fallback translator
2019-07-23 09:33:23 DEBUG [org.springframework.jdbc.support.SQLStateSQLExceptionTranslator:96]- Extracted SQL state class '99' from value '99999'
2019-07-23 09:33:27 DEBUG [org.mybatis.spring.SqlSessionUtils$SqlSessionSynchronization:287]- Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1970a233]
2019-07-23 09:33:27 DEBUG [org.mybatis.spring.SqlSessionUtils$SqlSessionSynchronization:292]- Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1970a233]
2019-07-23 09:33:27 DEBUG [org.springframework.transaction.support.AbstractPlatformTransactionManager:847]- Initiating transaction rollback
2019-07-23 09:33:27 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager:284]- Rolling back JDBC transaction on Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@62f7496c]
2019-07-23 09:33:27 DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager:327]- Releasing JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@62f7496c] after transaction
2019-07-23 09:33:27 DEBUG [org.springframework.jdbc.datasource.DataSourceUtils:327]- Returning JDBC Connection to DataSource
2019-07-23 09:33:27 DEBUG [com.alibaba.druid.pool.PreparedStatementPool:160]- {conn-10003, pstmt-20005} exit cache
2019-07-23 09:33:27 ERROR [com.lst.controller.MyzxController:166]- saveData error :
org.springframework.jdbc.UncategorizedSQLException: Error setting null for parameter #7 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
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84)
	at com.sun.proxy.$Proxy12.insert(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:240)
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:51)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:52)
	at com.sun.proxy.$Proxy51.insertByData(Unknown Source)
	at com.lst.service.MyzxService.saveData(MyzxService.java:73)
	at com.lst.service.MyzxService$$FastClassBySpringCGLIB$$9050da84.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:717)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:653)
	at com.lst.service.MyzxService$$EnhancerBySpringCGLIB$$2b53ea75.saveData(<generated>)
	at com.lst.controller.MyzxController.saveData(MyzxController.java:164)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
ache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: 无效的列类型: 1111
	at oracle.jdbc.driver.OracleStatement.getInternalType(OracleStatement.java:3900)
	at oracle.jdbc.driver.OraclePreparedStatement.setNullCritical(OraclePreparedStatement.java:4406)
	at oracle.jdbc.driver.OraclePreparedStatement.setNull(OraclePreparedStatement.java:4388)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_setNull(FilterChainImpl.java:2733)
	at com.alibaba.druid.filter.FilterAdapter.preparedStatement_setNull(FilterAdapter.java:1286)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_setNull(FilterChainImpl.java:2730)
	at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.setNull(PreparedStatementProxyImpl.java:397)
	at com.alibaba.druid.pool.DruidPooledPreparedStatement.setNull(DruidPooledPreparedStatement.java:266)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:70)
	at com.sun.proxy.$Proxy83.setNull(Unknown Source)
	at org.apache.ibatis.type.BaseTypeHandler.setParameter(BaseTypeHandler.java:43)
	at org.apache.ibatis.scripting.defaults.DefaultParameterHandler.setParameters(DefaultParameterHandler.java:81)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:358)
	... 63 more
2019-07-23 09:33:27 DEBUG [org.springframework.web.servlet.mvc.method.annotation.AbstractMessageConverterMethodProcessor:163]- Written [FAILED] as "application/json;charset=UTF-8" using [org.springframework.http.converter.json.MappingJackson2HttpMessageConverter@30179c23]
2019-07-23 09:33:27  INFO [com.lst.interceptor.LogInterceptor:57]- COMMON-LOG :/BaoAnAdmin/MyzxController/saveData postHandle start: Tue Jul 23 09:33:27 CST 2019
LoginInterceptor...postHandle

百度：

参考:原因及解决：java.sql.SQLException: 无效的列类型: 1111

改： 

<insert id="insertByData" parameterType="com.ss.model.XXX" >
  	<![CDATA[
     insert into XXX(id,monthTIME, xx, drs, lrs, lrl, sps, photo, oldid,status) 
     values(S_MYZX_ID.nextVal,#{monthtime,jdbcType=VARCHAR},#{xx,jdbcType=VARCHAR},#{drs,jdbcType=VARCHAR}
     ,#{lrs,jdbcType=VARCHAR},#{lrl,jdbcType=VARCHAR},#{sps,jdbcType=VARCHAR},#{photo,jdbcType=VARCHAR},#{oldid,jdbcType=NUMERIC},1)
  	]]>
  </insert>

<!--S_MYZX_ID是序列名,在Oracle新建New序列-->