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 13:53:47 GMT
	Havent received anybodies mail regarding this. 
	Tried digging through the iBATIS source code and found the following. The   "public void
executeQueryProcedure(RequestScope request, Connection conn, String sql, Object[] parameters,
 int skipResults, int maxResults, RowHandlerCallback callback)" method in SqlExecutor uses
the following code to execute and get the ResultSet:
	rs = cs.getResultSet();
	When data from a Temporary table is selected in the Stored Procedure, the Result Set "rs"
is null. 
	But if we use the following code instead the result set returned is proper:
	rs = cs.executeQuery();

	Will this change have any repercussions somewhere else? Kindly reply ASAP. Its urgent.

-----Original Message-----
From: Priyesh Mashelkar 
Sent: Friday, August 05, 2005 5:49 PM
To: user-java@ibatis.apache.org
Subject: Executing a Stored Procedure returning rows from a Temporary

	I have a Stored Procedure which uses the input parameters passed to it and returns rows from
a temporary table which it creates. 
	Currently I am getting a NullPointerException executing the Stored Procedure.
	I am using Microsoft SQL Server 2000 database. And in the procedure I fire a select on a
temporary table. But I encounter the above exception.
	How can I get the Result in this case? Is there any special configuration to be done in the
iBATIS Mapping file?
	Has anybody solved this problem before?
Thanks and Regards,

"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