Vfrdtyky

Here is my error:

Nov 16, 2018 9:27:00 AM org.apache.catalina.core.StandardContext listenerStart

SEVERE: Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'ictinvMapper' defined in file [C:UsersRicardoworkspace3.metadata.pluginsorg.eclipse.wst.server.coretmp0wtpwebappsINTRANET4BWEB-INFclassesdohro4bintranet4bpersistenceIctinvMapper.class]: Invocation of init method failed; nested exception is java.lang.IllegalArgumentException: org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. Cause: java.lang.IllegalArgumentException: Mapped Statements collection already contains value for doh.ro4b.intranet4b.persistence.IctinvMapper.getIctinvList

    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1578)

    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:545)

    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)

    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:305)

    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)

    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:301)

    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:196)

    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:753)

    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:834)

    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:537)

    at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:446)

    at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:328)

    at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107)

    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4939)

    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5434)

    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)

    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)

    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)

    at java.util.concurrent.FutureTask.run(FutureTask.java:266)

    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

    at java.lang.Thread.run(Thread.java:745)

Caused by: java.lang.IllegalArgumentException: org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. Cause: java.lang.IllegalArgumentException: Mapped Statements collection already contains value for doh.ro4b.intranet4b.persistence.IctinvMapper.getIctinvList

    at org.mybatis.spring.mapper.MapperFactoryBean.checkDaoConfig(MapperFactoryBean.java:84)

    at org.springframework.dao.support.DaoSupport.afterPropertiesSet(DaoSupport.java:44)

    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1637)

    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1574)

    ... 21 more

Caused by: org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. Cause: java.lang.IllegalArgumentException: Mapped Statements collection already contains value for doh.ro4b.intranet4b.persistence.IctinvMapper.getIctinvList

    at org.apache.ibatis.builder.xml.XMLMapperBuilder.configurationElement(XMLMapperBuilder.java:120)

    at org.apache.ibatis.builder.xml.XMLMapperBuilder.parse(XMLMapperBuilder.java:92)

    at org.apache.ibatis.builder.annotation.MapperAnnotationBuilder.loadXmlResource(MapperAnnotationBuilder.java:167)

    at org.apache.ibatis.builder.annotation.MapperAnnotationBuilder.parse(MapperAnnotationBuilder.java:118)

    at org.apache.ibatis.binding.MapperRegistry.addMapper(MapperRegistry.java:72)

    at org.apache.ibatis.session.Configuration.addMapper(Configuration.java:671)

    at org.mybatis.spring.mapper.MapperFactoryBean.checkDaoConfig(MapperFactoryBean.java:81)

    ... 24 more

Caused by: java.lang.IllegalArgumentException: Mapped Statements collection already contains value for doh.ro4b.intranet4b.persistence.IctinvMapper.getIctinvList

    at org.apache.ibatis.session.Configuration$StrictMap.put(Configuration.java:802)

    at org.apache.ibatis.session.Configuration$StrictMap.put(Configuration.java:774)

    at org.apache.ibatis.session.Configuration.addMappedStatement(Configuration.java:598)

    at org.apache.ibatis.builder.MapperBuilderAssistant.addMappedStatement(MapperBuilderAssistant.java:300)

    at org.apache.ibatis.builder.xml.XMLStatementBuilder.parseStatementNode(XMLStatementBuilder.java:109)

    at org.apache.ibatis.builder.xml.XMLMapperBuilder.buildStatementFromContext(XMLMapperBuilder.java:135)

    at org.apache.ibatis.builder.xml.XMLMapperBuilder.buildStatementFromContext(XMLMapperBuilder.java:128)

    at org.apache.ibatis.builder.xml.XMLMapperBuilder.configurationElement(XMLMapperBuilder.java:118)

    ... 30 more

this is my interface:
usually the id in the xml and in the interface are the same.

package doh.ro4b.intranet4b.persistence;



import java.util.List;



import doh.ro4b.intranet4b.domain.Ictinv;



public interface IctinvMapper {



    public List<Ictinv> getIctinvList (Ictinv ictinv);



    public int getTotalRowCountIctinv ();



    public void addIctinv (Ictinv ictinv);



    public Ictinv viewIctinv (int ictinv_seqno);



    public int modifyIctinv (Ictinv ictinv);



    public int deleteIctinv (int ictinv_seqno);



}

this is my xml mapper:

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" 

"http://mybatis.org/dtd/mybatis-3-mapper.dtd">



<mapper namespace="doh.ro4b.intranet4b.persistence.IctinvMapper">



    <select id="getIctinvList" parameterType="Ictinv" resultType="Ictinv">

        SELECT *

        FROM tbl_ictinv

        ORDER BY ictinv_seqno ASC

        <!-- LIMIT #{startRowNo}, #{rowCountPerPage} -->

    </select>



    <select id="getTotalRowCountIctinv" parameterType="Ictinv"

        resultType="int">

        SELECT COUNT(ictinv_seqno)

        FROM tbl_ictinv

    </select>

if I remove the Insert and Update tagging, no error appears
notice that i dont use same id name

    <insert id="addIctinv" parameterType="Ictinv">

        INSERT INTO 

        tbl_ictinv

        (ictinv_seqno,

        eqdetail_seqno,

        ictinv_macaddr,

        ictinv_year,

        ictinv_propno,

        ictinv_unitval,

        equom_seqno,

        ictinv_qtypropcard,

        ictinv_qtyphyscount,

        ictinv_respname,

        ictinv_assignname,

        eqstat_seqno,

        ictinv_acccode,

        ictinv_audit,

        ictinv_date)



        VALUES (#{ictinv_seqno},

        #{eqdetail_seqno},

        #{ictinv_macaddr},

        #{ictinv_year},

        #{ictinv_propno},

        #{ictinv_unitval},

        #{equom_seqno},

        #{ictinv_qtypropcard},

        #{ictinv_qtyphyscount},

        #{ictinv_respname},

        #{ictinv_assignname},

        #{eqstat_seqno},

        #{ictinv_acccode},

        #{ictinv_audit},

        #{ictinv_date})

    </insert>



    <select id="viewIctinv" parameterType="int" resultType="Ictinv">

        SELECT *

        FROM tbl_ictinv

        WHERE ictinv_seqno = #{ictinv_seqno}

    </select>



    <update id="modifyIctinv" parameterType="Ictinv">

        UPDATE 

        tbl_ictinv

        SET

        ictinv_seqno = #{ictinv_seqno},

        eqdetail_seqno = #{eqdetail_seqno},

        ictinv_macaddr = #{ictinv_macaddr},

        ictinv_year = #{ictinv_year},

        ictinv_propno = #{ictinv_propno},

        ictinv_unitval = #{ictinv_unitval},

        equom_seqno = #{equom_seqno},

        ictinv_qtypropcard = #{ictinv_qtypropcard},

        ictinv_qtyphyscount = #{ictinv_qtyphyscount},

        ictinv_respname = #{ictinv_respname},

        ictinv_assignname = #{ictinv_assignname},

        eqstat_seqno = #{eqstat_seqno},

        ictinv_acccode = #{ictinv_acccode},

        ictinv_audit = #{ictinv_audit},

        ictinv_date = #{ictinv_date}

        WHERE ictinv_seqno = #{ictinv_seqno}

    </update>



    <delete id="deleteIctinv" parameterType="Ictinv">

        DELETE

        FROM tbl_ictinv

        WHERE ictinv_seqno = #{ictinv_seqno}

    </delete>

</mapper>

Note: if I remove the Insert and Update tagging, it doesn't have errors. What will be the best solution?