java.lang.IllegalArgumentException: Mapped Statements collection does not conta

u010840652 2013-11-30 11:52:29 
严重: Exception occurred during processing request: 

### Error querying database.  Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for queryAllUser

### Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for queryAllUser

org.apache.ibatis.exceptions.PersistenceException: 

### Error querying database.  Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for queryAllUser

### Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for queryAllUser

	at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)

	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:107)

	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:98)

	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:94)

	at com.dao.IDao.queryAll(IDao.java:23)

	at com.action.HomeAction.login(HomeAction.java:21)

	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

	at java.lang.reflect.Method.invoke(Unknown Source)

	at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:450)

	at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:289)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:252)

	at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:256)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

	at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:167)

	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

	at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:265)

	at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)

	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

	at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:138)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

	at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:239)

	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

	at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:239)

	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

	at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:191)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

	at org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:73)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

	at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:91)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

	at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:252)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

	at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:100)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

	at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:141)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

	at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:145)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

	at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:171)

	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

	at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:161)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

	at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

	at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:193)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

	at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:189)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)

	at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54)

	at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:563)

	at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)

	at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:99)

	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)

	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)

	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)

	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)

	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)

	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)

	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)

	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)

	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041)

	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:603)

	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)

	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

	at java.lang.Thread.run(Unknown Source)

Caused by: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for queryAllUser

	at org.apache.ibatis.session.Configuration$StrictMap.get(Configuration.java:791)

	at org.apache.ibatis.session.Configuration.getMappedStatement(Configuration.java:631)

	at org.apache.ibatis.session.Configuration.getMappedStatement(Configuration.java:624)

	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:103)

	... 73 more


entity.xml
<mapper namespace="com.entity.UserMapper">

	<resultMap type="com.entity.User" id="user">

		<result property="id" column="ID" javaType="java.lang.Integer" jdbcType="INTEGER"/>

		<result property="username" column="username"/>

		<result property="password" column="password"/>

	</resultMap>

	<select id="queryAllUser" resultMap="user">

		select * from users

	</select>


dao

public List queryAll(){

		//SqlSession sqlSession = GetSqlMap.getSqlSessionFactory().openSession();

		SqlSession sqlSession = sqlSessionFactory.openSession();

		List list = new ArrayList();

		list = sqlSession.selectList("queryAllUser");

		sqlSession.close();
...全文
31181 14 打赏 收藏 转发到动态 举报
写回复
用AI写文章
14 条回复
切换为时间正序
请发表友善的回复…
发表回复
wc646112740 2016-01-20
  • 打赏
  • 举报
 回复
解决方法发一下啊，大哥！
luceas 2014-10-09
  • 打赏
  • 举报
 回复
大神,你能发下代码呀
u012767223 2014-02-28
  • 打赏
  • 举报
 回复
找到了，忘记吧mybatisConfig.xml配置文件加入sessionFactory 确实是这样的 玛德 害老子找一天了
qqZuok 2013-11-30
  • 打赏
  • 举报
 回复
javaType="java.lang.Integer" jdbcType="INTEGER" 这段代码去掉试试
u010840652 2013-11-30
  • 打赏
  • 举报
 回复
引用 3 楼 qqZuok 的回复:
[quote=引用 2 楼 u010840652 的回复:] [quote=引用 1 楼 qqZuok 的回复:] 数据库查询结果无法封装到com.entity.User。entity.xml再检测仔细点！
怎么检测仔细点，刚看mybatis还不太会用[/quote]把你的user代码和数据库表贴出来看看[/quote]
package com.entity;


public class User {
	
	private int id;
	private String username;
	private String password;
	
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
}

create table USERS
(
  id       NUMBER not null,
  username VARCHAR2(30),
  password VARCHAR2(50)
)
qqZuok 2013-11-30
  • 打赏
  • 举报
 回复
引用 2 楼 u010840652 的回复:
[quote=引用 1 楼 qqZuok 的回复:] 数据库查询结果无法封装到com.entity.User。entity.xml再检测仔细点！
怎么检测仔细点，刚看mybatis还不太会用[/quote]把你的user代码和数据库表贴出来看看
u010840652 2013-11-30
  • 打赏
  • 举报
 回复
引用 1 楼 qqZuok 的回复:
数据库查询结果无法封装到com.entity.User。entity.xml再检测仔细点！
怎么检测仔细点，刚看mybatis还不太会用
qqZuok 2013-11-30
  • 打赏
  • 举报
 回复
数据库查询结果无法封装到com.entity.User。entity.xml再检测仔细点！
u010840652 2013-11-30
  • 打赏
  • 举报
 回复
引用 7 楼 qqZuok 的回复:
Mapped Statements collection does not contain value for后面是什么类什么方法之类的： 错误原因有几种： 1、mapper.xml中没有加入namespace 2、mapper.xml中的方法和接口mapper的方法不对应 3、mapper.xml没有加入到mybatis-config.xml中(即总的配置文件)，例外：配置了mapper文件的包路径的除外 4、mapper.xml文件名和所写的mapper名称不相同。
找到了，忘记吧mybatisConfig.xml配置文件加入sessionFactory
u010840652 2013-11-30
  • 打赏
  • 举报
 回复
引用 9 楼 jackwumengfeng 的回复:
感觉是 <select id="queryAllUser" resultMap="user"> select * from users </select> 这里的user没有配置
找到了，忘记吧mybatisConfig.xml配置文件加入sessionFactory
南猿北蛰 2013-11-30
  • 打赏
  • 举报
 回复
感觉是 <select id="queryAllUser" resultMap="user"> select * from users </select> 这里的user没有配置
u010840652 2013-11-30
  • 打赏
  • 举报
 回复
引用 7 楼 qqZuok 的回复:
Mapped Statements collection does not contain value for后面是什么类什么方法之类的： 错误原因有几种： 1、mapper.xml中没有加入namespace 2、mapper.xml中的方法和接口mapper的方法不对应 3、mapper.xml没有加入到mybatis-config.xml中(即总的配置文件)，例外：配置了mapper文件的包路径的除外 4、mapper.xml文件名和所写的mapper名称不相同。
都不符合
qqZuok 2013-11-30
  • 打赏
  • 举报
 回复
Mapped Statements collection does not contain value for后面是什么类什么方法之类的： 错误原因有几种： 1、mapper.xml中没有加入namespace 2、mapper.xml中的方法和接口mapper的方法不对应 3、mapper.xml没有加入到mybatis-config.xml中(即总的配置文件)，例外：配置了mapper文件的包路径的除外 4、mapper.xml文件名和所写的mapper名称不相同。
u010840652 2013-11-30
  • 打赏
  • 举报
 回复
引用 5 楼 qqZuok 的回复:
javaType="java.lang.Integer" jdbcType="INTEGER" 这段代码去掉试试
去掉也不行，一样的异常
解决Caused by: java.lang.IllegalArgumentException: Mapped Statements collection already contains value
问题描述：Caused by: java.lang.IllegalArgumentException: Mapped Statements collection already contains value for mapper.User01Mapper.insert. please check mapper/User01Mapper.java (best guess) and ...
spring整合mybatis bug解决java.lang.IllegalArgumentException: Mapped Statements collection does not conta...
java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for com.jpj.base.dao.UserDaoI.getUserByUsername通过查找资料解决了这个bug，解决方式是在sql的xml配置里面有一个...
MyBatis的 java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for
java.lang.IllegalArgumentException 今天在使用SSM框架时，遇到了一个让我百思不得其姐的BUG，我在使用MyBatis报java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for ...
Mybatis报错：Mapped Statements collection does not contain value for
### Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for com.eastcom.linksight.ws.sql.dao.project.GdgkProvisionAlarmCheckDao.selectAlarmInfo 可能原因： ...
异常 java.lang.IllegalArgumentException: Mapped Statements collection already contains value for 解决
org.mybatis.spring.SqlSessionFactoryBean.buildSqlSessionFactory(SqlSessionFactoryBean.java:437) - Scanned package: 'com.***.entity' for aliases org.mybatis.spring.SqlSessionFactoryBean.buildSql...
Java EE

67,512

社区成员

225,880

社区内容

发帖
与我相关
我的任务
社区描述
J2EE只是Java企业应用。我们需要一个跨J2SE/WEB/EJB的微容器，保护我们的业务核心组件（中间件），以延续它的生命力，而不是依赖J2SE/J2EE版本。
社区管理员
  • Java EE
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章