AbstractRoutingDataSource for failover?

[bgardner]

We have a situation where our data is loaded into one (Oracle) database instance, and then is streamed to another. In the event that the main instance fails, we want our batch loaders to be pointed to the second instance. I've taken a look at using AbstractRoutingDataSource (including reading Mark Fisher's blog article on Dynamic DataSource Routing), and that looks like it might be a good candidate. However, that appears to be better for switching when starting a connection, and I'm not sure we could have a DAO which extends SimpleJdcbDaoSupport detect the lack of connection, and then subsequently failover to the other connection.

Any thoughts?

Brian

[wanner]

Any thoughts about this?