FIX: Unsupported Data Conversion Error Occurs When You Use a Null Timestamp in JDBC (827221)

MORE INFORMATION

Steps to Reproduce the Problem

1. Use the following SQL to create a table in your SQL Server database:
   

   CREATE Table JVER1timestamp (K1INT INTEGER NOT NULL,FTSTAMP DATETIME)

2. Insert sample data with the following SQL code:
   

   INSERT INTO JVER1timestamp values (1, NULL)
   INSERT INTO JVER1timestamp values (2, getdate())
   

3. Compile and run the following Java code to reproduce the problem:

   import java.sql.*;
   import java.util.Calendar;
   
   public class TimeStampCalendar
   {	
   	public static void main(String[] args) 
   	{
   		try 
   		{
   			// Get a connection
   			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
   			// note: modify connection to reflect local database name, user name, and password                  
   			Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://servername:1433;DatabaseName=pubs", "uid", "pwd");
   
   			Statement stmt = null; 
   			stmt = conn.createStatement();
   
   			//execute statement			
   			ResultSet rs = null;
   			rs= stmt.executeQuery("select FTSTAMP from JVER1timestamp order by K1INT");
   
   			while(rs.next())
   			{
   			//System.out.println(rs.getTimestamp(1)); //this version of getTimestamp does not reproduce the error
   				System.out.println(rs.getTimestamp(1,Calendar.getInstance())); 
   			}			
   		}
   		catch (Exception e) 
   		{
   			System.out.println(e.getMessage());
   		}
   	}
   }

   The following exception error and call stack occurs:

   java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Unsupported data conversion.
           at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
           at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
           at com.microsoft.jdbc.base.BaseData.unsupportedConversion(Unknown Source)
           at com.microsoft.jdbc.base.BaseData.getTimestamp(Unknown Source)
           at com.microsoft.jdbc.base.BaseResultSet.getTimestamp(Unknown Source)
           at TimeStampCalendar.main(TimeStampCalendar.java:24)