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

[PeterJ]

This would require that you be able to set two connection URLs for a single datasource, and mark one to be used for reads and the other for updates. Such a thing is not possible at this time. The only option is to define two different data sources, configuring one to open the database in read-only mode if the database supports such a thing, and have your code select the data source it wants based on its needs.

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4204437#4204437

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4204437