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 <vish...@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 <vish...@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 <vish...@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-unsubscr...@ibatis.apache.org
> >> >> For additional commands, e-mail: user-java-h...@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-unsubscr...@ibatis.apache.org
> >> For additional commands, e-mail: user-java-h...@ibatis.apache.org
> >>
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
> > For additional commands, e-mail: user-java-h...@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-unsubscr...@ibatis.apache.org
> For additional commands, e-mail: user-java-h...@ibatis.apache.org
>
>
