FIX: Error message when you execute multiple statements in a batch command that does not return a result set in the SQL Server 2000 Driver for JDBC: "Statements that produce result sets are not allowed in batch commands" (894555)

MORE INFORMATION

Steps to reproduce the behavior

import java.sql.*;

public class template

{

     public static void main(String[] args) throws Exception

     {

            java.sql.Connection  con = null;

            PreparedStatement p = null;

		 try

		 {

			 Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); 

			 con = java.sql.DriverManager.getConnection

				 ("jdbc:microsoft:sqlserver://localhost:1433;databaseName=pubs;selectMethod=cursor", "uid", "password");

 

			 p = con.prepareStatement("set nocount off");

			 p.addBatch();

			 p.executeBatch();

 

			 p.close();

			 p=null;

			 con.close(); con=null;

		 }

		 catch (SQLException ex)
		 {
			 while (ex != null)
			 {
				 System.out.println ("SQLState: " + ex.getSQLState ());
				 System.out.println ("Message:  " + ex.getMessage ());
				 System.out.println ("Vendor:   " + ex.getErrorCode ());
				 ex = ex.getNextException ();
				 System.out.println ("");
			 }
		 }
	
		 catch(Exception e)
		 {
			 e.printStackTrace();
			 System.out.println("Error Trace in getConnection() : " + e.getMessage());
		 }


     }

}

SQLState: HY000
Message:  [Microsoft][SQLServer 2000 Driver for JDBC]Statements that produce result sets are not allowed in batch commands.
Vendor:   0