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:
313220PRB: ??????? ??? ????? ?? SQL Server ?? JDBC

???????

???? ???????: 313181 - ????? ??? ??????: 30/???? ??????/1424 - ??????: 2.0
????? ???
  • Microsoft SQL Server 2000 Driver for JDBC
????? ??????: 
kbmt kbprb KB313181 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????313181
????? ??????? ?? ????? ???? ?? ????? ???????
?? ????? ????? ?????? ???? ???? ???? ??? ??????? ??? ?? ? ?? ??? ??????? Microsoft ??? ????? ??? ??????? ????? ?????? ?????

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

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com