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

[Jonathan Halliday (JIRA)]

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