Re: Can't get datasource failover working with JBoss

[Terry Ray]

Just to follow up, Adrian from JBoss posted a solution on their forum which fixed the problem. Instead of using the autoReconnect parameter on the jdbc URL, I added a check-valid-connection-sql tag inside the local-tx-datasource definition and filled it with an sql statement that would determine if my primary connection was still open. Example:

<check-valid-connection-sql>select * from my_table</check-valid-connection-sql>


This works fine!

Thanks