[jbossts-issues] [JBoss JIRA] Closed: (JBTM-460) fix sybase locking in DTF JDBC tests

Jonathan Halliday (JIRA) jira-events at lists.jboss.org
Wed Jan 7 09:05:17 EST 2009


     [ https://jira.jboss.org/jira/browse/JBTM-460?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jonathan Halliday closed JBTM-460.
----------------------------------

    Resolution: Done


> fix sybase locking in DTF JDBC tests
> ------------------------------------
>
>                 Key: JBTM-460
>                 URL: https://jira.jboss.org/jira/browse/JBTM-460
>             Project: JBoss Transaction Manager
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>          Components: Testing
>    Affects Versions: 4.5
>            Reporter: Jonathan Halliday
>             Fix For: 4.6
>
>
> Some DTF JDBC tests use multiple connections (i.e. XA tx branches) to manipulate the same table. Where the database does not share locks between tx branches and does not use row level locking this causes deadlock problems. For MS SQLServer we force row level locking by creating a uniq index on the table. For sybase this does not work. Therefore, we need to explicitly detect that the test is running against sybase and issue db specific SQL to force row level locking.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        



More information about the jbossts-issues mailing list