]
Anders Wallgren updated HHH-4106:
---------------------------------
Attachment: screenshot-1.jpg
SQLStateConverter treats SQLServer snapshot isolation exception as a
SQLGrammarException
----------------------------------------------------------------------------------------
Key: HHH-4106
URL:
http://opensource.atlassian.com/projects/hibernate/browse/HHH-4106
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.3.2
Environment: SQL Server 2008, SQL Server 2005, jtds 1.2.2 JDBC driver
Reporter: Anders Wallgren
Attachments: screenshot-1.jpg
A SQLException thrown due to a snapshot isolation conflict gets treated as a
SQLGrammarException
The SQLState is S0005 and the vendorCode is 3960. The error message is: Snapshot
isolation transaction aborted due to update conflict. You cannot use snapshot isolation to
access table 'dbo.XXX' directly or indirectly in database 'XYZ' to update,
delete, or insert the row that has been modified or deleted by another transaction. Retry
the transaction or change the isolation level for the update/delete statement.
This should be turned into an optimistic locking exception, or something like that.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: