You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by KWeisser <ke...@us.ibm.com> on 2007/12/20 18:32:08 UTC
Stored Procedure Problem
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.
Re: Stored Procedure Problem
Posted by Jeff Butler <je...@gmail.com>.
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 <ke...@us.ibm.com> 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 <ke...@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<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/>
> .
>
>
Re: Stored Procedure Problem
Posted by KWeisser <ke...@us.ibm.com>.
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 <ke...@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.
Re: Stored Procedure Problem
Posted by Stephen Boyd <sw...@gmail.com>.
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 <ke...@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.
>
>