[jboss-user] [JCA/JBoss] - Re: Datasource failover, sudden disconnection not working

Correct, I had to add a parameter in the connection url, I set the socketTimeout in 5000 milliseconds in this way: <connection-url>jdbc:mysql://192.168.10.210:3306/POK2?socketTimeout=5000|jdbc:mysql://192.168.10.219:3306/POK2?socketTimeout=5000</connection-url> For anyone looking at mysql failover, take a look at here: http://dev.mysql.com/doc/refman/5.0/es/connector-j-reference-configuratio... (Not exactly mysql failover, but very usefull) Thanks View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4031185#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...