Hi Clinton,
I downloaded the updated version ibatis-3-core-3.0.0.220.jar and the
Exception is gone but there is still the stored procedure is not inserting
any thing to the table ,added to that the return value is also null
I changed my mapping to something like this
<select statementType="CALLABLE" id="storedProc"
parameterType="Address"
resultType="Address">
{call TEST_SP(#{street},#{street,mode=OUT,jdbcType=VARCHAR})}
</select>
Clinton Begin wrote:
>
> 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 <[email protected]> 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 <[email protected]>
>> 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 <[email protected]>
>> >> 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
>> <[email protected]>
>> >> >> 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
>> >> <[email protected]>
>> >> >> >> 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:
>> [email protected]
>> >> >> >> >> For additional commands, e-mail:
>> >> [email protected]
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >
>> >> >> >> >
>> >> >> >>
>> >> >> >> --
>> >> >> >> 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: [email protected]
>> >> >> >> For additional commands, e-mail:
>> [email protected]
>> >> >> >>
>> >> >> >
>> >> >> >
>> >> ---------------------------------------------------------------------
>> >> >> > To unsubscribe, e-mail: [email protected]
>> >> >> > For additional commands, e-mail: [email protected]
>> >> >> >
>> >> >> >
>> >> >> >
>> >> >>
>> >> >> --
>> >> >> 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: [email protected]
>> >> >> For additional commands, e-mail: [email protected]
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >>
>> >> --
>> >> 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: [email protected]
>> >> For additional commands, e-mail: [email protected]
>> >>
>> >>
>> >
>> >
>>
>> --
>> 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: [email protected]
>> For additional commands, e-mail: [email protected]
>>
>>
>
>
--
View this message in context:
http://old.nabble.com/stored-procedure-in-iBatis-3-tp27026799p27107708.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
