ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From puneet arya <puneet_arya_...@yahoo.co.in>
Subject Re: DB2 As400 stored procedure with cursor
Date Tue, 20 Jun 2006 04:43:18 GMT
hi,
      you can use ibatis for this task. 

Cornel Antohi <cantohi@kepler-rominfo.com> wrote:
          Hi,
   
  Using pure JDBC (JT400) , stored procedures using CURSOR should be used like that in order
to fetch the first row:
   
  ctmt = con.prepareCall("{call FPRPR_SEARCHPRODUCTS(?,?)}", ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
  ....
  rs.beforeFirst();
   
  Can iBATIS do that or should I use JDBC for this task? 
  We are using iBATIS but such kind of stuff that cannot be done (or I do not know the correct
iBATIS solution) are very painful.
   
  Thank you for your prompt answer,
  Cornel Antohi
  
                
   
   
  ----- Original Message -----   From: "Sven Boden" <list123@pandora.be>
  To: <user-java@ibatis.apache.org>
  Sent: Saturday, June 17, 2006 3:48 PM
  Subject: Re: DB2 As400 stored procedure with cursor

  

> There's nothing in iBATIS that would do that. Can you check whether you 
> get the same results with your favorite query tool.
> 
> Regards,
> Sven
> 
> Cornel Antohi wrote:
> 
>>Hi,
>>
>>I am using a stored procedure that opens a cursor and I am trying to obtain the results
with queryForList(). Unfortunatelly I receive the results without the first row (first row
it is skipped). Any solution to this issue?
>>
>>Thank you,
>>Cornel Antohi
>>  
>>
> 

 				
---------------------------------
  Yahoo! India Answers: Share what you know. Learn something new Click here
 Send free SMS to your Friends on Mobile from your Yahoo! Messenger Download now
Mime
View raw message