Hi,

I was wondering on how we could implement a pool of pools with hibernate.

By pool of pools I meant that we could have connection pools such as dbcp
pointing to various databases. During runtime, the application dynamically
chooses which database to use and picks up a connection from that
databases pool.

Any ideas?

Regards
Gyanesh

Write your own ConnectionProvider :-)

I am trying pool of pools again after a long time.

Connection Provider, it seems, indicates a Connection for a given Session obtained from a SessionFactory.

In a Pool of Pools scenario we attach a name for each pool (eg: PoolsForOracleDB, PoolsForFirebirdDB etc). I am not too sure how to bring in Pool of Pools using Connection Provider but for the same obtained Session!

Also, how to extend transaction for different connections from different Pools (PoolsForOracleDB, PoolsForFirebirdDB etc) in the same Session object? This way we can tx.commit() / s.flush() etc will ensure that connections to various databases is done in one shot in the same session.

Kindly help me with adivce and preferable a skeeton code if possible.