Dynamic configuration JDBC Adapter

, ,
1

Hi everyone :D:

I have a problem :confused:, let me talk you about it:

I have several servers, they have database DB2, they install the same databases but with diferent information of course.

My idea is for example: if I have a variable called ā€œhostā€ is equal to ā€œWHITEā€ then going to connect to server1, but if variable ā€œhostā€ is igual to ā€œBLANKā€ then going to connect to server2.

My idea is just do it with one JDBC Adapter, the reason is the number of servers will grow up, I donā€™t know exacty will be , so itā€™s easier to configure parameters
server with webMethods Services than I create a new JDBC Adapter for each new server.

Could you help me?, is there any service that modify the parametersā€™ JDBC Adapter?

Thanks

2

Based on the information provided what youā€™re attempting to do isnā€™t possible and isnā€™t advisable.

Use 1 or more JDBC adapter connections for each DB server/cluster. Trying to use one connection pool for multiple DB servers is not a good approach. Instead, plan your connection definitions around your integrations, creating the number of connections that balance administration, outages, impact of failures, etc.

3

Create one jdbc connection for each database (you dont have an option here)ā€¦ At run time, you can pass the $connectionName by determining in the logic if you want to use DB1 or DB2ā€¦

Senthil

4

Thanks for you helpful, I did your recomendation and itā€™s works !!