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

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,

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:
>>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
View raw message