ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nathan Maves <nathan.ma...@gmail.com>
Subject Re: stored procedure in iBatis 3
Date Thu, 07 Jan 2010 16:13:28 GMT
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
>
>

Mime
View raw message