Share via

SQL Server, JDBC, XA, and Windows 7

  • Article

One of the Support Engineers on my team approached me the other day and asked if the SQL Server 2005 JDBC driver we ship works out of the box with XA transactions on Windows 7.  I am embarrassed to say that I did not know the answer off the top of my head.  I figured they would, but given the trouble we had getting them working on Windows XP (it was broken until sometime after XP SP2), I wanted to double-check.

I used a slightly tweaked version of the code from our MSDN site https://msdn.microsoft.com/en-us/library/aa342335(SQL.90).aspx and it worked fine the first time through.

Since the 2.0 JDBC driver shipped prior to Windows, it means that my Development counterparts either did their homework ahead of time and tested with the near-RTM code or the Windows 7 Backwards Compatibility folks did their homework and tested the JDBC driver.  Yay!!!

P.S.  I hope at least one of the two possibilities is true – otherwise we just got really lucky!!