selectKey 여러개

다중 값 select 경우에 에러 발생하는 경우
 ->
   error There is no getter for property named 'NEW_CDGRP ' in 'class java.lang.String'

selectKey에서 여러 필드를 select 할 경우,  resultType이 hashmap이어야한다.
그리고 keyProperty에 맞게 select되는 필드에 alias를 붙여줘야한다. (예 : AS NEW_CDGRP, as NEW_SORT)

<insert id="copyPrjGroupCode" parameterType="hashmap" >
    -- copyPrjGroupCode
    <selectKey resultType="hashmap" keyProperty="NEW_CDGRP ,NEW_SORT" order="BEFORE">
        SELECT
            'PJ'+ CONCAT(REPLICATE('0',4 - (LEN(MAX(SUBSTRING(NO_PRJGRP,3,LEN(NO_PRJGRP)))+1))),MAX(SUBSTRING(NO_PRJGRP,3,LEN(NO_PRJGRP))+1)) AS NEW_CDGRP
            ,MAX(SORT+1) as NEW_SORT
        FROM TEST_ORI
    </selectKey>

    INSERT INTO TEST_COPY(
    NO_PRJGRP
    ,NAME_PRJGRP
    ,SORT
    ,FL_USE
    ,CREATOR
    ,DATE_ENTRY
    ,TYPE_CATEGORY
    )VALUES(
    #{NEW_CDGRP}
    ,#{NM_GRP}
    ,#{NEW_SORT}
    ,'Y'
    ,#{CREATOR}
    ,GETDATE()
    ,#{CATEGORY}
    )
</insert>