FIX: JDBC Driver Overwrites Timestamp Parameter Values with the Last Value Set (818504)

Steps to Reproduce the Problem

1. From SQL Query Analyzer, create the following table, and insert different values for each column:

   CREATE TABLE Test (Date1 DATETIME, Date2 DATETIME, Date3 DATETIME)
   INSERT INTO Test VALUES ('2001-JAN-01', '2002-FEB-02', '2003-MAR-03 11:45')
   

   Note the values that you just inserted:

   SELECT * FROM Test

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 appropriate for your environment.

   import java.util.*;
   import java.sql.*;
   
   public class UpdateDate
   {
           
   	public static void main (String args [])
   	{
   
   		try
   		{
   
   			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver" ).newInstance();
   
   			Connection connection1 = DriverManager.getConnection("jdbc:sqlserver://myServer:1433;databaseName=myDatabase","userid","password");
   		
   			//Set parameter index
   			int parmIndex = 1;
   
   			//Initialize a Timestamp object 
   			Timestamp ts = new Timestamp(new java.util.Date().getTime());
   			
   			PreparedStatement updStmt = null;
   			String UPDSTMT = "UPDATE Test SET Date1 = ?, Date2 = ?, Date3 = ?";
   			
   			try
   			{
   				updStmt = connection1.prepareStatement(UPDSTMT);
    				
   				//setTime for the first parameter by using the ts timestamp object
   				ts.setTime(100);
   				updStmt.setTimestamp(parmIndex++, ts);		
   				
   				//set a different time for the second parameter by using the same ts timestamp object						
   				ts.setTime(2000);
   				updStmt.setTimestamp(parmIndex++, ts);
   						
   				//set a different time for the third parameter by using the same ts timestamp object		
   				ts.setTime(30000);
   				updStmt.setTimestamp(parmIndex++, ts);
   								
   				updStmt.execute();
   			}
   			catch (SQLException e)	
   			{
   				System.out.println(e.getMessage());
   			}
   			
   			connection1.close();
   			
   		}
   		catch(Exception e)
   		{
   			System.out.println(" Exception = " + e );
   		}
   
   		return;
   	}
   
   }
   

3. Query the table from Query Analyzer:

   SELECT * FROM Test

   Notice that all the 3 datetime columns have the same value as the last datetime column.

updStmt.setTimestamp(parmIndex++, new Timestamp(100));
updStmt.setTimestamp(parmIndex++, new Timestamp(2000));
updStmt.setTimestamp(parmIndex++, new Timestamp(30000));