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

今天药忘吃喽~ 2021-11-26 22:32 1252阅读 0赞

# 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

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMDQyNTk1_size_16_color_FFFFFF_t_70][]

百度：

> ## 参考:[原因及解决：java.sql.SQLException: 无效的列类型: 1111][java.sql.SQLException_ _ 1111] ##

改：

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMDQyNTk1_size_16_color_FFFFFF_t_70]: /images/20211126/409bae21c6084decb2d24352c5c0913f.png
[java.sql.SQLException_ _ 1111]: https://www.cnblogs.com/trojane/p/9964001.html