mybatis报错：org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exception

爱被打了一巴掌 2022-05-16 00:38 881阅读 0赞

错误信息如下：

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:   
\#\#\# Error querying database.  Cause: java.lang.UnsupportedOperationException  
\#\#\# The error may exist in file \[D:\\A\_01\_Open Source\\upload\\GiteeMy\\RuoYi\\target\\classes\\mybatis\\system\\MenuMapper.xml\]  
\#\#\# The error may involve com.ruoyi.project.system.menu.mapper.MenuMapper.selectDeptMap  
\#\#\# The error occurred while handling results  
\#\#\# SQL: SELECT seed\_dept\_id FROM sys\_dept\_map WHERE dept\_id = ?  
\#\#\# Cause: java.lang.UnsupportedOperationException

接口配置：

/**
         * 获取当前登录用户数据权限
         * @param userId
         * @return
         */
        public List<?> selectDeptMap(Long userId);

mapper.xml配置：

<select id="selectDeptMap" parameterType="Long" resultType="List">
    	 	SELECT seed_dept_id FROM sys_dept_map WHERE dept_id = #{value} 
    	 	
    	</select>

在查询这个SQL时出现以下错误：

![70][]

大致意思就是设置的参数有问题。

问题原因：

原因就在于mapper.xml的resultType代表的是List中的元素类型，而不应该是List本身，

所以修改mapper.xml文件为：

<select id="selectDeptMap" parameterType="Long" resultType="Long">
    	 	SELECT seed_dept_id FROM sys_dept_map WHERE dept_id = #{value} 
    	 	
    	</select>

[70]: /images/20220516/3abbd12953ee46578adaeb0b8a8b2398.png

mybatis报错：org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exception

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关程序报错: nested exception is org.apache.ibatis.exceptions.TooManyResultsException:Expected one result

相关 pageHelper报错sql语句错误，nested exception is org.springframework.jdbc.BadSqlGrammarException

相关 Request processing failed； nested exception is org.springframework.jdbc.BadSqlGrammarException:报错

相关 MyBatis批量更新报错org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.bindin

相关 Mybatis报错 org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding

相关【已解决】MyBatis查询数据报错 Request processing failed; nested exception is org.mybatis.spring.MyBatisSyst

相关 Request processing failed; nested exception is javax.validation.ConstraintViolationException报错

相关 mybatis报错：org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exception

相关 springboot 连接redis报错 nested exception is redis.clients.jedis.exceptions.JedisConnectionException

相关接入shiro报错：nested exception is java.lang.IllegalStateException: No TaglibFactory available