Hibernate version:3.1.1

Name and version of the database you are using: MySql 5.0.22

Jdbc driver:mysql connecter 3.1.13

I'm attemptiong to set up a slave mysql server in our satellite office to improve performance of database reads.
As instructed by mysql Connector I have supplied com.mysql.jdbc.ReplicationDriver as the driver class name in spring.
When readOnly is set to true on the provided connections provided it will connect to the slave instead of the master.

I easily added the read only hint to the Transaction however this is not getting carried on to the JDBC connection

I am unable to see at this point how to have Hibernate give this hint to the connection.

How can I set up hibernate to provide the readOnly hint to the JDBC Connection?

You can access the Connection object and set the readOnly property. A similar post is at :

http://forum.hibernate.org/viewtopic.php?t=962639&highlight=