sumeetdesaeee 0 Newbie Poster

I want to retrieve the autogenerated primary key after inserting a record in database.I am using IBatis for my database connectivity.
Please review my xml code and tell whether it is correct or not.
Also, please tell me how can I retrive that value in my java code..

<insert id="insertCourse" parameterClass="lmexCourse">

        insert into lmex_course
        (lms_id , title, lable,
        description,course_number,
        status,default_credits, org_id,
        list_of_topics , list_of_prerequisite,
        data_source,
        ims_sourced_id,lms_course_id,created_by,created_date,last_updated )
        values (#lmsId# ,
        #title#, #lable#,
        #description#,
        #courseNumber#,
        #status#,
        #defaultCredits#, #orgId#,
        #listOfTopics#,
        #listOfPrerequisite#,
        #dataSource#,
        #imsSourcedId#,#lmsCourseId#,#accessorId#,CURRENT_TIMESTAMP,CURRENT_TIMESTAMP)
        <selectKey resultClass="int" keyProperty="courseId">
            select
            last_insert_id() as
            courseId
        </selectKey>
    </insert>