Can JBoss have DB Multipools (or pool of pools)?

[billa007]

Can't seem to find a way where we can configure a JBoss Datasource which points to two or more dataBases. In Weblogic it is called Multipools (or "pool of pools")

There is something with Oracle driver where we can configure more then one DataBase in a Datasource (<connection-url>jdbc:oracle:thin:@(description=(address_list=(load_balance=on)(failover=on)(address=(protocol=tcp)(host=host1)(port=1521))(address=(protocol=tcp)(host=host2)(port=1521)))(connect_data=(service_name=xxxxsid)(failover_mode=(type=select)(method=basic))))</connection-url>)

But this only seems to work for Oracle RAC. I could not make it work with a non-RAC oracle DB.

Any help will be appreciated... Any document reference will be very good. Thnaks

[peterj]

You can define only a single URL for each datasource, thus you can connect to only one database.

You can define multiple datasource entries in a *-ds.xml file, though.

[billa007]

Well, the example I mentioned above, Oracle does provide a way to connect to more then one db (more then one server).

I was incorrect in saying it only works with RAC. It does work with plain oracle DB.

The only problem is that it HAS to have the same SID on both servers. So in is not a TRUE pool of pools. So it is one Datasource for multiple Oracle databases with SAME SID. And it only applies to Oracle.

What I want to know is if JBoss has a way to define a dataSource pointing to multiple db's or DataSources.

thanks

[peterj]

What I want to know is if JBoss has a way to define a dataSource pointing to multiple db's or DataSources.

Like I said, the JBoss AS datasource descriptor file allows you to specify only one connection URL. If the JDBC driver permits you to specify multiple databases, great. If not, then you are stuck with only one database.