-
1. Re: Does Minerva support JDBC Multipools
davidjencks Jan 8, 2002 5:22 PM (in response to kubokushi)Not that I know of. Could you explain or provide a reference to an explanation of how this is an improvement over plain ordinary pooling where all items in the pool are equal?
-
2. Re: Does Minerva support JDBC Multipools
bacchu_anjan Mar 27, 2002 3:48 PM (in response to kubokushi)Hi,
Weblogic 6.x has this feature.
Say, you setup Oracle so that there is a primary database and a replicating database. A multi-pool is set up such that by default, the primary database is hit. But if the primary database goes down, the secondary(replicating) database starts getting hit from the connection pool. Does that make sense ?
Best Regards,
ANJAN. B -
3. Re: Does Minerva support JDBC Multipools
oravecz Mar 27, 2002 4:10 PM (in response to kubokushi)I'm surprised that the vendor's JDBC driver doesn't transparently failover in these situations.
How does the app server know that the "primary" pool should not be used because the database is down, and not just some other SQL Exception (like a dead connection because the db was recycled)? -
4. Re: Does Minerva support JDBC Multipools
bacchu_anjan Mar 27, 2002 4:29 PM (in response to kubokushi)Hi,
The driver needs to be configured to do the fail-over.
There are a few semantics which can be used by the pool driver to implement the fail-over. One possibility is to ping the Database Driver to see if it's alive(what "alive" means can be debated).
None of these implementations are standard across App Servers. So far, they have not made their way into most other connection pools.
Best Regards,
ANJAN. B