MAVEN 编译spring boot + mybatis 出现 Error parsing Mapper XML.
来源:互联网 发布:网络直播的定义 编辑:程序博客网 时间:2024/04/28 21:45
问题描述:在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 failedorg.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 omittedCaused 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 omittedCaused 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 omittedCaused 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 omittedCaused 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 omittedCaused 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重要部分:
#mybatismybatis.mapperLocations=classpath*:**/mapper/sg_*.xml
出现异常时时以上配置,网上查找了很多,各种说法,概括起来就是:
在你的xml配置文件中出现了重复的id,或者是有多个同样的xml配置文件等等, 解决这个问题的方法是确保填写路径能正确唯一指向你的xml配置文件, 并且在你的配置文件中没用重复的id
0 0
- MAVEN 编译spring boot + mybatis 出现 Error parsing Mapper XML.
- Maven构建Spring Boot+mybatis+通用Mapper
- Error parsing Mapper XML. Cause
- java导出命令行可执行文件出现报错Error parsing SQL Mapper Configuration. Error parsing Mapper XML. Error resolving
- mybatis mapper映射文件异常error parsing Mapper XML java.util.NoSuchElementException
- spring boot集成mybatis-generator-maven-plugin和通用mapper
- mybatis 报错org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML.
- Spring boot 和 mybatis 学习笔记2--Mapper XML (静态)
- Spring Boot 中使用MyBatis Mapper方式(xml)
- SpringMVC整合Mybatis之Error parsing SQL Mapper Configuration...
- mybatis 的mapping报XML Parsing Error
- Spring Boot MyBatis 通用Mapper插件集成
- Spring Boot MyBatis 通用Mapper插件集成
- Spring Boot通过Mybatis,使用mapper接口和xml配置sql,连接数据库
- Eclipse + Maven 3.2.3 编译mybatis项目时漏掉了mapper目录的xml文件
- eclipse中maven项目编译出来,没有mybatis的mapper.xml
- ssm框架出现Error creating bean with name 'org.mybatis.spring.mapper.MapperScannerConfigurer问题
- Spring Boot + Bootstrap 出现"Failed to decode downloaded font"和"OTS parsing error: Failed to convert W
- RCTViewManger
- 1007. Maximum Subsequence Sum (25)
- PAT_1017. Queueing at Bank
- 阿里云Centos7.2搭建java开发环境 jdk tomcat mysql注意事项
- 1008 Elevator (20)
- MAVEN 编译spring boot + mybatis 出现 Error parsing Mapper XML.
- COM---类厂
- 1009. Product of Polynomials (25)
- java中实现多态的机制是什么?
- 微信小程序发布一个月,世界并没有什么不同
- 发现一个比较好的库: com.google.common.base
- AsyncHttp使用的一些坑
- 1012. The Best Rank (25)
- [BZOJ1036][ZJOI2008]树的统计Count(树链剖分)