[jboss-user] [JCA/JBoss] - Re: mysql datasource with read-only and write nodes

Ok, thanks The datasources are used for persistence, so the workaround that I did was similar to the post i mentioned. 1 - mysql: grant select only on RO nodes, and insert / update / etc on RW nodes 2 - create 2 datasources, to ro and rw nodes 3 - create 2 persistence units, each one using a different datasource 4 - set persistencecontext / unit in the bean. implement all database writes in a different bean, using the rw persistence unit. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4205158#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...