different connection node/pool

[harish73]

Hi,

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


-hk

[peterj]

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.

[harish73]

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.