You haven't given us much to go on. I think that turning on logging (as suggested last time) would be a good thing to do. Also, you might try sending the relevant parts of the XML.
The only thing I can think of with no other information is that you might be doing some string substitution, or the proc is returning different resultsets. Possibly adding remapResults="true" would fix that. But the logs would help us know for sure! Jeff Butler On Jan 2, 2008 4:05 PM, KWeisser <[EMAIL PROTECTED]> wrote: > > I'm not sure I explained it clearly. > > I'm able to bring up the server, perform a search, and then view the > details > of my business object. I then click the back button in the browser, and > reclick the "View" button for the same business object. On the second > attempt, I get the error I mention below. > > I've put in breakpoints, and the data is the same in the procedures both > times. Additionally, if I comment out part of the code that executes the > procedure it is failing on the problem disappears. Also I've noticed, > that > no matter what action I'm trying to perform it is continuing to try to > execute the procedure that fails (whether that procedure has anything to > do > with action I select or not). > > I just seems odd that everything works, I click the back the button, then > resubmit the same request and I receive an error. > > The connection is being managed through a data source, so I know that this > is consistent from execution to execution. > > Any other thoughts on what could be causing this issue? > > Regards, > > Kevin Weisser > > > Stephen Boyd-3 wrote: > > > > Turn on debug for java.sql.Connection and make sure all the parameters > are > > being passed correctly. > > > > On Dec 20, 2007 12:32 PM, KWeisser <[EMAIL PROTECTED]> wrote: > > > >> > >> I'm currently running a Web project in RSA 7.0 using Ibatis. > >> > >> When I start my local server, I'm able to successfully retrieve a set > of > >> data using several strored procedures. If I click the back button in > the > >> browser, and then try to re-retrieve that same exact data I get an > error. > >> > >> The error tells me that: > >> The error occurred in storedProcedureMapping/CMSP3023.xml > >> The error occurred while applying the parameter map. > >> Check the the GetOffense.params > >> Check the results (failed to the retrieve results). > >> > >> This is an exceptionally odd situation, because it works with no issues > >> the > >> first time through. Then if I try to run the exact same set of code > with > >> the same inputs I'm getting this error. I've also verified that I can > >> run > >> the procedure many times from the command line in DB2. > >> > >> Any ideas why this would be happening? > >> > >> Regards, > >> > >> Kevin Weisser > >> -- > >> View this message in context: > >> http://www.nabble.com/Stored-Procedure-Problem-tp14441018p14441018.html > >> Sent from the iBATIS - User - Java mailing list archive at > >> Nabble.com<http://nabble.com/> > . > >> > >> > > > > > > -- > View this message in context: > http://www.nabble.com/Stored-Procedure-Problem-tp14441018p14587382.html > Sent from the iBATIS - User - Java mailing list archive at > Nabble.com<http://nabble.com/> > . > >
