I'm trying to use the MS JDBC driver with SQL server 2005 in a J2EE app server (JBoss). I need to use the XA datasource because I have multiple resources to update in a single transaction.
I want to use snapshot isolation because if I don't, I get frequent blocking and deadlocks. I am running with 1.1 CTP driver because the 1.0 XA driver would not work for me.
When I run in this configuration, I get the following error:
FINE: *** SQLException:[Thread[Thread-35,5,jboss], IO:0679d, Dbc:62a7b] com.microsoft.sqlserver.jdbc.SQLServerException: Transaction failed in database 'xx1' because distributed transactions are not supported under snapshot isolation. Msg 3963, Level 16, State 1, Transaction failed in database 'xx1' because distributed transactions are not supported under snapshot isolation.
Thread-35 2006-04-20 10:40:48,239 | WARN | session=1156 | user=assettest | ibernate.util.JDBCExceptionReporter | SQL Error: 3963, SQLState: S0001
So is snapshot isolation and distributed transactions not supported from a database perspective or a driver perspective Is there any other way to use the XA driver and snapshot isolation
Snapshot isolation and distributed transactions
Hot Topic
- SQLWB.EXE max cpu
- Msg 9772 -- Service Broker in database "" cannot be enabled
- Enable/Disable Job with SMO
- Bug?-when using nested subreports in combination with list
- Stored procedure
- SQL Server 2005 Replication and views
- Report Builder - is this a bug or is it by design?
- Problem with Failure Constraint
- Database is read-only.
- MDAC 2.8 Fatal Setup Error. This setup does not support installing on this operating system
SQL Server
- SQL 2005 left join not working via OLEDB
- Access to SQLServer Database from Visual C# app and ASP.NET app
- How keep together table rows?
- Changing column data type to Unicode data type
- Importing Excel data that spans rows
- Rounding number with ending equals 5
- XACT_ABORT
- Calculations tab - MSAS 2005
- Forcefully Disconnect All Users and Drop a Database
- ADOX - Create MDB problem - data source containing keyword "System" or "Windows"
Snapshot isolation and distributed transactions