ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Niels Beekman" <n.beek...@wis.nl>
Subject RE: Executing a Stored Procedure returning rows from a Temporary table
Date Mon, 08 Aug 2005 14:25:43 GMT
You may want to try jTDS (http://jtds.sf.net), it performs much better
than the MS-driver and contains less bugs, didn't try the new
SP4-version of the MS-driver though and I do not have experience with
stored procedures.


-----Original Message-----
From: Priyesh Mashelkar [mailto:priyeshm@mastek.com] 
Sent: maandag 8 augustus 2005 16:20
To: user-java@ibatis.apache.org
Subject: RE: Executing a Stored Procedure returning rows from a
Temporary table

I buy your point.
But the method in which this occurs is executeQueryProcedure(). And the
procedure is expected to return a result set. Correct me if I am wrong.
I am using the following settings:
   	        <property name="JDBC.Driver"
value="com.microsoft.jdbc.sqlserver.SQLServerDriver"  />
   	        <property name="JDBC.ConnectionURL" 
value="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=DBName" />
Do you know of any issues with this driver?

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

iBATIS is behaving according to the JDBC spec in this case. 
executeQuery cannot be a general solution because stored procedures
may not always return result sets.  So it seems to me that this could
be a driver problem, rather than an iBATIS problem.

Jeff Butler

On 8/8/05, Priyesh Mashelkar <priyeshm@mastek.com> wrote:
> 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

"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.

View raw message