title: TransactionManager read-only=true does not work with mysql ReplicationDriver
body: <p>We are using com.mysql.jdbc.ReplicationDriver to connect Master/Slave. We configure the transactionManager as follow.  </p>
  
  <pre><code>&lt;bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager"&gt;
      &lt;property name="sessionFactory" ref="sessionFactory" /&gt;
  &lt;/bean&gt;
  
  &lt;tx:advice id="txHbAdvice" transaction-manager="transactionManager"&gt;
      &lt;tx:attributes&gt;
          &lt;tx:method name="get*" read-only="true" /&gt;
      &lt;/tx:attributes&gt;
  &lt;/tx:advice&gt;
  </code></pre>
  
  <p>I set the read-only parameter to true but it doesn't set <code>java.sql.Connection.setReadonly()</code> method to true. All the read queries are still come to master server.</p>
  
  <p>There is an open issue for similar problem <a href="https://jira.springsource.org/browse/SPR-8303" rel="nofollow">here</a> . Is there anyone having a solution to this problem?</p>