This is normally set on your datasource configuration.
You should ask in the JCA user forum for more details.
Thanks for the reply.
I just followed the steps given in JBoss Messaging document and also changed the database to be MySQL as given in the JBoss Message document.
Your reply note says that only at database side these isolation level need to be changed and not at JBoss messaging deployment side(JBOSS_HOME/server/messaging). I used to change the configuration of which database to be used only at JBoss Messaging side(like whether i should use MySQL or Oracle etc).
I thought we could change the isolation level with some configuration file at the JBoss Messaging deployment side(JBOSS_HOME/server/messaging) rather at database side.
Kindly advice me
Your reply note says that only at database side these isolation level need to be changed and not at JBoss messaging deployment side(JBOSS_HOME/server/messaging).
No, I didn't say that.
If you look in your mysql-persistence-service.xml (or clustered-mysql-persistence-service.xml) file, you will see it references a particular datasource
This is the datasource JBoss Messaging will use. By default it's value is DefaultDS. You can change it to use any DataSource you want.
In JBoss AS, datasources are typically deployed in the server/<server-name//deploy directory with names like mysql-ds.xml. This is the data source configuration file.
This link will show you how to configure the datasource including how to set the transaction isolation.
Thanks Very much for the valuable information.
I could able to change my datasource isolation level to required one for MySQL