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

最新推荐文章于 2024-06-12 23:30:27 发布
最新推荐文章于 2024-06-12 23:30:27 发布
阅读量7.7k 收藏 1
点赞数 4
分类专栏： mybatis exception springboot 文章标签： mybatis
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/mjlfto/article/details/55213560
版权
springboot 同时被 3 个专栏收录
14 篇文章 1 订阅
订阅专栏
mybatis
6 篇文章 0 订阅
订阅专栏
exception
3 篇文章 0 订阅
订阅专栏

问题描述：在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

mjlfto
关注
  • 4
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Spring Boot + MyBatis 多模块项目搭建教程.docx
11-26
《Spring Boot + MyBatis 多模块项目搭建详解》 在现代企业级应用开发中，Spring Boot 和 MyBatis 的组合被广泛采用，其简洁的配置和强大的功能深受开发者喜爱。本文将详细介绍如何在 IntelliJ IDEA 中搭建一个基于...
Springboot整合Mybatis案例以及过程中常见报错分析
CJPSR的博客
05-07 944
本篇文章是Springboot整合mybatis案例，并且做了简单的测试
Springboot Error parsing Mapper XML
xiayuccc的博客
12-03 2199
记录一下Springboot项目中的一些错误。 org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'competitionController': Unsatisfied dependency expressed through field 'competitionService'; nested exception is org.springframework.be
Spring boot+mybatis
最新发布
qq_61565477的博客
06-12 890
由于这次Arduino实验需要spring boot框架，所以记录一下项目搭建过程以上就是简单的配置过程，本文仅仅简单介绍了项目框架配置，而如果是大型项目可能不适用。
springboot出错org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location i
又是重名了
03-25 5700
今天在完成一个项目的时候出现了一个问题 当我写了很多功能的时候出现了一个问题springboot无法启动，然后我开始排查首先是看报错 . ____ _ __ _ _ /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ \\/ ___...
Error parsing Mapper XML如何解决
weixin_35756373的博客
12-28 2420
Error parsing Mapper XML 错误通常是在使用 MyBatis 框架时遇到的。这个错误的原因可能是因为你在配置 MyBatis 时，XML 映射文件中的语法有误。 要解决这个错误，你需要检查 XML 映射文件，确保它的语法是正确的。这可能包括检查标签是否正确闭合，属性是否有效，以及是否有任何语法错误。你还需要确保你在配置 MyBatis 时使用了正确的 XML 映射文件路径。 ...
解决Caused by: org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location
qq_45742039的博客
03-10 7136
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
构建maven+Spring Boot+Mybatis+redis多模块层级项目
07-08
在构建基于Maven的Spring Boot应用时，我们通常会采用多模块项目结构，以便更好地管理和组织代码。这个项目集成了Spring Boot、Mybatis、Redis以及PageHelper，它们都是Java开发中常用的工具和技术。 1. **Spring ...
Spring Boot+Mybatis宠物医院管理系统源码.zip
05-28
3. `pom.xml`：Maven项目配置文件，定义了项目依赖，包括Spring Boot、Mybatis等。 具体到业务实现，例如在宠物信息管理模块，Service层会定义处理业务逻辑的方法，如添加、修改、删除宠物信息。这些方法会调用DAO...
Spring Boot+Mybatis图书管理系统源码.zip
05-28
《Spring Boot+Mybatis图书管理系统源码》是一个基于Spring Boot框架和Mybatis持久层框架的项目，用于实现图书管理的功能。这个系统的核心是利用Spring Boot的便捷性与Mybatis的灵活性，构建一个高效、易维护的图书...
基于SpringMVC+Spring+MyBatis个人技术博客系统源码.zip
04-24
博客源码主要涉及技术包括的包括 Maven、Spring、SpringMVC、MyBatis、Redis、JSP等。后台地址：/admin 或者 /login 技术栈 SpringMVC + Spring + MyBatis 运行环境 IDEA + Tomcat8以上 + MySQL5.5以上 注意事项 ...
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 1561
Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'upHomeController': U...
SpringBoot整合其他组件时遇到的问题
weixin_42053328的博客
01-11 122
一、整合Mybatis 1、Error parsing Mapper XML 异常： Caused by: org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is ‘file [D:\Projects\EclipseProjects\springcloud\microcl...
【mapper.xml报错】
weixin_48182880的博客
04-04 1430
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...
Mapper.xml 错误查找与分析
UU小七的博客
08-04 2383
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. The XML location is ‘file
Z_timer的博客
02-05 4784
配置了mybatis-plus就不要再新建一个mybatis-plus.xml放在mapper目录下！！！直接在application.yml里配置mybatis即可，不同项目引起的错误一致但是可能内涵不一致，错误经供参考！！ 报错提示 org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'loginController' defined in file [F
运行项目时mybatis报大篇错误如 Error parsing Mapper XML. The XML location is file
热门推荐
nica_的博客
06-06 3万+
nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'file [D:\Code 检查Mapper.xml中, 下面标红色部分的地址是否正确，以及本文件中与标红地址相同的地址一起改为正确地址。（点击地址可以跳转，即为正确） <mapper namespace="com....."> <resultMa..
SpringBoot集成Mybatis可能会遇到的问题
weixin_44359369的博客
03-14 1781
SpringBoot之集成Mybatis踩的各种坑 0.概述 使用SpringBoot集成Mybatis曾经踩了各种坑,也花费了很久找解决方案才把坑填上.只是时间久了,很容易健忘,导致过一段时间就会出现,遇到同样的问题还是不得不花费时间去找解决方案.所以索性就一次把错误犯个遍,写一遍文章记录一下. 1.项目构建 使用SpringBoot搭建项目,由于是测试mybatis出现的错误,因此引入可以不引入web依赖. pom.xml <?xml version="1.0" encoding="UTF-8"?
idea + maven + +Spring Boot + mysql + MyBatis
09-14
您好！对于您提到的技术栈和框架，我可以给您一些基本的概念和关键点： 1. Idea：Idea 是一种主流的 Java 集成开发环境（IDE），由 JetBrains 公司开发。它提供了丰富的功能和工具，可以方便地进行代码编写、调试和项目管理。 2. Maven：Maven 是一个通用的项目管理工具，用于构建、发布和管理 Java 项目。它基于项目对象模型（POM）来管理项目的依赖关系、构建过程和部署配置。 3. Spring Boot：Spring Boot 是基于 Spring 框架的快速开发框架，它简化了 Spring 应用的配置和部署过程。通过自动化配置和约定大于配置的原则，Spring Boot 可以快速搭建独立运行的、生产级别的 Spring 应用。 4. MySQL：MySQL 是一种常用的开源关系型数据库管理系统，它具有稳定性、可靠性和高性能等特点。MySQL 支持多种数据存储引擎，并提供了丰富的功能和工具用于管理和操作数据库。 5. MyBatis：MyBatis 是一种持久层框架，它简化了 Java 应用与关系型数据库之间的交互过程。通过 SQL 映射文件和注解，MyBatis 可以帮助开发人员轻松地进行数据库操作，提高开发效率。 这些技术和框架的结合可以帮助开发人员更快速地开发和部署 Java Web 应用，实现数据持久化和业务逻辑的处理。如果您有具体的问题或需要进一步的信息，欢迎随时提问！

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值