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>