java.sql.SQLException: 无效的列类型: 错误解析

向右看齐 2022-05-16 06:21 350阅读 0赞

八月 16, 2018 8:47:40 下午 org.apache.catalina.core.StandardWrapperValve invoke
    SEVERE: Servlet.service() for servlet [DispatcherServlet] in context with path [/RPCExamSystem] threw exception [Request processing failed; nested exception is org.hibernate.exception.GenericJDBCException: 无效的列类型: 16] with root cause
    java.sql.SQLException: 无效的列类型: 16
    	at oracle.jdbc.driver.OracleStatement.getInternalType(OracleStatement.java:3963)
    	at oracle.jdbc.driver.OraclePreparedStatement.setNullCritical(OraclePreparedStatement.java:4596)
    	at oracle.jdbc.driver.OraclePreparedStatement.setNull(OraclePreparedStatement.java:4578)
    	at oracle.jdbc.driver.OraclePreparedStatementWrapper.setNull(OraclePreparedStatementWrapper.java:1285)
    	at org.apache.commons.dbcp.DelegatingPreparedStatement.setNull(DelegatingPreparedStatement.java:108)
    	at org.apache.commons.dbcp.DelegatingPreparedStatement.setNull(DelegatingPreparedStatement.java:108)
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    	at java.lang.reflect.Method.invoke(Method.java:601)
    	at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122)
    	at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
    	at $Proxy47.setNull(Unknown Source)

如图：出现此类错误

报java.sql.SQLException: 无效的列类型: 16 的错误。

重点在于

# **at $Proxy47.setNull(Unknown Source)** #

这个错误

表示为数据库中表的关联性很强，此表不允许一些字段为空，

所以检查插入时的实体是否有不允许为空的，或者尝试将实体内的所有属性全部添加，

可将问题解决