[jboss-user] [JCA/JBoss] - Re: mysql datasource with read-only and write nodes
brettcave
do-not-reply at jboss.com
Wed Jan 28 04:51:02 EST 2009
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#4205158
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4205158
More information about the jboss-user
mailing list