Does Microsoft's MS-SQL Server JDBC 3.0 driver include support for JTA?

Question

Hi,
I read somewhere that in order to use JTA and Tomcat (I'm also using Hibernate) you need to use a JTA version of the JDBC driver. Is this true?
If so, does this driver include JTA support?

Thanks,
Ittai

Answer 1

Yes, it does. See com.microsoft.sqlserver.jdbc.SQLServerXADataSource. You can also read more on XA transactions with MS SQL here

Answer 2

But having the XA driver is necessary but not sufficient. You have to have a JTA transaction manager as well, and that's not part of JDBC.

Answer 3

I've always used the jTDS driver for MS SQL Server.
MS SQL Server, was built from a base acquired from Sybase, therefore they both use Tabular Data Stream as a protocol.

And as duffymo has said you'll need a JTA transaction manager such as :

• JBossTS
• or Atomikos