faq
QnaList

[Ibatis-User-Java] Cursor State Not Valid

When I run this db2 query:
caller = (Caller)sqlMap.queryForObject("getIPCTData", caller);
I get an error message of "cursor state not valid".
I verified that the stored procedure works correctly when run manually
in a db2 screen.
The sql config file is as follows:
            {call
DMCLIB.IPCTSndDtaSRA(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
Any ideas why the error message occurs?
Thanks in advance.
Steve Jagels
Sr. Programmer / Analyst
(314) 387-5131
sejagels@magellanhealth.com

asked Mar 2 2005 at 22:04

Jagels, Steve E.'s gravatar image



1 Replies for : Cursor State Not Valid
Looks like you are working on an AS/400. ;-)
This happens when a procedure closes the data set to be returned
before iBATIS has read it...there is something you have to do in db2
to make it work, but I do not have it handy.
I will post it tomorrow from work.
Larry

answered Mar 6 2005 at 23:00

Larry Meadors's gravatar image


Related questions

Tagged

Group Ibatis-user-java

asked Mar 2 2005 at 22:04

active Mar 6 2005 at 23:00

posts:2

users:2

©2013 QnaList.com . QnaList is part of ZisaTechnologies LLC.