title: In hibernate how to programmatically set the isolation level of a transaction, or how to create two transactions with different isolation levels
body: <p>I'm using hibernate 3.6 with MSSQL 2005, 2008, 2012.</p>
  
  <p>I would like to set the isolation level of a transaction created by the session, but I can't find any information about in.</p>
  
  <p>This is my code</p>
  
  <pre><code>   Session sess = factory.openSession();
     Transaction tx = null;
     try {
         tx = sess.beginTransaction();
  
         // do some work
         ...
  
         tx.commit();
     }
     catch (RuntimeException e) {
         if (tx != null) tx.rollback();
         throw e; // or display error message
     }
     finally {
         sess.close();
     }
  </code></pre>
  
  <p>I would like an to do something like that</p>
  
  <pre><code>   sess.beginTransaction(1|2|4|8);
  </code></pre>
  
  <p>Is that possible?</p>
  
  <p>Thank you.</p>