@TransactionAttribute(TransactionAttributeType.REQUIRES_NEW)

[shmendrick]

Hi, my jboss(version 4.0.3 with EJB3.0 beta 1) freez when method with @TransactionAttribute(TransactionAttributeType.REQUIRES_NEW) annotation is invoced. The problem appears with MS SQL server 2000. It is ok with Oracle. Can I do something, or this is a bug?

[bill.burke]

sounds like a bug in mysql not jboss

[shmendrick]

No, its MS SQL 2000. Could it be because of driver configuration? Thanks

[shmendrick]

I have tried with 2 different JDBC drivers for MS SQL 2000 but I have the same problem. Does anyone used the @TransactionAttribute(TransactionAttributeType.REQUIRES_NEW) on MS SQL 2000?

[alximik]

I've used this feature on MSSQL and got deadlocks too. The server freezes when reading/updating the data locked by the previous (still active) transaction.

The problem has been solved by setting transaction isolation level to read uncommited in the new transaction.