WARN [main] org.jboss.messaging.core.impl.JDBCPersistenceMa

[centina]

WARN [main] org.jboss.messaging.core.impl.JDBCPersistenceManager


JBoss Messaging Warning: DataSource connection transaction isolation should be READ_COMMITTED, but it is currently REPEATABLE_READ.
 Using an isolation level less strict than READ_COMMITTED may lead to data consistency problems.
 Using an isolation level more strict than READ_COMMITTED may lead to deadlock.

hello all
Since my migration frm 4.2.2 to jboss 5.0.0 i am facing the above warning message. Can some one throw some light on this ?

[peterj]

What database are you using for messaging? I added the following line to the *-ds.xml file that I use for the messaging data source:

<datasources>
 <local-tx-datasource>
 ...
 <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
 ...
 </local-tx-datasource>
</datasources>

[centina]

Thanks for the info. I am using Mysql. the <transaction-isolation> tag fixed the issue.