Re: Bug with Multiple Result Sets?
- From: evanba@xxxxxxxxxxxxxxxxxxxx (Evan T. Basalik (MSFT))
- Date: Thu, 02 Mar 2006 16:46:29 GMT
Wes,
I have refiled the original bug with the additional information.
Evan
--------------------
Thread-Topic: Bug with Multiple Result Sets?
From: =?Utf-8?B?V2VzIENsYXJr?= <WesClark@xxxxxxxxxxxxxxxxxxxxxxxxx>
Subject: Re: Bug with Multiple Result Sets?
Date: Mon, 20 Feb 2006 16:56:29 -0800
Here are some very interesting results. I created a stored procedure that
returned result set interspersed with update counts:
CREATE PROCEDURE testProcReturns
AS
BEGIN
SELECT VacationHours from HumanResources.Employee where employeeID < 3;
update HumanResources.Employee set VacationHours = VacationHours + 1 where
employeeID < 3;
SELECT VacationHours from HumanResources.Employee where employeeID < 3;
update HumanResources.Employee set VacationHours = VacationHours - 1 where
employeeID < 3;
SELECT VacationHours from HumanResources.Employee where employeeID < 3;
END;
When I ran the procedure using all four drivers, all except the new driver
correctly returned the update counts:
Class being loaded com.microsoft.sqlserver.jdbc.SQLServerDriver
URL being used:
jdbc:sqlserver://localhost:2005;selectMethod=direct;databaseName=AdventureWorks;user=sa;password=123
Vacation hours is 21
Vacation hours is 42
Vacation hours is 22
Vacation hours is 43
Vacation hours is 21
Vacation hours is 42
Class being loaded com.microsoft.jdbc.sqlserver.SQLServerDriver
URL being used:
jdbc:microsoft:sqlserver://localhost:2005;selectMethod=direct;databaseName=AdventureWorks;user=sa;password=123;
Vacation hours is 21
Vacation hours is 42
Update count is: 2
Vacation hours is 22
Vacation hours is 43
Update count is: 2
Vacation hours is 21
Vacation hours is 42
Class being loaded com.newatlanta.jturbo.driver.Driver
URL being used:
jdbc:JTurbo://localhost:2005/AdventureWorks/user=sa/password=123
Vacation hours is 21
Vacation hours is 42
Update count is: 2
Vacation hours is 22
Vacation hours is 43
Update count is: 2
Vacation hours is 21
Vacation hours is 42
Class being loaded net.sourceforge.jtds.jdbc.Driver
URL being used:
jdbc:jtds:sqlserver://localhost:2005/AdventureWorks;user=sa;password=123
Vacation hours is 21
Vacation hours is 42
Update count is: 2
Vacation hours is 22
Vacation hours is 43
Update count is: 2
Vacation hours is 21
Vacation hours is 42
I am not clear what is going on here, but these results strongly suggest the
new driver is not behaving correctly.
--
This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Note: For the benefit of the community-at-large, all responses to this message are best directed to the newsgroup/thread from which they originated.
.
- Prev by Date: Re: "varbinary(max)" data type is returning as "image" in MS SQL
- Next by Date: getting Multiple resultsets in java using stored procedure in MS SQL Server 2000
- Previous by thread: Re: "varbinary(max)" data type is returning as "image" in MS SQL
- Next by thread: Re: Bug with Multiple Result Sets?
- Index(es):
Relevant Pages
|
