Mybatis常见错误

Mybatis技术学习，更多知识请访问https://www.itkc8.com

1.   

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.jdbc.UncategorizedSQLException: Error setting null parameter.  Most JDBC drivers require that the JdbcType must be specified for all nullable parameters. Cause: java.sql.SQLException: 无效的列类型
; uncategorized SQLException for SQL []; SQL state [null]; error code [17004]; 无效的列类型; nested exception is java.sql.SQLException: 无效的列类型
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:886)
	org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:790)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

在向oracle插入数据时，mybatis3报Error setting null parameter. Most JDBC drivers require that the JdbcType must be specified for all nullable parameters，是由于参数出现了null值,对于Mybatis,如果进行操作的时候,没有指定jdbcType类型的参数,mybatis默认jdbcType.OTHER导致,给参数加上jdbcType可解决(注意大小写)

http://code.google.com/p/mybatis/issues/detail?id=224&q=Error%20setting%20null%20parameter&colspec=ID

1. <insert id="insertAccountError" statementType="PREPARED"  
2.     parameterType="AccountError">  
3.     INSERT INTO t_acctreg_accounterror(createdate,acctno, errorinfo)  
4.     VALUES(#{createdate,jdbcType=DATE},#{acctno,jdbcType=VARCHAR},#{errorinfo,jdbcType=VARCHAR})  
5. </insert>

 

Mybatis技术学习，更多知识请访问https://www.itkc8.com