On 3/10/06, = Krishnamoorthi, Sruthi (Raytheon) <Sruthi.Krishnamoorthi@uspto.gov> wrote:

How to use that select key to te= ll if my values are inserted or not.
<insert id=3D"insertCCUser&= quot; parameterClass=3D"user">
       INSERT INTO PARTICIPANT(PRTCPNT_ID= ,GIVEN_NM,MIDDLE_NM,FAMILY_NM,NAME_LINE_ONE_TX,
    =             &nb= sp;            =             &nb= sp;            = CITIZENSHIP,STREET_LINE_ONE_TX,STREET_LINE_TWO_TX,
   &n= bsp;            = ;            &n= bsp;            = ;            &n= bsp; CITY_NM,GEOGRAPHIC_REGION_CD,COUNTRY_CD,POSTAL_CD,PRIMARY_TELEPHONE_NO= ,PRIMARY_EMAIL_ADDRESS_TX,PASSWORD_TX,
            = ;            &n= bsp;            = ;            &n= bsp;     LAST_MODIFIED_USER_ID,LAST_MODIFIED_TS)
&nb= sp;      VALUES((select NVL(max(PRTCPNT_ID)+1,1)us= erId from PARTICIPANT),
        =             &nb= sp; #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) Locat= ion

-----Original Message-----
From: larry.meadors@gmail.com [mailto:larry.meadors@gmail.com]On Behalf
Of Larry Meadors
Sent: Frid= ay, March 10, 2006 12:58 PM
To: user-java@ibatis.apache.org
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)
< Sruthi.Krishnamoorthi@uspto.gov> wrote:
>
> This is thro= wing an exception because
>
>
> Integer test =3D (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: Nathan.Maves@Sun= .COM [mailto:Nathan.Maves@Sun.C= OM ]
> Sent: Friday, March 10, 2006 12:52 PM
> To: user-java@ibatis.apache.org
>= Subject: Re: Urgent help required
> Importance: High
>
>= Just use
>
>
> Integer rows =3D ((Integer)sqlMap.insert("ins= ertProduct",
> product)).intValue();
>
>
> if = you are using Java 1.5
>
>
> int rows =3D (Integer)sqlMap= .insert("insertProduct",
> product);
>
>
> Nathan
>
>
>>
>
> On Mar 10, 2006, at 10:41 AM, Krishnamoorthi, Sruthi= (Raytheon) wrote:
>
>
>
>
> The docs says
>
>         int rows = =3D sqlMap.insert ("insertProduct", product);
>
> ret= urns 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,<= br>> Sruthi Krishnamoorthi
> 703-562-9732(Work)
> 537 A - (R= aytheon) Location
>
>
>