Using Calendars with JDBC API

   For me timezone handling has been one of the harder concepts in developing a JDBC driver for SQL Server. The main problem here is that SQL Server, for better or worse, is timezone unaware. JDBC API, on the other hand, requires a driver to understand and respond correctly to timezones. What "correctly" means, now that's a difficult question. We recently released our second QFE on Calendar getters and setters and we hope to have come much closer to understanding how our customers want us to handle timezones. I will be posting explanations regarding this QFE and how Microsoft SQL Server 2005 JDBC driver handles calendar arguments. In the meantime you can request this QFE using the KB article number 921208. As always we would love to receive feedback from you.

For feedback on the driver: https://connect.microsoft.com/sqlserver