3 Replies Latest reply on Jul 21, 2009 3:54 PM by Peter Johnson

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

    Shehzad Sid Newbie

      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