It seems that the new SQL 2008 'date' type is unsupported by the jTDS 1.2.4 driver. I didn't check the new 1.2.5 driver since it's not in Maven repo yet, but from the list of resolved issues it seems this issue was not addressed.
The jTDS 1.2.4 driver converts the 'date' type as java.lang.String but it should be 'java.sql.Date'. To reproduce this behavior, try to read a 'date' column from a result set by getObject(int) and you will receive a String. Also, when reading result set metadata with method getColumnClassName(int), String is returned.
Log in to post a comment.