ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Krishnamoorthi, Sruthi (Raytheon)" <Sruthi.Krishnamoor...@USPTO.GOV>
Subject RE: Urgent help required
Date Fri, 10 Mar 2006 18:14:46 GMT
If this is the case Y all doc's of Ibatis are statting that it returns a int return value.
 

Thanks, 
Sruthi Krishnamoorthi 
703-562-9732(Work) 
537 A - (Raytheon) Location 

-----Original Message-----
From: Jeff Butler [mailto:jeffgbutler@gmail.com]
Sent: Friday, March 10, 2006 1:13 PM
To: user-java@ibatis.apache.org
Subject: Re: Urgent help required


Yes - or you could do a select to verify if you don't trust your database or JDBC driver's
exception handling.
 
Jeff Butler

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


Do you mean to say if there is no exception then insert worked.
Is this the only way to confirm.

 

Thanks, 
Sruthi Krishnamoorthi 
703-562-9732(Work) 
537 A - (Raytheon) Location 



-----Original Message-----
From: Jeff Butler [mailto:  <mailto:jeffgbutler@gmail.com> jeffgbutler@gmail.com]
Sent: Friday, March 10, 2006 1:08 PM
To: user-java@ibatis.apache.org  <mailto:user-java@ibatis.apache.org> 
Subject: Re: Urgent help required


You woldn't - <selectKey> is used for automatically generated keys (like identity fields
or sequences).  In your case, the insert worked if no exception is thrown.
 
Jeff Butler

 
On 3/10/06, Krishnamoorthi, Sruthi (Raytheon) <  <mailto:Sruthi.Krishnamoorthi@uspto.gov>
Sruthi.Krishnamoorthi@uspto.gov> 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: larry.meadors@gmail.com [mailto: larry.meadors@gmail.com]On Behalf
Of Larry Meadors
Sent: Friday, 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)
<  <mailto:Sruthi.Krishnamoorthi@uspto.gov> Sruthi.Krishnamoorthi@uspto.gov >
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: Nathan.Maves@Sun.COM  <mailto:Nathan.Maves@Sun.COM> [mailto: Nathan.Maves@Sun.COM
 <mailto:Nathan.Maves@Sun.COM> ]
> 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 = ((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
>
>
>







Mime
View raw message