ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Clinton Begin <clinton.be...@gmail.com>
Subject Re: stored procedure in iBatis 3
Date Fri, 08 Jan 2010 05:23:53 GMT
That's a bug, as per another email thread today.  It's fixed in trunk if you
want to check it out and build it (one click maven/ant build)

On Thu, Jan 7, 2010 at 10:16 PM, vishalj <VishalJ@ivycomptech.com> wrote:

>
> 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