Hi Sundar and Larry, Really appreciate you taking out time and replying but my question still stands unanswered .
My question is the select key returns the generated sequence number in case of insert (that I know) ,so if I use the parameters class field as value to keyProperty attribute will that be set to in my parameters class's particular field i.e in my case generatedSequenceId_0 or will it be returned simply as an Integer object so in my code do I need to first call the getter method for generatedSequenceId_0 and then call type cast back to Integer Object and then call.intvalue on that object or what....... All I want is generated sequence to be available in java code. sqlMap.startTransaction(); Object o = sqlMap.insert(a, newRecord); Myobject mo = (MyObject)0; Mo.getgeneratedSequenceId_0().intvalue(); sqlMap.startBatch(); Plsss help me I am confused. Eagerly Looking forward to response. Regards Rahul Saluja ________________________________ From: Sundar Sankar [mailto:[email protected]] Sent: Thursday, February 12, 2009 9:42 PM To: [email protected] Subject: Re: What does Insert method return Hi Rahul check this website out http://ibatis.apache.org/docs/java/user/com/ibatis/sqlmap/client/SqlMapClient.html. It seems to say that it will return the number of rows inserted. Though I understand you have no test bed but I would still suggest you some how test it with a rollback enabled and see if the actual object or any other variety results do come back. I am not sure if you have spring in you app, But if you do, enabling a unit test is a piece of cake in Spring 2.5 + -Sundar On Thu, Feb 12, 2009 at 8:25 AM, Rahul Saluja <[email protected]<mailto:[email protected]>> wrote: Hello Everyone, Can anyone tell me what exactly does sqlmapclient.insert method return I know it returns an object but does it returns the object of selectkey means say in following example <selectKey keyProperty="generatedSequenceId_0" resultClass="int"> SELECT currval('MSCPerfCntrTrunk_seq') </selectKey> Does it return an Integer Object containing an sequence value generated by my insert statement or does it return the actual Object which was just inserted with the generatedSequenceId_0 field assigned the generated sequence number. Eagerly Looking forward to your response. Regards Rahul Saluja The information contained in this e-mail is private & confidential and may also be legally privileged. If you are not the intended recipient, please notify us, preferably by e-mail, and do not read, copy or disclose the contents of this message to anyone. The information contained in this e-mail is private & confidential and may also be legally privileged. If you are not the intended recipient, please notify us, preferably by e-mail, and do not read, copy or disclose the contents of this message to anyone.
