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 15:12:00 GMT
I would be more than happy if that helps.
But just to tell you if u have missed, that i am selecting on a temporary table. If it does
not work in a Stored Procedure, I doubt whether it will work in a function. Moreover,  in
the executeQuery() of SqlExecutor too, the execute() method is used and the result set is
retrieved from the PreparedStatement. So, it is more likely that the solution you suggested
may not work.

-----Original Message-----
From: Akins, Greg [mailto:Greg.Akins@am.sony.com]
Sent: Monday, August 08, 2005 8:22 PM
To: user-java@ibatis.apache.org
Subject: RE: Executing a Stored Procedure returning rows from a
Temporary table

I wasn't reading much in this thread, so I might have missed another
suggestion.  Sorry if that's the case.

However, I would just write a function that returns the result set.

Then rather than executing the procedure and trying to get the results, 

Just run a regular query like "select * from getResults()"

If getResults returns a table, then the result of the query will be that
same result set.

-----Original Message-----
From: Koka [mailto:226057@gmail.com] 
Sent: Monday, August 08, 2005 10:47 AM
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