Try this..shud work...(hope CustomObjectDetails class has get and set
for 'id' property.)
<insert id="insertCustomObject"
parameterClass="com.sb.model.CustomObjectDetails">
<selectKey keyProperty="id" resultClass="int" type="pre"> >
SELECT record_id.NEXTVAL AS id FROM DUAL
</selectKey>
Insert into OBJECT
(OBJECT_ID,NAME,SINGULAR_LABEL,PLURAL_LABEL,DESCRIPTION,IS_REPORTS_ALLOW
ED,IS_ACTIVITIES_ALLOWED,
IS_NOTES_ALLOWED,IS_TRACK_CHANGES,IS_DEPLOYED,IS_STANDARD,MODIFIED_BY,OB
JECT_TYPE_ID)
values
(#id#,#objectName#,#singularLabel#,#pluralLabel#,
#description#,#reportsAllowed#,#activitiesAllowed#,#notesAllowed#,#track
Changes#,#isDeployed#,'N',1,213)
Rgds
HK
-----Original Message-----
From: felix thomas [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 12, 2007 12:26 AM
To: [email protected]
Subject: select Key not working giving error.
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 OBJECT_ID FROM DUAL
</selectKey>
insert into OBJECT
(OBJECT_ID,NAME,SINGULAR_LABEL,PLURAL_LABEL,DESCRIPTION,IS_REPORTS_ALLOW
ED,IS_ACTIVITIES_ALLOWED,
IS_NOTES_ALLOWED,IS_TRACK_CHANGES,IS_DEPLOYED,IS_STANDARD,MODIFIED_BY,OB
JECT_TYPE_ID)
values
(#ID#,#objectName#,#singularLabel#,#pluralLabel#,
#description#,#reportsAllowed#,#activitiesAllowed#,#notesAllowed#,#track
Changes#,#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/