File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Display datasource isolation level

 
Sugantha Jeevankumar
Ranch Hand
Posts: 93
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All.. I just want to know if there is a way to display the actual transaction isolation level used by my JBoss datasource. My datasource configuration looks like below,



I understand MySql uses TRANSACTION_REPEATABLE_READ by default and I am trying to override it with TRANSACTION_READ_COMMITTED for all transactions originating from my application. Is there anyway to check, if the datasource is indeed using TRANSACTION_READ_COMMITTED. JBoss' JMX console did not show much under "name=template/datasource,service=DataSourceBinding" node and server.log also did not reveal much. Any help is appreciated.
 
Jaikiran Pai
Marshal
Pie
Posts: 10444
227
IntelliJ IDE Ubuntu
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You'll have to check it on the Connection object returned by the DataSource. For example:

 
Sugantha Jeevankumar
Ranch Hand
Posts: 93
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Jaikiran.. I was hoping there would be a non-intrusive way to do this, since I need to check the isolation level in use in a production machine. Any more suggestions are welcome.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic