Hi Abhigyan, I forgot to mention about the databas. It is Oracle 10G.
Regards Venkat Abhigyan Agrawal1 wrote: > > Hi Venkat, > The first error you are getting is definitely because of wrong > jdbc type. > I tried the code you have given and it gives the same error (register > output parameters failed) until I change it to VARCHAR instead of > VARCHAR2. After doing the change, the code is running through iBATIS > displaying expected results. Which database are you using? > One more thing, you can remove resultClass from procedure as you > are already giving parameterClass of the same map. > As far as the transaction is getting timed out is concerned, are > you providing some timeout values yourself? because I am not and the > procedure is executing without problem. > > Cheers, > Abhigyan Agrawal > > > > > IBATIS <[EMAIL PROTECTED]> > 20/10/2007 16:45 > Please respond to > [email protected] > > > To > [email protected] > cc > > Subject > Re: Please help - Using IBatis in RAD 7.0 > > > > > > > > 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. > > > > -- View this message in context: http://www.nabble.com/Please-help---Using-IBatis-in-RAD-7.0-tf4652521.html#a13360825 Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
