You need a property in your object to hold the generated ID. In this case,
you need getID() and setID() methods.
Jeff Butler
On 7/12/07, felix thomas <[EMAIL PROTECTED]> wrote:
hi,
I am getting the below error in iBatis 2 .
this is my sqlMap statement
<insert id="insertCustomObject"
parameterClass="com.sb.model.CustomObjectDetails">
<selectKey resultClass="int" >
SELECT record_id.NEXTVAL AS ID FROM DUAL
</selectKey>
insert into OBJECT
(OBJECT_ID,NAME,SINGULAR_LABEL,PLURAL_LABEL,DESCRIPTION,IS_REPORTS_ALLOWED,IS_ACTIVITIES_ALLOWED,
IS_NOTES_ALLOWED,IS_TRACK_CHANGES,IS_DEPLOYED,IS_STANDARD,MODIFIED_BY,OBJECT_TYPE_ID)
values
(#ID#,#objectName#,#singularLabel#,#pluralLabel#,
#description#,#reportsAllowed#,#activitiesAllowed#,#notesAllowed#,#trackChanges#,#isDeployed#,'N',1,213)
</insert>
It gives me Error saying ID element key not
identified etc.
My problem is that rest all columns are coming from
the class object, only for the insertion of column
OBJECT_ID i am getting the value from a sequence.
is this possible in sqlmaps . Can anyone help.
Regards,
Felix T
__________________________________________________________
Yahoo! India Answers: Share what you know. Learn something new
http://in.answers.yahoo.com/
