What db is that? Using "select NVL(max(PRTCPNT_ID)+1,1)userId from PARTICIPANT" is a profoundly bad idea.
Larry On 3/10/06, Krishnamoorthi, Sruthi (Raytheon) <[EMAIL PROTECTED]> wrote: > How to use that select key to tell if my values are inserted or not. > <insert id="insertCCUser" parameterClass="user"> > INSERT INTO > PARTICIPANT(PRTCPNT_ID,GIVEN_NM,MIDDLE_NM,FAMILY_NM,NAME_LINE_ONE_TX, > > CITIZENSHIP,STREET_LINE_ONE_TX,STREET_LINE_TWO_TX, > > CITY_NM,GEOGRAPHIC_REGION_CD,COUNTRY_CD,POSTAL_CD,PRIMARY_TELEPHONE_NO,PRIMARY_EMAIL_ADDRESS_TX,PASSWORD_TX, > > LAST_MODIFIED_USER_ID,LAST_MODIFIED_TS) > VALUES((select NVL(max(PRTCPNT_ID)+1,1)userId from PARTICIPANT), > > #fname#,#mname#,#lname#,#fname#,#citizenShip#,#street1#,#street2#,#city#,#state#,#country#,#postalCode#,#phone#,#email#,#password#,'US1234',SYSDATE) > </insert> > > Where would I use it here and how > > Thanks, > Sruthi Krishnamoorthi > 703-562-9732(Work) > 537 A - (Raytheon) Location > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf > Of Larry Meadors > Sent: Friday, March 10, 2006 12:58 PM > To: [email protected] > Subject: Re: Urgent help required > > > I think you only get a value back if you use selectKey. > > Larry > > > On 3/10/06, Krishnamoorthi, Sruthi (Raytheon) > <[EMAIL PROTECTED]> wrote: > > > > This is throwing an exception because > > > > > > Integer test = (Integer)sqlMap.insert(qryId,usr); > > > > System.out.println("Return value from Insert"+test); id displaying Null > > value: > > But a record is getting inserted in Database. //For sure > > How to confirm that my record got inserted. > > > > > > Thanks, > > Sruthi Krishnamoorthi > > 703-562-9732(Work) > > 537 A - (Raytheon) Location > > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Sent: Friday, March 10, 2006 12:52 PM > > To: [email protected] > > Subject: Re: Urgent help required > > Importance: High > > > > Just use > > > > > > Integer rows = ((Integer)sqlMap.insert("insertProduct", > > product)).intValue(); > > > > > > if you are using Java 1.5 > > > > > > int rows = (Integer)sqlMap.insert("insertProduct", > > product); > > > > > > Nathan > > > > > > > > > > > > On Mar 10, 2006, at 10:41 AM, Krishnamoorthi, Sruthi (Raytheon) wrote: > > > > > > > > > > The docs says > > > > int rows = sqlMap.insert ("insertProduct", product); > > > > returns a int value > > > > > > > > When I code it ,the return value is object. I am not able to get the int > > return value. Please help me out. > > > > > > Thanks, > > Sruthi Krishnamoorthi > > 703-562-9732(Work) > > 537 A - (Raytheon) Location > > > > > > > > >
