org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='pwd', mode=IN, javaType=class java.lang.Object, jdbcType=null, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #7 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #7 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: ERROR, parser: syntax error at or near "?" at character 518
时间: 2023-09-28 19:06:05 浏览: 50
这是一个 MyBatis 的异常,其中包含了一个 TypeException。异常信息显示设置了一个无效的参数。可能是因为该参数在映射时没有设置正确的 jdbcType,导致 MyBatis 无法将该参数传递给数据库。另外,异常信息中还包含了一个语法错误,可能是 SQL 语句中的问题。建议检查 SQL 语句中的参数是否正确设置,并且检查语法是否正确。
相关问题
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping:
org.mybatis.spring.MyBatisSystemException是MyBatis框架中的一个异常类,通常是由于MyBatis执行SQL语句时出现了异常导致的。在这个异常信息中,还包含了一个嵌套的异常org.apache.ibatis.type.TypeException,它是由于MyBatis在设置参数映射时出现了异常导致的。具体来说,这个异常信息中的错误提示是"Error setting non null for parameter #2 with JdbcType null",意思是在设置第二个参数时出现了错误,因为JdbcType为null。这个错误通常是由于MyBatis无法正确地将Java对象映射到数据库中的数据类型导致的。解决这个问题的方法是检查MyBatis语句中的参数映射是否正确,特别是检查JdbcType是否正确设置。此外,还可以尝试将MyBatis语句中的注释去掉,因为有时注释会影响参数映射的正确性。
nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.
nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
Error querying database. Cause: org.apache.ibatis.executor.ExecutorException: A query was run and no Result Maps were found for the Mapped Statement 'com.example.mapper.UserMapper.getUserById'. It's likely that neither a Result Type nor a Result Map was specified.
Cause: org.apache.ibatis.executor.ExecutorException: A query was run and no Result Maps were found for the Mapped Statement 'com.example.mapper.UserMapper.getUserById'. It's likely that neither a Result Type nor a Result Map was specified.
This exception is thrown when there is an issue with executing a query using MyBatis framework. In this case, the nested exception is org.apache.ibatis.exceptions.PersistenceException, which indicates that there was an error querying the database.
The specific error message states that no Result Maps were found for the Mapped Statement 'com.example.mapper.UserMapper.getUserById'. This means that either a Result Type or a Result Map was not specified for the query.
To resolve this issue, you need to make sure that the appropriate Result Type or Result Map is specified for the query in the MyBatis mapping file (XML) or in the annotation-based configuration.