ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From KWeisser <kewei...@us.ibm.com>
Subject Re: Stored Procedure Problem
Date Wed, 02 Jan 2008 22:05:27 GMT

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?


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 <keweisse@us.ibm.com> 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.

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.

View raw message