FIX: String Output Parameters Truncated to 4000 Characters with JDBC (817419)

Steps to Reproduce the Problem

1. Create the following stored procedure in your SQL Server database:

   CREATE  proc largeCharProc @outData VARCHAR(8000) OUTPUT 
   as
   --create a string with 8000 characters, all '*'
   Set @outData = REPLICATE('*', 8000)
   
   --replace the 4000th character with M so you can easily spot it in the output
   Set @outData = STUFF(@outData, 4000, 1, 'M')
   
   --replace the last character with X so you can easily spot it in the output
   Set @outData = STUFF(@outData, 8000, 1, 'X')

2. Compile, and then run the following Java code.
   
   Note You must replace the server name, user id, and password in the connection string as appropriarte for your environment.

   import java.util.*;
   import java.sql.*;
   import java.io.*;
   
   public class Class1
   {
   	public static void main (String[] args)
   	{
   		try
   	        {
   						
   			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver" ).newInstance();
   			Connection connection1 = DriverManager.getConnection("jdbc:microsoft:sqlserver://myServer:1433;Databasename=myDatabase;SendStringParametersAsUnicode=False;","userid","password");
   						
   		 	CallableStatement pStmt = null;
   			String strSQL = "{call largeCharProc(?)}";
   			pStmt = connection1.prepareCall(strSQL);
   			pStmt.registerOutParameter(1, Types.VARCHAR);
   			pStmt.execute();
   			
   			String outnesting = pStmt.getString(1);
   			System.out.println(outnesting);
   			System.out.println(String.valueOf(outnesting.length()));
   			
   			connection1.close();
    		}
    		catch(Exception e)
    		{
    			System.out.println(e.getMessage());
    		}
   		
   		try
   		{
   			System.out.println("Press any key to quit....\n");
   			System.in.read();
   		}
   		catch (Exception ioe)
   		{
   			System.out.println("caught");
   		}
   	}
   }

3. Notice the output from the code. Before you apply the fix, you see that 4000 characters are returned. After you apply the fix, all 8000 characters are returned.