title: Spring Isolation Support? MSQL Snapshot Isolation
body: <p>We are using SQL Server and it is possible that Snapshot isolation may be a good way to improve out performance and fix some deadlocking concerns. </p>
  
  <p>Assuming that we have a real need to change to Snapshot isolation, I can't seem to find an easy way to enable Snapshot isolation on Springs <code>@Transactional</code>.</p>
  
  <p>I found the following hibernate configuration option for doing it in Hibernate, however we use spring-jdbc and don't have a hibernate impl. this seems to suggest that the isolation value could be provided manually somehow.</p>
  
  <pre><code>&lt;property name=”hibernate.connection.isolation”&gt;4096&lt;/property&gt;
  </code></pre>
  
  <p>Does anyone know of a way of getting Spring to use SQL Server Snapshot isolation on transactions?</p>