PRB: ?? ???? ??? ????? ????????? ????? ????? ?? ??? ?????? ????

???? ???????: 313181 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???????? ????? ????? ??????? ?????? ?????? ???????
????? ???? | ?? ????

?? ??? ??????

???????

????? ??????? ?????? ?? Microsoft SQL Server 2000 ??????? ?? ??? JDBC, ?? ????? ????????? ??????:
java.sql.SQLException: ???? ??? ????? [Microsoft] [SQLServer ????? 2000 ?? JDBC] ????? ????????? ?? ??? ?????? ????.
???? ??? ?????? | ????? ???????

?????

???? ??? ????? ??? ?????? ????? ??? ?????? ?? ????? ?????? SQL Server ?? ?????? ????? JDBC ?? ??? ?????? ???? (AutoCommit = ???) ? ????? ??????? ???????? (SelectMethod = ?????) ???. ??? ??????? ?? ????? ????????? ??????? ???????.
???? ??? ?????? | ????? ???????

????

??? ??????? ??? ?????? ???? ??? ????? ??????? SelectMethod ?????? ??????? ??? ?????? ?? ???? ?? ??????? ???? ??? ???? ??? ??? ?? ????? ??? ?? ???? ?? ??? "???? ?? ?????????" ?? ??? ???????.
???? ??? ?????? | ????? ???????

?????

????? ??? ?????? ??? ???????.
???? ??? ?????? | ????? ???????

??????? ????

????? ????? ????? ?? ????

??????? ????????? ???????? ??????? ??? ????? ????? ?????:

??????: ???? ????????? ?? ????????? ???????? ???????? ??? ????????? ??? ?????? ??? ???????. 
import java.sql.*;
import java.io.*;


public class Repro{

	public static void main(String args[])
	{
		try {
			Connection con;
			Statement s1 = null;
			ResultSet r1 = null;
			Statement s2 = null;
			ResultSet r2 = null;
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); 
			con = DriverManager.getConnection(
				"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs;SelectMethod=Direct;User=User;Password=Password");
			//fix 1
				//"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs;SelectMethod=Cursor;User=User;Password=Password");
			con.setAutoCommit(false);
			
			try {
				s1 = con.createStatement();
				r1 = s1.executeQuery("SELECT * FROM authors");
				
				//fix 2
				//r1.close();
				//s1.close();

				s2 = con.createStatement();
				r2 = s2.executeQuery("SELECT * FROM publishers");
			}
			catch (SQLException ex)
			{
				System.out.println(ex);				
			}
		
		}
		catch (Exception e)
		{
			e.printStackTrace();
		}
	}
}
???? ??? ?????? | ????? ???????

?????

????? ?? ????????? ??? "??????? ???????" ???? ?????? "????? ????? ???????" ?? ?????? Microsoft SQL Server 2000 ????? ??????? HTML JDBC ?? "???? ??? ??????".?????? ??? ??????? ?????? ??? ????????? ????????? ?? ?????? ??????? ???? ??? ??? ??????? ????? ?????? ?? "????? ??????? ?? Microsoft:
313220
(http://support.microsoft.com/kb/313220/EN-US/ )
PRB: ??????? ??? ????? ?? SQL Server ?? JDBC
???? ??? ?????? | ????? ???????

???????

???? ???????: 313181 - ????? ??? ??????: 30/???? ??????/1424 - ??????: 2.0
????? ???
  • Microsoft SQL Server 2000 Driver for JDBC
????? ??????: 
kbmt kbprb KB313181 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????313181
(http://support.microsoft.com/kb/313181/en-us/ )
????? ??????? ?? ????? ???? ?? ????? ???????
?? ????? ????? ?????? ???? ???? ???? ??? ??????? ??? ?? ? ?? ??? ??????? Microsoft ??? ????? ??? ??????? ????? ?????? ?????
???? ??? ?????? | ????? ???????

????? ???????

 
???? ??? ?????????? ??? ??????