Re: DB2 As400 stored procedure with cursor

Mon, 19 Jun 2006 21:43:40 -0700

hi,
    you can use ibatis for this task.

Cornel Antohi <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]>
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

Reply via email to