Hi, just wonder if 2000 jdbc driver sp 3 supports XA? I'm using Sun Application server 8. When I was configuring my connection pool, I select com.microsoft.jdbcx.sqlserver.SQLServerDataSource as the datasource classname. When I select resource type as javax.sql.DataSource, transaction did not rollback using JTA. But if I select resource type as javax.sql.XADataSource, everything works fine. Does 2000 jdbc driver sp 3 supports implements javax.sql.XADataSource? Also, where to find 2000 driver sp 3 api? Thanks, wailai
The 2000 JDBC driver does support XA. There are two folders called JTA that come with a default installation that have the DLLs and the TSQL for the installation. However, I would strongly suggest you consider looking at the SQL Server 2005 JDBC driver. That can be used with SQL 2000 and is the most current version of our JDBC driver. Evan "wailai" wrote: > Hi, just wonder if 2000 jdbc driver sp 3 supports XA? I'm using Sun > Application server 8. When I was configuring my connection pool, I select > com.microsoft.jdbcx.sqlserver.SQLServerDataSource as the datasource > classname. When I select resource type as javax.sql.DataSource, transaction > did not rollback using JTA. But if I select resource type as > javax.sql.XADataSource, everything works fine. Does 2000 jdbc driver sp 3 > supports implements javax.sql.XADataSource? Also, where to find 2000 driver > sp 3 api? > > Thanks, > wailai >
