2 Replies Latest reply on Dec 11, 2007 8:48 AM by Harish Kumar

    different connection node/pool

    Harish Kumar Newbie

      Hi,

      Can anyone tell me how to config jboss to connect different connection node/pool via one datasource?


      -hk

        • 1. Re: different connection node/pool
          Peter Johnson Master

          There is no way to have one datasource support two different connection pools. How would the datasource know which of the pools to use? And what would be the benefit of having two connection pools of 100 connections each, as opposed to having a single connection pool of 200 connections?

          However, you can create multiple datasources for the same database, and each would have its own connection pool. You can then have some applications request one of the datasource and other request the other datasource.

          • 2. Re: different connection node/pool
            Harish Kumar Newbie

            Thanks peter for your prompt response.
            May be i'm wrong. But i have been working in weblogic multi datasource, where multi data source is an abstraction around a group of data sources that provides load balancing or failover processing between the data sources associated with the multi data source.
            I was looking same feature or alternative in JBOSS. is this possible?

            Thanks.

            "PeterJ" wrote:
            There is no way to have one datasource support two different connection pools. How would the datasource know which of the pools to use? And what would be the benefit of having two connection pools of 100 connections each, as opposed to having a single connection pool of 200 connections?

            However, you can create multiple datasources for the same database, and each would have its own connection pool. You can then have some applications request one of the datasource and other request the other datasource.