MAVEN 编译spring boot + mybatis 出现 Error parsing Mapper XML.

最新推荐文章于 2025-04-03 15:24:05 发布
最新推荐文章于 2025-04-03 15:24:05 发布
阅读量7.8k 收藏 1
点赞数 4
分类专栏： mybatis exception springboot 文章标签： mybatis
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/mjlfto/article/details/55213560
版权

问题描述：在spring boot + mybatis 在Intellij工具中能正常编译运行， 但是使用maven能编译通过， 无法正确启动，启动时出现一下异常

这里写代码片Error starting ApplicationContext. To display the auto-configuration report re-run your application with 'debug' enabled.
2017-02-15 17:39:20.961 ERROR 1638 --- [           main] o.s.boot.SpringApplication               : Application startup failed

org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'resourceUpdateInfoServer': Unsatisfied dependency expressed through field 'resourceUpdateInfoMapper'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'resourceUpdateInfoMapper' defined in URL [jar:file:/home/seengene/work/seengene/ARContentManage/target/arcontentmanage-0.0.1-SNAPSHOT.jar!/BOOT-INF/classes!/com/seengenearcontent/db/scenic/ResourceUpdateInfoMapper.class]: Unsatisfied dependency expressed through bean property 'sqlSessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [org/mybatis/spring/boot/autoconfigure/MybatisAutoConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.ibatis.session.SqlSessionFactory]: Factory method 'sqlSessionFactory' threw exception; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'URL [jar:file:arcontentmanage-0.0.1-SNAPSHOT.jar!/BOOT-INF/classes/mapper/sg_TriggerIncidentStatiticsMapper.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. Cause: java.lang.IllegalArgumentException: Result Maps collection already contains value for com.seengenearcontent.db.statitics.TriggerIncidentStatiticsMapper.sg_incident_result
    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:569) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
    at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:88) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:349) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1219) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:543) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:751) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:861) ~[spring-context-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:541) ~[spring-context-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
    at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.refresh(EmbeddedWebApplicationContext.java:122) ~[spring-boot-1.4.1.RELEASE.jar!/:1.4.1.RELEASE]
    at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:761) [spring-boot-1.4.1.RELEASE.jar!/:1.4.1.RELEASE]
    at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:371) [spring-boot-1.4.1.RELEASE.jar!/:1.4.1.RELEASE]
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:315) [spring-boot-1.4.1.RELEASE.jar!/:1.4.1.RELEASE]
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:1186) [spring-boot-1.4.1.RELEASE.jar!/:1.4.1.RELEASE]
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:1175) [spring-boot-1.4.1.RELEASE.jar!/:1.4.1.RELEASE]
    at com.seengenearcontent.ArContentManageApplication.main(ArContentManageApplication.java:58) [classes!/:0.0.1-SNAPSHOT]
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_111]
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_111]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_111]
    at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_111]
    at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48) [arcontentmanage-0.0.1-SNAPSHOT.jar:0.0.1-SNAPSHOT]
    at org.springframework.boot.loader.Launcher.launch(Launcher.java:87) [arcontentmanage-0.0.1-SNAPSHOT.jar:0.0.1-SNAPSHOT]
    at org.springframework.boot.loader.Launcher.launch(Launcher.java:50) [arcontentmanage-0.0.1-SNAPSHOT.jar:0.0.1-SNAPSHOT]
    at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:58) [arcontentmanage-0.0.1-SNAPSHOT.jar:0.0.1-SNAPSHOT]
Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'resourceUpdateInfoMapper' defined in URL [jar:file:/home/seengene/work/seengene/ARContentManage/target/arcontentmanage-0.0.1-SNAPSHOT.jar!/BOOT-INF/classes!/com/seengenearcontent/db/scenic/ResourceUpdateInfoMapper.class]: Unsatisfied dependency expressed through bean property 'sqlSessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [org/mybatis/spring/boot/autoconfigure/MybatisAutoConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.ibatis.session.SqlSessionFactory]: Factory method 'sqlSessionFactory' threw exception; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'URL [jar:file:arcontentmanage-0.0.1-SNAPSHOT.jar!/BOOT-INF/classes/mapper/sg_TriggerIncidentStatiticsMapper.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. Cause: java.lang.IllegalArgumentException: Result Maps collection already contains value for com.seengenearcontent.db.statitics.TriggerIncidentStatiticsMapper.sg_incident_result
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireByType(AbstractAutowireCapableBeanFactory.java:1312) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1204) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:543) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
    at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:207) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1128) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1056) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:566) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
    ... 27 common frames omitted
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [org/mybatis/spring/boot/autoconfigure/MybatisAutoConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.ibatis.session.SqlSessionFactory]: Factory method 'sqlSessionFactory' threw exception; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'URL [jar:file:arcontentmanage-0.0.1-SNAPSHOT.jar!/BOOT-INF/classes/mapper/sg_TriggerIncidentStatiticsMapper.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. Cause: java.lang.IllegalArgumentException: Result Maps collection already contains value for com.seengenearcontent.db.statitics.TriggerIncidentStatiticsMapper.sg_incident_result
    at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:599) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1128) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1023) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:510) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
    at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:207) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1128) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1056) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireByType(AbstractAutowireCapableBeanFactory.java:1297) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
    ... 38 common frames omitted
Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.ibatis.session.SqlSessionFactory]: Factory method 'sqlSessionFactory' threw exception; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'URL [jar:file:arcontentmanage-0.0.1-SNAPSHOT.jar!/BOOT-INF/classes/mapper/sg_TriggerIncidentStatiticsMapper.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. Cause: java.lang.IllegalArgumentException: Result Maps collection already contains value for com.seengenearcontent.db.statitics.TriggerIncidentStatiticsMapper.sg_incident_result
    at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:189) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
    at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:588) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
    ... 50 common frames omitted
Caused by: org.springframework.core.NestedIOException: Failed to parse mapping resource: 'URL [jar:file:arcontentmanage-0.0.1-SNAPSHOT.jar!/BOOT-INF/classes/mapper/sg_TriggerIncidentStatiticsMapper.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. Cause: java.lang.IllegalArgumentException: Result Maps collection already contains value for com.seengenearcontent.db.statitics.TriggerIncidentStatiticsMapper.sg_incident_result
    at org.mybatis.spring.SqlSessionFactoryBean.buildSqlSessionFactory(SqlSessionFactoryBean.java:522) ~[mybatis-spring-1.3.0.jar!/:1.3.0]
    at org.mybatis.spring.SqlSessionFactoryBean.afterPropertiesSet(SqlSessionFactoryBean.java:381) ~[mybatis-spring-1.3.0.jar!/:1.3.0]
    at org.mybatis.spring.SqlSessionFactoryBean.getObject(SqlSessionFactoryBean.java:546) ~[mybatis-spring-1.3.0.jar!/:1.3.0]
    at org.mybatis.spring.boot.autoconfigure.MybatisAutoConfiguration.sqlSessionFactory(MybatisAutoConfiguration.java:130) ~[mybatis-spring-boot-autoconfigure-1.1.1.jar!/:1.1.1]
    at org.mybatis.spring.boot.autoconfigure.MybatisAutoConfiguration$$EnhancerBySpringCGLIB$$9ab86fa9.CGLIB$sqlSessionFactory$2(<generated>) ~[mybatis-spring-boot-autoconfigure-1.1.1.jar!/:1.1.1]
    at org.mybatis.spring.boot.autoconfigure.MybatisAutoConfiguration$$EnhancerBySpringCGLIB$$9ab86fa9$$FastClassBySpringCGLIB$$a5b4cf74.invoke(<generated>) ~[mybatis-spring-boot-autoconfigure-1.1.1.jar!/:1.1.1]
    at org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228) ~[spring-core-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
    at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:356) ~[spring-context-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
    at org.mybatis.spring.boot.autoconfigure.MybatisAutoConfiguration$$EnhancerBySpringCGLIB$$9ab86fa9.sqlSessionFactory(<generated>) ~[mybatis-spring-boot-autoconfigure-1.1.1.jar!/:1.1.1]
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_111]
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_111]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_111]
    at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_111]
    at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:162) ~[spring-beans-4.3.3.RELEASE.jar!/:4.3.3.RELEASE]
    ... 51 common frames omitted
Caused by: org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. Cause: java.lang.IllegalArgumentException: Result Maps collection already contains value for com.seengenearcontent.db.statitics.TriggerIncidentStatiticsMapper.sg_incident_result
    at org.apache.ibatis.builder.xml.XMLMapperBuilder.configurationElement(XMLMapperBuilder.java:120) ~[mybatis-3.4.0.jar!/:3.4.0]
    at org.apache.ibatis.builder.xml.XMLMapperBuilder.parse(XMLMapperBuilder.java:92) ~[mybatis-3.4.0.jar!/:3.4.0]
    at org.mybatis.spring.SqlSessionFactoryBean.buildSqlSessionFactory(SqlSessionFactoryBean.java:520) ~[mybatis-spring-1.3.0.jar!/:1.3.0]
    ... 64 common frames omitted
Caused by: java.lang.IllegalArgumentException: Result Maps collection already contains value for com.seengenearcontent.db.statitics.TriggerIncidentStatiticsMapper.sg_incident_result
    at org.apache.ibatis.session.Configuration$StrictMap.put(Configuration.java:837) ~[mybatis-3.4.0.jar!/:3.4.0]
    at org.apache.ibatis.session.Configuration$StrictMap.put(Configuration.java:809) ~[mybatis-3.4.0.jar!/:3.4.0]
    at org.apache.ibatis.session.Configuration.addResultMap(Configuration.java:591) ~[mybatis-3.4.0.jar!/:3.4.0]
    at org.apache.ibatis.builder.MapperBuilderAssistant.addResultMap(MapperBuilderAssistant.java:214) ~[mybatis-3.4.0.jar!/:3.4.0]
    at org.apache.ibatis.builder.ResultMapResolver.resolve(ResultMapResolver.java:47) ~[mybatis-3.4.0.jar!/:3.4.0]
    at org.apache.ibatis.builder.xml.XMLMapperBuilder.resultMapElement(XMLMapperBuilder.java:285) ~[mybatis-3.4.0.jar!/:3.4.0]
    at org.apache.ibatis.builder.xml.XMLMapperBuilder.resultMapElement(XMLMapperBuilder.java:252) ~[mybatis-3.4.0.jar!/:3.4.0]
    at org.apache.ibatis.builder.xml.XMLMapperBuilder.resultMapElements(XMLMapperBuilder.java:244) ~[mybatis-3.4.0.jar!/:3.4.0]
    at org.apache.ibatis.builder.xml.XMLMapperBuilder.configurationElement(XMLMapperBuilder.java:116) ~[mybatis-3.4.0.jar!/:3.4.0]
    ... 66 common frames omitted

项目目录结构：
这里写图片描述

sg_TriggerIncidentStatiticsMapper.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC
        "-//mybatis.org//DTD com.example.Mapper 3.4//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace = "com.seengenearcontent.db.statitics.TriggerIncidentStatiticsMapper">
    <resultMap id = "sg_incident_result" type = "com.seengenearcontent.entity.statitics.TriggerIncidentStatitics">
        <result property = "id" column = "id"/>
        <result property = "seengene_id" column = "seengene_id"/>
        <result property = "startTime" column = "startTime"/>
        <result property = "endTime" column = "endTime"/>
        <result property = "incidentType" column = "incidentType"/>
        <result property = "endType" column = "endType"/>
        <result property = "triggerObject_id" column = "triggerObject_id"/>
        <result property = "resultType" column = "resultType"/>
        <result property = "scenic_id" column = "scenic_id"/>
    </resultMap>
    <select id = "findIncidentById" resultMap = "sg_incident_result">
        SELECT * FROM triggerIncidentStatitics_tbl where id = #{id};
    </select>
    <insert id="addIncident" parameterType="com.seengenearcontent.entity.statitics.TriggerIncidentStatitics">
        INSERT INTO triggerIncidentStatitics_tbl(seengene_id, startTime, endTime, incidentType, endType, triggerObject_id, resultType, scenic_id)
        values(#{seengene_id}, #{startTime}, #{endTime}, #{incidentType}, #{endType}, #{triggerObject_id}, #{resultType}, #{scenic_id});
    </insert>
    <delete id="deleteIncident" parameterType="int">
        DELETE FROM triggerIncidentStatitics_tbl WHERE id=#{id};
    </delete>
    <update id="updateIncident" parameterType="com.seengenearcontent.entity.statitics.TriggerIncidentStatitics">
        UPDATE triggerIncidentStatitics_tbl SET seengene_id=#{seengene_id}, startTime=#{startTime}, endTime=#{endTime}, incidentType=#{incidentType},
        endType=#{endType}, triggerObject_id=#{triggerObject_id}, resultType=#{resultType}, scenic_id=#{scenic_id} WHERE id=#{id};
    </update>
    <select id="findCountByCondition" resultType="int" parameterType="int">
        SELECT COUNT(*) FROM triggerIncidentStatitics_tbl WHERE 1 = 1
        <if test="seengene_id != 0">
           AND seengene_id = #{seengene_id}
        </if>
        <if test="startTime != 0">
            AND startTime = #{startTime}
        </if>
        <if test="endTime != 0">
            AND endTime = #{endTime}
        </if>
        <if test="incidentType != 0">
            AND inclidentType = #{incidentType}
        </if>
        <if test="endType != 0">
            AND endType = #{endType}
        </if>
        <if test="triggerObject_id != 0">
            AND triggerObject_id = #{triggerObject_id}
        </if>
        <if test="resultType != 0">
            AND resultType = #{resultType}
        </if>
        <if test="scenic_id != 0">
            AND scenic_id = #{scenic_id}
        </if>
    </select>
    <select id="findByCondition" resultMap="sg_incident_result" parameterType="com.seengenearcontent.entity.statitics.TriggerIncidentStatitics">
        SELECT * FROM triggerIncidentStatitics_tbl WHERE 1 = 1
        <if test="seengene_id != 0">
            AND seengene_id = #{seengene_id}
        </if>
        <if test="startTime != 0">
            AND startTime = #{startTime}
        </if>
        <if test="endTime != 0">
            AND endTime = #{endTime}
        </if>
        <if test="incidentType != 0">
            AND inclidentType = #{incidentType}
        </if>
        <if test="endType != 0">
            AND endType = #{endType}
        </if>
        <if test="triggerObject_id != 0">
            AND triggerObject_id = #{triggerObject_id}
        </if>
        <if test="resultType != 0">
            AND resultType = #{resultType}
        </if>
        <if test="scenic_id != 0">
            AND scenic_id = #{scenic_id}
        </if>
        ;
    </select>
</mapper>

application.properties重要部分：

#mybatis
mybatis.mapperLocations=classpath*:**/mapper/sg_*.xml

出现异常时时以上配置，网上查找了很多，各种说法，概括起来就是：
在你的xml配置文件中出现了重复的id，或者是有多个同样的xml配置文件等等， 解决这个问题的方法是确保填写路径能正确唯一指向你的xml配置文件， 并且在你的配置文件中没用重复的id

错误 Error parsing SQL Mapper Configuration. Cause: java.io.IOException: Could not find resource x.xml
yjyxw的博客
08-04 1652
今天在使用mybatis中，报错：Error parsing SQL Mapper Configuration. Cause: java.io.IOException: Could not find resource xxx ， 这个CustomerMapper.xml我放在了src目录下 而idea不会编译src目录下的.xml文件（只会编译resource下的）， 所以解决思路就是：将IDEA maven项目中src源代码下的xml等资源文件编译进classes文件夹 <bui
解决MyBatis找不到Mapper.xml
Jean·z的博客
01-26 639
所以我们手动配置资源过滤, 让它把我们 src/main/java 里面的 .properties 或.xml 文件能够被导出把它过滤开启~我们Maven项目默认默认资源文件配置应该放在resources目录下, 但是我们现在把它放在了java目录下了那个地方导不出来的!当然我们也在mybatis-config.xml核心配置文件中注册过了, 为什么控制台还是报初始化异常找不到的错误呢?很多人纳闷: 我写的和官网一模一样为什么出不来?为什么会有资源过滤问题呢?其实这就是Maven的问题。
Springboot Error parsing Mapper XML
xiayuccc的博客
12-03 2276
记录一下Springboot项目中的一些错误。 org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'competitionController': Unsatisfied dependency expressed through field 'competitionService'; nested exception is org.springframework.be
解决 Error parsing Mapper XML
weixin_46040901的博客
06-04 5695
逐步跟踪发现扫描不到类 解决方法：最好写成全路径，以免linux跑jar包扫描不到，除非在application.yml配置全局别名就能用类名 mybatis: type-aliases-package: com.kd.test.common.pojo
Spring Boot 整合mybatis
最新发布
2401_84080967的博客
04-03 1119
配置文件在实际开发中如何使用呢，接下去将通过Spring Boot整合mybatis来看配置文件如何在实际开发中被使用。
org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is ‘com/hujin
qq_52291182的博客
10-29 975
注意：springboot项目中的包名必须放到运行类的同级目录或者下级目录 运行类就是： 问题解决： 把运行类用一个包装起来，与项目的其他包是同级包 谢谢，希望对你有帮助 ...
Error parsing Mapper XML. The XML location is.......或者Could not resolve type alias
m0_52767002的博客
12-28 1697
Error parsing Mapper XML. The XML location is.......或者Could not resolve type alias
java导出命令行可执行文件出现报错Error parsing SQL Mapper Configuration. Error parsing Mapper XML. Error resolving
shulixu的博客
11-20 1507
好不容易完成了项目的大部分工作，到了激动人心的部署时刻了。然而，得知之前都是在STS的编译器环境执行的，但是服务器需要在命令行环境可执行的，所以就要导出jar包。好吧==是我无知了。。然后就愉快的开始： 在出现的界面中：选择Java-runnable jar file然后next 然后重点来了！！！ 这里一定要选第一个！！！！！把以来的包导到jar里面 否则会无情
SSM框架整合遇到的问题汇总(Spring+SpringMVC+Mybatis+PostgreSQL+Tomcat7+Maven)v.18
白衣
09-18 4804
一 问题一:mybatis生成的映射文件1 (mapper.xml)找不到： 解决办法： 二 问题二：mappingJacksonHttpMessageConverter类找不到 解决办法： 三： 问题三：jackson.core找不到 解决办法： 四 问题四：web容器找不到数据库驱动org.postgresql.Driver 解决办法：-将驱动jar包 手动放入we...
运行mybatis项目时找不到Mapper.xml配置文件
weixin_44824745的博客
07-25 4315
运行mybatis项目时找不到Mapper.xml配置文件 错误提示如下： ava.lang.ExceptionInInitializerError at priv.sehun.dao.UserMapperTest.getUserByUserCode(UserMapperTest.java:17) at sun.reflect.NativeMethodAccessorImpl.invoke0(...
mybatis错误——java.io.IOException Could not find resource comxxxxxxMapper.xml
web15185420056的博客
05-17 425
在学习Mybatis的时候，参考网上的教程进行简单demo的搭建，配置的没有问题，然后出现了下面的错误！ Exception in thread "main" java.lang.RuntimeException: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: java.io.IOException: Could not find resource com/mybati
Mapper.xml 错误查找与分析
UU小七的博客
08-04 2497
Mapper.xml 报错 org.apache.ibatis.exceptions.PersistenceException: ### Error building SqlSession. ### The error may exist in cn/itcast/mybatis/mapper/UserMapper.xml ### The error occurred while pro...
Error parsing Mapper XML如何解决
weixin_35756373的博客
12-28 2623
Error parsing Mapper XML 错误通常是在使用 MyBatis 框架时遇到的。这个错误的原因可能是因为你在配置 MyBatis 时，XML 映射文件中的语法有误。 要解决这个错误，你需要检查 XML 映射文件，确保它的语法是正确的。这可能包括检查标签是否正确闭合，属性是否有效，以及是否有任何语法错误。你还需要确保你在配置 MyBatis 时使用了正确的 XML 映射文件路径。 ...
spring项目mapper.xml中代码错误导致程序启动终止
九尾狐的yi巴的博客
11-17 776
记录一次项目启动终止的原因。 项目启动到一半就卡死了，只在警告日志里看到如下： /mybatis/capital/cap-result-mapper.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. Cause: org.apache.ibatis.builder.BuilderException: Error resolving class. Cause: o
解决Caused by: org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location
qq_45742039的博客
03-10 7352
Caused by: org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is ‘file …\mapper\SchoolMapper.xml]’. Cause: java.lang.IllegalArgumentException: Result Maps collection already contains value for com.example.management.mapp
Error parsing Mapper XML. The XML location is ‘fileorg.apache.ibatis.builder.BuilderException: Error
热门推荐
陈鱼落雁的博客
03-11 1万+
SSM整合遇到的坑 Error parsing Mapper XML. The XML location is 'fileorg.apache.ibatis.builder.BuilderException: Error java.lang.IllegalStateException: Failed to load ApplicationContext mybatis逆向工程生成mapper文件和spring整合时可能会报错 将mapper文件中的内容注释后再运行就行了
启动springboot mapper.xml 报错时
ZengYue_D的博客
11-08 1622
Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'upHomeController': U...
【mapper.xml报错】
weixin_48182880的博客
04-04 1557
HTTP状态 500 - 内部服务器错误 类型异常报告 消息Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingException: Parameter 'user_name)' not found. Available parameters are [siz...
SpringBoot集成Mybatis可能会遇到的问题
weixin_44359369的博客
03-14 1875
SpringBoot之集成Mybatis踩的各种坑 0.概述 使用SpringBoot集成Mybatis曾经踩了各种坑,也花费了很久找解决方案才把坑填上.只是时间久了,很容易健忘,导致过一段时间就会出现,遇到同样的问题还是不得不花费时间去找解决方案.所以索性就一次把错误犯个遍,写一遍文章记录一下. 1.项目构建 使用SpringBoot搭建项目,由于是测试mybatis出现的错误,因此引入可以不引入web依赖. pom.xml <?xml version="1.0" encoding="UTF-8"?
Error parsing SQL Mapper Configuration. Cause: java.io.IOException: Could not find resource com/dhee/dao/AdminDao.xml
03-15
<think>好的，我现在需要解决用户遇到的MyBatis报错问题：“Error parsing SQL Mapper Configuration. Cause: java.io.IOException: Could not find resource AdminDao.xml”。首先，我得理解这个错误的常见原因。根据用户提供的引用内容，问题通常与资源文件路径配置不正确有关。 首先，我应该检查XML文件的位置是否正确。用户提到AdminDao.xml没有被找到，这可能是因为文件没有放在正确的资源目录下。在Maven项目中，资源文件通常放在src/main/resources目录中，或者需要配置Maven来包含其他目录下的XML文件。如果用户将AdminDao.xml放在src/main/java下的某个包中，但没有在pom.xml中配置资源过滤，Maven可能不会将这些文件复制到target目录，导致运行时找不到文件。 接下来，需要确认MyBatis的配置文件是否正确引用了XML映射文件。在mybatis-config.xml中，<mappers>部分应该正确指向AdminDao.xml。如果使用包扫描或者类路径引用，路径是否正确？例如，如果使用<mapper resource="com/example/dao/AdminDao.xml"/>，必须确保路径与文件的实际位置完全匹配，包括大小写，因为有些操作系统对文件名大小写敏感。 另外，文件扩展名是否正确也很重要。用户提到的是AdminDao.xml，但有时候可能误写为其他扩展名，比如.txt或者没有扩展名，这会导致MyBatis无法识别。同时，检查XML文件内容是否有语法错误，比如未闭合的标签或格式错误，虽然此时错误提示是找不到文件，但这一步也不能完全忽略。 然后，考虑Maven的配置问题。用户可能在pom.xml中没有正确配置<build>部分来包含XML文件。例如，需要添加资源过滤配置，确保Maven在编译时将XML文件复制到target/classes目录。例如： ```xml <build> <resources> <resource> <directory>src/main/java</directory> <includes> <include>**/*.xml</include> </includes> </resource> <resource> <directory>src/main/resources</directory> </resource> </resources> </build> ``` 如果用户的XML文件放在src/main/java下的某个包中，这个配置就非常必要，否则Maven默认不会处理这些文件。 此外，清理和重新构建项目也是常见的解决方法。有时候IDE（如IntelliJ IDEA）可能没有及时同步文件，导致旧的编译结果中没有包含最新的XML文件。执行mvn clean install或重新构建项目可以解决这类问题。 还有，需要检查文件名的拼写是否正确，尤其是大小写是否匹配。例如，AdminDao.xml和admindao.xml在Linux系统下会被视为不同的文件，所以必须确保配置中的路径与实际文件名完全一致。 最后，如果用户使用的是注解而非XML配置，可能需要检查是否在接口上正确使用了@Mapper或@Select等注解，或者是否在配置中启用了Mapper接口的扫描。不过，根据错误信息，问题更可能出在XML文件本身的位置或配置上。 综上所述，解决步骤应该是：确认文件位置，检查MyBatis配置中的路径，配置Maven资源过滤，清理并重新构建项目，检查文件名大小写和扩展名，以及验证XML文件内容。如果这些步骤都正确执行，应该能够解决找不到AdminDao.xml的问题。</think>### 解决MyBatis "Could not find resource AdminDao.xml" 错误的方法 #### 1. 确认XML文件路径和位置 - **问题原因**：MyBatis默认从`src/main/resources`目录加载资源文件。若`AdminDao.xml`未放在该目录或其子目录下，会导致文件无法被识别[^2][^3]。 - **解决步骤**： - 将`AdminDao.xml`移动到`src/main/resources`目录下（例如：`src/main/resources/com/example/dao/AdminDao.xml`）。 - 若希望保留在`src/main/java`目录中，需在`pom.xml`中添加以下配置： ```xml <build> <resources> <resource> <directory>src/main/java</directory> <includes> <include>**/*.xml</include> </includes> </resource> </resources> </build> ``` #### 2. 检查MyBatis配置文件 - **问题原因**：`mybatis-config.xml`中`<mappers>`标签未正确指向XML文件[^4]。 - **解决步骤**： - 确保配置中使用**完整路径**且**大小写一致**： ```xml <mappers> <mapper resource="com/example/dao/AdminDao.xml"/> <!-- 使用斜杠分隔 --> </mappers> ``` #### 3. 验证Maven资源过滤 - **问题原因**：未配置资源过滤时，Maven会忽略非标准资源目录中的XML文件。 - **解决步骤**： - 在`pom.xml`中添加资源过滤（如步骤1所示）。 - 执行清理命令：`mvn clean install`。 #### 4. 检查文件命名和扩展名 - **问题原因**：文件名拼写错误或扩展名非`.xml`会导致加载失败[^4]。 - **解决步骤**： - 确认文件名是否为`AdminDao.xml`（注意大小写敏感）。 - 检查文件是否被错误保存为`AdminDao.xml.txt`等格式。 #### 5. 验证IDE配置 - **问题原因**：IDE缓存可能导致文件未同步到`target`目录[^3]。 - **解决步骤**： - 在IntelliJ IDEA中右键点击项目选择 **Reload Maven Project**。 - 执行 **Build → Rebuild Project**。 --- ### 示例配置修正 **原始错误配置**： ```xml <mappers> <mapper resource="com.example.dao.AdminDao.xml"/> <!-- 错误：使用点分隔路径 --> </mappers> ``` **修正后配置**： ```xml <mappers> <mapper resource="com/example/dao/AdminDao.xml"/> <!-- 正确：使用斜杠分隔 --> </mappers> ``` --- ### 相关问题 1. MyBatis如何自动扫描Mapper接口？ 2. 如何在Spring Boot中集成MyBatis并避免资源路径问题？ 3. MyBatis XML映射文件和注解方式有什么区别？
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值