tha bar and bat field you are using are they assumed to be fileds of Foo,If
so this is not my case .I wanted to get back an Address object passing in
Address Object
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-tp27026799p27071537.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]
