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

I read somewhere that in order to开发者_Python百科 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

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

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.

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