Mysql replication and JBOSS

[tricky]

I have mysql replication stuff installed master slave (where insert,update uses master and select's are on slave) does anyone know how to setup *-ds.xml file to work with mysql replication driver ? or maybe peristence.xml ?

[vickyk]

"tricky" wrote:
I have mysql replication stuff installed master slave (where insert,update uses master and select's are on slave) does anyone know how to setup *-ds.xml file to work with mysql replication driver ? or maybe peristence.xml ?

Have you searched the required property in mysql driver's documentation ?

[tricky]

I did "setReadOnly" but it cannot be set - using netbeans. When i set it manually in xml it doesn't work and EnitytManager always makes selects from master database

[vickyk]

"tricky" wrote:
I did "setReadOnly" but it cannot be set - using netbeans. When i set it manually in xml it doesn't work and EnitytManager always makes selects from master database

I don't think setReadOnly would be the property which would set the replication feature , I was expecting the driver property containing such info .
Where did you findout that setting the readOnly will be helpful ?

[edavis]

Did you managed to get it working? I need the same