Hi,

Thank you all for an excellent product.

We are using Oracle 10g database with Hibernate 3.1.3, running on Tomcat.

We want to implement the Oracle DataGuard feature, in order to enable runtime switch between two databases.

What is the best strategy for doing this?

In the Oracle documentation there is one available example, in this example they configure an OracleDataSource object to set the neccessary parameters in order to enable what is called "Fast Connection Failover".

From the Oracle Client Failover documentation (p. 13):
http://www.oracle.com/technology/deploy/availability/pdf/MAA_WP_10gR2_ClientFailoverBestPractices.pdf
The client application must use implicit JDBC connection cache on its data source by setting the DataSource property FastConnectionFailoverEnabled to true. For example:

OracleDataSource ods = new OracleDataSource()
...
ods.setUser("hr");
ods.setPassword("hr");
ods.setConnectionCachingEnabled(True);
ods.setFastConnectionFailoverEnabled(True);
ods.setConnectionCacheName("MyCache");
ods.setConnectionCacheProperties(cp);

Do we have to resolve this by implementing our own ConnectionProvider and thus DataSource classes?

Or is there any simpler approach to resolve this (like perhaps property-support)?

Best regards,
Simon Öberg