There is a new topic by xhyi available at the DataCleaner forum: jtds connector incorrect with Date type for Sql server 2008
-------------------
When register the mssql with the default jtds connector,the source metadata is incorrect with date type,it should be Date but turn out to be varchar.
Although I finally fix the it by change the connect to the official connector provided by Microsoft ,but I still think it's a bug should to be noticed.
-------------------
Please visit this URL to follow along in the discussion:
http://datacleaner.org/topic/395/-jtds-connector-incorrect-with-Date-type-for-Sql-server-2008