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

[sebastianlacuesta]

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-configuration-properties.html
(Not exactly mysql failover, but very usefull)
Thanks

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

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