ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Cornel Antohi" <cant...@kepler-rominfo.com>
Subject Re: DB2 As400 stored procedure with cursor
Date Sat, 17 Jun 2006 13:10:06 GMT
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
>>  
>>
>
Mime
View raw message