ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From vishalj <Vish...@ivycomptech.com>
Subject Re: stored procedure in iBatis 3
Date Fri, 08 Jan 2010 05:16:32 GMT

Sorry to say , i already did try that .to mention again one of my second
parameter is out type 

but when i try with the mapping as follows :
	<select  statementType="CALLABLE" id="storedProc" parameterType="Address">
		   {call TEST_SP(#(street),#(street))}
	</select>

I get 

 org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper
Configuration. Cause: java.lang.RuntimeException: Error parsing Mapper XML.
Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias
'IN'.  Cause: java.lang.ClassNotFoundException: Cannot find class: IN


Please let me know if i need to do something more .Am a newbie to iBatis


nmaves wrote:
> 
> 1) You might want to read the documentation one more time.
> 
> 2)  here is your map
> 
> <insert id="myProc" statementType="CALLABLE"
> paramaterMap="someParameterMap">
>     {call TEST_SP(?,?)}
> </insert>
> 
> or with inline parameters
> 
> <insert id="myProc" statementType="CALLABLE" paramaterType="com.acme.Foo">
>     {call TEST_SP(#{bar},#{bat})}
> </insert>
> 
> On Thu, Jan 7, 2010 at 12:09 AM, vishalj <VishalJ@ivycomptech.com> wrote:
> 
>>
>> This is the JDBC proc for the same
>>
>>
>>
>>                    CallableStatement stmt = conn.prepareCall("call
>> TEST_SP(?,?)");
>>                    stmt.setString(1,"asdhk");
>>                    stmt.registerOutParameter(2,Types.VARCHAR);
>>                    stmt.execute();
>>                    System.out.println(stmt.getString(2));
>>
>> Regards,
>> Vishal
>>
>>
>>
>>
>>
>> Clinton Begin wrote:
>> >
>> > Can you provide the standard JDBC code you'd use to call your
>> procedure?
>> >
>> > You need to understand how JDBC calls procs, and then it becomes
>> > obvious.  Send the JDBC code, and I'll translate it into a mapping for
>> > you.
>> >
>> > Clinton
>> >
>> >
>> > On Wed, Jan 6, 2010 at 10:15 PM, vishalj <VishalJ@ivycomptech.com>
>> wrote:
>> >>
>> >> It would be a great help if you can give me the mapping for
>> >>
>> >> CREATE OR REPLACE
>> >> PROCEDURE TEST_SP
>> >>   (streetIn IN VARCHAR,streetOut OUT VARCHAR)
>> >> AS
>> >>
>> >> BEGIN
>> >>  INSERT INTO TEST_ADDRESS values(1,streetIn) ;
>> >>  streetOut:=streetIn;
>> >> END;
>> >>
>> >>
>> >> I want to pass in a Address Object and get Back a Address Object Back
>> >> ,the
>> >> java Class for Address Object looks like this
>> >>
>> >> public class Address {
>> >>
>> >>        private String street;
>> >>
>> >>        public String getStreet() {
>> >>                return street;
>> >>        }
>> >>
>> >>        public void setStreet(String street) {
>> >>                this.street = street;
>> >>        }
>> >>
>> >> }
>> >>
>> >>
>> >>
>> >>
>> >>
>> >> Clinton Begin wrote:
>> >> >
>> >> > Yes, stored procs are mapped exactly like every other statement in
>> >> iBATIS
>> >> > 3,
>> >> > but you set the statementType attribute to CALLABLE.
>> >> >
>> >> > Page 22 discusses this a little (although I agree, not enough).
>> >> >
>> >> > <insert id="myProc" statementType="CALLABLE">
>> >> > {your java proc call here - same syntax as JDBC}
>> >> > </insert>
>> >> >
>> >> > Parameters can still be set to IN, OUT or INOUT.
>> >> >
>> >> > We've eliminated the <procedure> element, as it wasn't descriptive
>> >> enough.
>> >> >
>> >> > Clinton
>> >> >
>> >> >
>> >> > On Wed, Jan 6, 2010 at 12:06 AM, vishalj <VishalJ@ivycomptech.com>
>> >> wrote:
>> >> >
>> >> >>
>> >> >> How do i map  execute Stored Procedures in DB for iBatis 3.The
>> >> >> documentation
>> >> >> does not talk about that
>> >> >> --
>> >> >> View this message in context:
>> >> >>
>> >>
>> http://old.nabble.com/stored-procedure-in-iBatis-3-tp27026799p27026799.html
>> >> >> Sent from the iBATIS - User - Java mailing list archive at
>> Nabble.com.
>> >> >>
>> >> >>
>> >> >>
>> ---------------------------------------------------------------------
>> >> >> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
>> >> >> For additional commands, e-mail: user-java-help@ibatis.apache.org
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >>
>> >> --
>> >> View this message in context:
>> >>
>> http://old.nabble.com/stored-procedure-in-iBatis-3-tp27026799p27052357.html
>> >> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>> >>
>> >>
>> >> ---------------------------------------------------------------------
>> >> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
>> >> For additional commands, e-mail: user-java-help@ibatis.apache.org
>> >>
>> >
>> > ---------------------------------------------------------------------
>> > To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
>> > For additional commands, e-mail: user-java-help@ibatis.apache.org
>> >
>> >
>> >
>>
>> --
>> View this message in context:
>> http://old.nabble.com/stored-procedure-in-iBatis-3-tp27026799p27055894.html
>> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
>> For additional commands, e-mail: user-java-help@ibatis.apache.org
>>
>>
> 
> 

-- 
View this message in context: http://old.nabble.com/stored-procedure-in-iBatis-3-tp27026799p27071488.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


Mime
View raw message