Re: Procedures in iBatis

[Beemsterboer Software]

Sorry, I don't have an example of a stored procedure without any properties.
I was assuming that you needed some result from your stored procedure call.
What exactly is the use of doing select statements without having a result?

[EMAIL PROTECTED] wrote:

Hi,

I don't have any property to specify. Please let me know.


Regards,
Suman Mishra
203-719-1698



-----Original Message-----

From: Beemsterboer Software [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 19, 2006 12:17 PM

To: user-java@ibatis.apache.org
Subject: Re: Procedures in iBatis

Try this:
    <typeAlias alias="order" type="pojo.Order" />
    <resultMap id="orderResult" class="order">
        <result property="prop1" column="column1"/>
        <result property="prop2" column="column2"/>
    </resultMap>

<procedure id="getOrders" resultMap="orderResult">

        {call get_data()}
    </procedure>

[EMAIL PROTECTED] wrote:

Hi,

I have a sybase procedure which doesnt take any parameter. Its a combination of few select statements. Can someone please help me with the syntax where parameter property is blank. Can someone help me with this block -

<parameterMap id="getOrders" resultClass="java.util.HashMap" >

*<parameter property="xxx" jdbcType="VARCHAR" mode="IN"/> --------->>>

I dont need this*

</parameterMap>

<procedure id="getOrders" parameterMap = "getOrders">

{get_data()}

</procedure>

Thanks in advance,
Suman Mishra
203-719-1698