FIX: You receive a java.lang.StackOverFlowError exception when you execute lots of PRINT statements through the SQL Server 2000 Driver for JDBC (894563)

MORE INFORMATION

Steps to reproduce the behavior

import java.sql.*;
public class Test
{
	public static void main(String[] args) throws Exception
	{
		Connection conn = null;
		int number = 5000;
		boolean crash = false;
	
		try 
		{
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

			String url = "jdbc:microsoft:sqlserver://<Server>:1433;DatabaseName=master;";
			conn = DriverManager.getConnection(url, "<UserId>", "<Password>");
			conn.setReadOnly(true);
		
			// Loop until the fixed limit is reached.
			while(true && (number < 50000)) 
			{
				// Generate SQL code.
				System.out.println("\nGenerating " + number + " statements in memory.");
				StringBuffer sb = new StringBuffer("BEGIN TRANSACTION\n");
				for (int i=0; i<number; i++) 
				{
					sb.append("PRINT 'Hello world !'\n");
				}
				sb.append("COMMIT TRANSACTION\n");
			
				// Execute code.
				System.out.println("Executing code.");
				conn.clearWarnings();
				Statement stmt = conn.createStatement();
				stmt.execute(sb.toString());
			
				// Get warnings.
				System.out.println("Retrieving warning messages.");
				crash = true;
				SQLWarning warnings = stmt.getWarnings();
				crash = false;
				System.out.println("Retrieved all warnings succesfully!");
			
				// Increase the number of PRINT statements to send.
				number += 1000;
			}
		}
		catch(Exception e) 
		{
			e.printStackTrace();
		}
		finally 
		{
			if(conn != null) 
			{
				conn.close();
			}
		}

		System.out.println("\nEnded with " + (crash ? "crash on " + number + " statements processing!" : "no errors."));
	}
}