ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Priyesh Mashelkar" <priye...@mastek.com>
Subject RE: Executing a Stored Procedure returning rows from a Temporary table
Date Mon, 08 Aug 2005 14:59:26 GMT
Well, that was one of the alternatives.
But going to the database twice is going to shoot up the performance. Furthermore, multiple
clients may call this Stored Procedure and we would have to somehow separate the outputs for
the various clients.
But if the code iBATIS has is perfectly fine, we would definitely go for this option.

-----Original Message-----
From: Koka [mailto:226057@gmail.com]
Sent: Monday, August 08, 2005 8:17 PM
To: user-java@ibatis.apache.org
Subject: Re: Executing a Stored Procedure returning rows from a
Temporary table

> I have a Stored Procedure which uses the input parameters passed to 
> it and returns rows from a temporary table which it creates

I'd avoid changing iBatis code. Instead I'd go for a workaround like
executing procedure that fills the table (but does not return rows)
and next (in the same transaction of course) just run ordinary select
statement on tha table. Just one extra statement sounds to me far
better than changing iBastis code


"Making a valuable difference"
Mastek in NASSCOM's 'India Top 20' Software Service Exporters List.
In the US, we're called MAJESCO

Opinions expressed in this e-mail are those of the individual and not that of Mastek Limited,
unless specifically indicated to that effect. Mastek Limited does not accept any responsibility
or liability for it. This e-mail and attachments (if any) transmitted with it are confidential
and/or privileged and solely for the use of the intended person or entity to which it is addressed.
Any review, re-transmission, dissemination or other use of or taking of any action in reliance
upon this information by persons or entities other than the intended recipient is prohibited.
This e-mail and its attachments have been scanned for the presence of computer viruses. It
is the responsibility of the recipient to run the virus check on e-mails and attachments before
opening them. If you have received this e-mail in error, kindly delete this e-mail from all

View raw message