MyBatis <selectKey>를 사용하여 SEQUENCE 값을 가져오기

 

int ret = ActProjectManageService.insertActProject(freeVO);    // freeVO 에 선언된 omemNo의 type이 String

 

<insert id="insertActRedOrganMem" useGeneratedKeys="true" keyProperty="omemNo">
        <selectKey keyProperty="omemNo" resultType="String" order="BEFORE">
            SELECT NEXT VALUE FOR dbo.SEQ_RED_ORGAN_MEM; -- mssql
        </selectKey>
         EXEC OpenKeys
        
          INSERT INTO RED_ORGAN_MEM 
              (OMEM_NO ,    GROUP_ID)
          VALUES (#{omemNo},    #{groupId})
</insert>