ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <Sivaranjani.Ponnath...@cognizant.com>
Subject RE: select Key not working giving error.
Date Thu, 12 Jul 2007 10:16:57 GMT

U can directly use SELECT record_id.NEXTVAL AS ID  FROM DUAL in the
place if #ID#

 

________________________________

From: Jeff Butler [mailto:jeffgbutler@gmail.com] 
Sent: Thursday, July 12, 2007 3:00 PM
To: user-java@ibatis.apache.org
Subject: Re: select Key not working giving error.

 

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 <reachfelix@yahoo.co.in> 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_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/ 

 



This e-mail and any files transmitted with it are for the sole use of the intended recipient(s)
and may contain confidential and privileged information.
If you are not the intended recipient, please contact the sender by reply e-mail and destroy
all copies of the original message. 
Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of
this email or any action taken in reliance on this e-mail is strictly 
prohibited and may be unlawful.
Mime
View raw message