Enable or disable datasources in a specific server of server group in domain mode
Issue
- While running JBoss 6.x in domain mode, with a profile that is shared between a couple of applications. Each application runs in a separated managed server. The data source is defined in that profile that is used only by one of the applications so is it possible that it is not instantiated for the other server of that server group.
- EAP servers are configured using domain mode with a single reusable profile and 9 server groups. There are 9 data sources declared, one for each server group with the min-pool=2. However, on startup, each server group binds to all 9 data sources. But a particular server group only uses a particular data source; therefore, leaving the other 8 data sources unused, which equates to 2*8=16 connections. How to configure a particular server group to bind only to a particular data source?
- I have a domain with 3 groups (group1, group2 and group3) each group have 2 instances, but all groups share the profile default. There I had configured 3 datasources (datasource1, datasource2, datasource3) each datasource have configured pool min = 10 and pool max in 10 connections.
I want to use the datasource1 just for group11, datasource2 just for group2 and datasource3 just for group3 but I received a notification from DBA where he find 60 connections from datasources1,2 and 3.
So, 3 groups X 2 instances per group x 10 pool connections = 60 Connections to DB
If I don't want to configure a profile for each group how I could configure for just the instance that use the datasource connect correctly?
Environment
- Red Hat JBoss Enterprise Application Platform (EAP)
- 6.x.x
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
