Yuvraj, I'd be happy to train you one on one on how to use iBATIS. Feel free to contact me and i can provide you my billable rate. However, your best bet is to read the manual first. It is located at http://ibatis.apache.org/docs/java/pdf/iBATIS-SqlMaps-2_en.pdf. If you have questions after you read it. Please feel free to post here and ask.
Thanks, Brandon Goodin On 9/21/07, Yuvraj Shinde <[EMAIL PROTECTED]> wrote: > > How to use a selectKey In insert ? > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > Of Larry Meadors > Sent: Friday, September 21, 2007 9:36 PM > To: user-java@ibatis.apache.org > Subject: Re: insert always returning null (urgent ) > > The insert method does not return the inserted object, it returns the > result of your selectKey element. > > If you don't use a selectKey element, insert will return null. > > Larry > > > On 9/21/07, Yuvraj Shinde <[EMAIL PROTECTED]> wrote: > > > > > > > > > > Hi all > > > > > > > > I am using insert query. it is always returning a null value. how to > get > > the value of inserted object? > > > > > > > > Following is mine insert statement > > > > > > > > <insert id="LIMNAME_INSERT" > > > parameterClass="com.sungard.energy.zainet.shared.business.domain.Limname > DTO" > > > > > > > insert into LIMNAME (AUDIT_ACTIVE, AUDIT_AGEN, AUDIT_AOP0, > AUDIT_ADATE0, > > AUDIT_ATIME0, > > > > AUDIT_AOP1, AUDIT_ADATE1, AUDIT_ATIME1, AUDIT_ALF, AUDIT_AOHM, > > AUDIT_ROHM, AUDIT_REFRESH, > > > > AUDIT_ZKEY, AUDIT_XKEY, AUDIT_UTIL1, AUDIT_UTIL2, LIMNAME_NAME, > > LIMNAME_DSC, LIMNAME_FILTER, > > > > LIMNAME_FILTERA, LIMNAME_FILTERB, LIMNAME_FILTERC, > LIMNAME_RUNVIEW) > > > > values (#active:DECIMAL#, #agen:DECIMAL#, #aop0:CHAR#, > > #adate0:TIMESTAMP#, > > > > #atime0:DECIMAL#, #aop1:CHAR#, #adate1:TIMESTAMP#, > #atime1:DECIMAL#, > > > > #alf:TIMESTAMP#, #aohm:TIMESTAMP#, #rohm:TIMESTAMP#, > > #refresh:DECIMAL#, > > > > #zkey:DECIMAL#, #xkey:DECIMAL#, #util1:DECIMAL#, > #util2:DECIMAL#, > > > > #limnameName:VARCHAR#, #limnameDsc:VARCHAR#, > #limnameFilter:VARCHAR#, > > > > #limnameFiltera:VARCHAR#, #limnameFilterb:VARCHAR#, > > #limnameFilterc:VARCHAR#, > > > > #limnameRunview:CHAR#) > > > > </insert> > > > > > > > > > > Regards > > > > Yuvraj > > > > Yuvraj Shinde * Senior Software Engineer - Zainet* SunGard * > Offshore > > Services * Pride Portal,CTS No 103A/5A/1A/1B Bhamburda,Senapati Bapat > Road, > > shivajinagar,Pune 411016 Tel Direct +91 20 66248045 * Main +91 20 > 66248000 * > > Fax +91 20 25606222 [EMAIL PROTECTED] * www.sungard.com > > > > > > > > > > >
