ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Beemsterboer Software <h...@beemsterboer-software.nl>
Subject Re: Procedures in iBatis
Date Wed, 19 Apr 2006 16:34:10 GMT
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?

Suman.Mishra@ubs.com 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:hans@beemsterboer-software.nl] 
> 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>
>
> Suman.Mishra@ubs.com 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
>>     


Mime
View raw message