Hi,

we are using Hibernate with Tomcat and DBCP connection pooling engine in our project, and it works very good so far. As database we are using a single Oracle instance. Now we are thinking about different DB clustering solutions in order to minimize/avoid application downtimes due to database downtimes. Oracle cluster seems to be a very expensive option, so we are looking for an acceptable alternative. I.e. we need some mechanism which can serve several Oracle instances (which possibly interact via replication) transparently to the application. Is there any opportunity to do that with some smart connection pooling engine, or are there any architectural possibilities to do that at the Hibernate level, e.g. if I execute a HQL query and one DB instance is not available then query is dispatched to another DB instance?

Regards,
Michail.

You should probably try a clustered JDBC driver.

thank you for the quick reply. Do you know some clustered JDBC driver for Oracle? I've heard that WebLogic has something like that...

Michail.

try CJDBC