Hi Larry,
Thanks for the response.
Let me tell you my Stored Procedure approach.
1.Parameter Map set in one of my ibatis resource .xml file is as below.
<parameterMap class="BagTagVO" id="bagTagSPParam">
<parameter property="BAGID" jdbcType="VARCHAR" mode="IN" />
<parameter property="APCDE" jdbcType="VARCHAR" mode="IN" />
<parameter property="CRTNDTM" jdbcType="VARCHAR" mode="IN" />
<parameter property="BAGDATA" jdbcType="VARCHAR" mode="OUT" />
<parameter property="RETURNCODE" jdbcType="INTEGER" mode="OUT" />
</parameterMap>
below is the stored procedure calling portion.
<procedure id="retrieveBagTagInfoSP" parameterMap="bagTagSPParam">
{call Bag_Information.BagTag_Inquiry(?,?,?,?,?) }
</procedure>
Using the above while I invoke the stored procedure. My application hangs
and after say 120 mins I got a timed out exception. i increased the timeout
limit to 400 even then I am unable to execute the stored procedure.
When I try to invoke the same stored procedure through normal
java.sql.connection and callable statement it gives me result within 2 secs.
I changed my .xml parameter map to HashMap and also I tried replacing the
'?' as #param1...." and invoked it even then it was throwing error.
Your help in this regard would be highly appreciated.
Larry Meadors-2 wrote:
>
> I know both work, but without seeing any code...it's impossible for us
> to see what your specific issue is.
>
> Larry
>
>
> On 10/19/07, IBATIS <[EMAIL PROTECTED]> wrote:
>>
>> Hi There,
>>
>> I am facing issues while I invoke a sql / stored procedure in RAD 7.0
>> using
>> Ibatis.
>>
>> Do I need add any .jars or others to make it work with RAD.
>>
>> Please look into the issues as below.
>>
>> 1. while I invoke a plain sql I am not getting the result.
>> 2. While I invoke a stored procedure, the transaction is getting timed
>> out.
>>
>> when i invoke the above using ordinary java.sql.connection ( I get this
>> connection object from SqlMapClient.getDataSource().getConnection()) it
>> is
>> working fine for both points 1&2.
>>
>> Your help will be highly appreciated.
>>
>> Regards
>> Venkat
>> --
>> View this message in context:
>> http://www.nabble.com/Please-help---Using-IBatis-in-RAD-7.0-tf4652521.html#a13292529
>> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>>
>>
>
>
--
View this message in context:
http://www.nabble.com/Please-help---Using-IBatis-in-RAD-7.0-tf4652521.html#a13294463
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
