Great news! We just released JDBC v1.2 RTW with SSL support. Here are some tips to help you during development. 1) We have new connection properties for SSL: encrypt, trustServerCertificate, hostNameInCertificate, trustStore, trustStorePassword. ...

Long time, no see:-) Well, I'm back with great news! After a full year of hard-core development, JDBC v1.2 RTW is now publicly available. Here is why you should switch to v1.2 RTW (or start using it!) 1) It supports SSL encryption! 2) It's faster...

Finally, we can talk about how Microsoft SQL Server 2005 JDBC driver handles Calendar objects and temporal values. Data retrieval seems like a good enough point to start. You can use ResultSet and CallableStatement getDate/getTime/getTimestamp methods...

Before we move onto how Microsoft SQL Server 2005 JDBC driver handles Calendar arguments, let's take a look at Date, Time and Timestamp objects to make sure we are on the same page. Date, Time and Timestamp are the three temporal classes contained in...

This is the first of a series of posts I will dedicate to Calendar object in Java and how it interacts with JDBC API. Before moving onto JDBC API let's make sure we get the Calendar basics right. Java.util package contains 4 temporal classes: Calendar...

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...

Today we released JDBC Driver 1.1 CTP 2. The release contains bug fixes and two new features since v1.0, Database Mirroring and Integrated Authentication. I will be posting an example to demonstrate how to use Database Mirroring. In the meantime, the...

If you are porting your JDBC application for SQL Server from 1.4 JVM to 1.5 JVM you might run into problems caused by the breaking change in the toString method of Big Decimal class. Namely, the following code prints out different values across different...

Welcome! I'm one of the few developers at Microsoft who indulge in Java code 95% of their time at work. For the past 7 months I've had the privilege of being part of a very special team at Microsoft, Microsoft SQL Server 2005 JDBC Driver development team...