mapper.xml注释引起SQLException的问题

错误的注释：

 <select id="select" resultMap="BaseResultMap" parameterType="java.lang.String">
    select * from user where name = #{name,jdbcType=VARCHAR};
 --     SELECT u.* FROM test.user u,test2.dept d WHERE u.name =  #{name,jdbcType=VARCHAR};
  </select>

  <select id="selectU" resultMap="BaseResultMap" parameterType="java.lang.String">
    select * from user where `name` = #{name,jdbcType=VARCHAR};
   /* select * from user where `name` = #{name,jdbcType=VARCHAR};*/
  </select>

注释不能用--或/*...*/

应该用 <!-- -->

 <select id="selectU" resultMap="BaseResultMap" parameterType="java.lang.String">
    select * from user where `name` = #{name,jdbcType=VARCHAR};
    <!-- select * from user where `name` = #{name,jdbcType=VARCHAR}; -->
  </select>

错误的注释就会引起一下错误！

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='name', mode=IN, javaType=class java.lang.String, jdbcType=VARCHAR, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #2 with JdbcType VARCHAR . Try setting a different JdbcType for this parameter or a different configuration property. Cause: java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1).
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1013)
	org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:897)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:634)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)