FIX: The client connection may end when you insert an out-of-range datetime value in a server by using the SQL Server 2000 Driver for JDBC (894557)

MORE INFORMATION

String dateString = "2/03/15"
// Add "0" if the second character is "/".
String tmpString = dateString.substring(1,2);
if(tmpString.equals("/"))
{
tmpString = "0"
tmpString = tmpString.concat(dateString);
dateString = tmpString;
}

try
{
// Change the Year figures from 4(yyyy) to 2(yy)
//DateFormat formatter = new SimpleDateFormat("yyyy/MM/dd");
DateFormat formatter = new SimpleDateFormat("yy/MM/dd");

// remaining code
}

Steps to reproduce the behavior

1. Create a table by using the following script:

   USE pubs
   GO
   CREATE TABLE t1(test_varchar VARCHAR(255), test_date DATETIME)
   GO

2. Compile and then run the following Java code:

   import java.io.*;
   import java.sql.*;
   import java.text.*;
   import java.util.*;
   
   public class Test 
   {
   public static void main(String[] args)
   {
   PreparedStatement pstmt = null;
   Connection connection = null;
   java.sql.Date targetDate;
   String dateString = "2/03/15" // March 15, 2002
   
   try
   {
   Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver" );
   connection = DriverManager.getConnection("jdbc:microsoft:sqlserver://<Server>:1433;databasename=pubs;", "<UserId>", "<PassWd>");
   
   try 
   {
   DateFormat formatter = new SimpleDateFormat("yyyy/MM/dd");
   //DateFormat formatter = new SimpleDateFormat("yy/MM/dd");
   formatter.setLenient(false);
   targetDate = new java.sql.Date(formatter.parse(dateString).getTime());
   System.out.println("parsed without exception");
   } 
   catch (ParseException e) 
   {
   e.printStackTrace();
   return;
   }
   
   try 
   {
   System.out.println("before INSERT");
   pstmt = connection.prepareStatement("INSERT INTO t1 VALUES (?,?)");
   pstmt.setString(1, "test");
   pstmt.setDate(2, targetDate);
   pstmt.executeUpdate();
   pstmt.close();
   } 
   catch (Exception e) 
   {
   e.printStackTrace();
   } 
   finally 
   {
   if (pstmt != null)
   pstmt.close();
   }
   
   // Execute another query by using the same connection.
   try 
   {
   System.out.println("before SELECT 0");
   pstmt = connection.prepareStatement("SELECT 0");
   ResultSet rs = pstmt.executeQuery();
   } 
   catch (Exception e)
   {
   e.printStackTrace();
   }
   finally 
   {
   if (pstmt != null)
   pstmt.close();
   }
   
   connection.close();
   System.out.println("Finished.");
   }
   catch(Exception e)
   {
   e.printStackTrace();
   }
   }
   }

   Note In this code, replace the <Server>, <UserID>, and <Password> with the name of your computer that is running SQL Server, your user ID, and your password.