Hi,
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:
cs.execute();
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.
Regards,
Priyesh
-----Original Message-----
From: Priyesh Mashelkar
Sent: Friday, August 05, 2005 5:49 PM
To: [email protected]
Subject: Executing a Stored Procedure returning rows from a Temporary
table
Hi,
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,
Priyesh
MASTEK
"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 computers.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
