Larry,
Sorry for not being clear with my queries. I have refined my query as below.
Please help me out.
I have a stored procedure as below.
CREATE OR REPLACE procedure mytest
(
In_Bag_ID in varchar,
In_Station in varchar,
In_Crtn_Dtm in varchar,
Out_Bag_Data out varchar2,
Out_Return_Cde out number)
is
Begin
Out_Bag_Data := 'success';
Out_Return_Cde := 0;
End mytest;
/
My .xml resource file entry is as below
<procedure id="retrieveBagTagInfoSP" parameterClass="java.util.HashMap"
resultClass="java.util.HashMap">
{call mytest
(#bagid,javaType=java.lang.String,jdbcType=VARCHAR,mode=IN#,
#apcde,javaType=java.lang.String,jdbcType=VARCHAR,mode=IN#,
#crtndtm,javaType=java.lang.String,jdbcType=VARCHAR,mode=IN#,
#bagdata,javaType=java.lang.String,jdbcType=VARCHAR2,mode=OUT#,
#returncode,javaType=java.lang.Integer,jdbcType=INTEGER,mode=OUT#)}
</procedure>
My Calling java programme is as below.
hshBagTag.put("bagid","");
hshBagTag.put("apcde","");
hshBagTag.put("crtndtm","");
hshBagTag.put("bagdata",new String(""));
hshBagTag.put("returncode", new Integer(0));
SqlMapperClient.queryForObject("retrieveBagTagInfoSP", hshBagTag,hshBagTag);
While I invoke the stored procedure, I am getting the following error
--- The error occurred in com/nwa/safetrac/domain/common/dao/sql/Bags.xml.
--- The error occurred while executing query procedure.
--- Check the {call mytest (?, ?, ?, ?, ?)}.
--- Check the output parameters (register output parameters failed).
--- Cause: java.sql.SQLException: Invalid column type
In the same above I changed the
#bagdata,javaType=java.lang.String,jdbcType=VARCHAR2,mode=OUT#,
to
#bagdata,javaType=java.lang.String,jdbcType=VARCHAR,mode=OUT#,
and
#returncode,javaType=java.lang.Integer,jdbcType=INTEGER,mode=OUT#
to
#returncode,javaType=java.lang.Double,jdbcType=DECIMAL,mode=OUT#)
Now, the above error was not occurring but the transaction is getting timed
out.
Could you please tell me where I am going wrong, I am badly in need of a
help.
My Environment is as below.
Development Environment - RAD 7.0 (Websphere Application server 6.0)
Ibatis jar files - ibatis-common-2.jar / ibatis-sqlmap-2.jar (i got it from
jpetstore example package)
Regards
Venkat
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#a13308959
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
