ibatis-user-cs mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Musachy Barroso" <musa...@gmail.com>
Subject Re: Problem calling stored procedure having no parameter
Date Mon, 24 Jul 2006 22:58:52 GMT
I don't know for Java, for for .Net, the documentation says that the
parameterMap is required. I still don't know why.

On 7/24/06, Farrukh Nizami <fnizami@axentis.com> wrote:
>
> Thanks for your prompt reply Peter. I got this solution from Oddur. I will
> check it out and hope it works.
>
> Thanks & Regards
> Farrukh Nizami
>
> ________________________________
>
> From: Peter Mills [mailto:development@peter.mills.to]
> Sent: Mon 7/24/2006 10:16 PM
> To: user-cs@ibatis.apache.org
> Subject: Re: Problem calling stored procedure having no parameter
>
>
>
> Hi Farrukh,
>
> You can use an empty parameter map.
>
> <parameterMap id="EmptyParam"></parameterMap>
>
> <procedure id="GetAllOrders" parameterMap="EmptyParam"
> resultMap="myResultMap">
>             GetBusinessCustomFields
>         </procedure>
>
> Cheers,
>
> Peter
>
> Farrukh Nizami wrote:
>
> > Hi,
> >
> >             I have a simple stored procedure that returns all the rows
> > from a table.
> >
> > CREATE PROCEDURE [dbo].[GetAllOrders]
> >
> > AS
> >
> > SELECT [OrderID]
> >
> >       ,[CustomerID]
> >
> >       ,[EmployeeID]
> >
> >       ,[OrderDate]
> >
> >       ,[RequiredDate]
> >
> >       ,[ShippedDate]
> >
> >       ,[ShipVia]
> >
> >       ,CAST([Freight] AS Real) AS Freight
> >
> >       ,[ShipName]
> >
> >       ,[ShipAddress]
> >
> >       ,[ShipCity]
> >
> >       ,[ShipRegion]
> >
> >       ,[ShipPostalCode]
> >
> >       ,[ShipCountry]
> >
> >   FROM [Northwind].[dbo].[Orders]
> >
> >
> >
> > How to call this stored procedure? Whenever I want to call this SP, it
> > complains that it need parameterMap attribute in procedure tag. But I
> > do not need any parameter to call this SP. Please help
> >
> >
> >
> > */Thanks & Regards
> > /**/Farrukh Nizami/*
> >
> > *Axentis Software Private Limited
> > Unit # 3, Ground Floor, Inventor Block,
> > I T P B, **Whitefield Road,
> > Bangalore: 560066, I N D I A*
> > *P: 91-80-28416690 / 91 / 92 / 93 Ext. 2050
> > F: 91-80-28412010
> > M: 0-98867-32213*
> > *Web:* www.axentis.com
> > <
> file:///C:/Documents%20and%20Settings/fnizami/Application%20Data/Microsoft/Signatures/www.axentis.com
> >
> >
>
>
>
>
>


-- 
"Hey you! Would you help me to carry the stone?" Pink Floyd

Mime
View raw message