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 07:13:27 GMT
I've let you know already.  It's in trunk.  Build it.  Otherwise watch for
the next release.

On Fri, Jan 8, 2010 at 12:02 AM, vishalj <VishalJ@ivycomptech.com> wrote:

>
> Thanks Clinton,
>
> Please let me know when can i use the feature i am looking for
>
> Regards,
> Vishal
>
> Clinton Begin wrote:
> >
> > 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
> >>
> >>
> >
> >
>
> --
> View this message in context:
> http://old.nabble.com/stored-procedure-in-iBatis-3-tp27026799p27072029.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