MQSeries.net :: View topic

csjayakumar · Posted: Thu Jan 05, 2012 5:35 am Post subject:

Hi,

In my project, we connect to two databases
1) Database where all project config data is stored. DataSource is ABCD in all environments
2) An external database. DataSource is DB2A in test and DB2B is production.

So here the datasource for the 2nd database is different in test and Production and hence should be set dynamically.
One option is to go with bar override, but I am trying not to touch the bar file for each environment.

So now we store the dataSource name as a configurable value in the ABCD database. So in ABCD test database, we store the value DB2A and in ABCD prod database, we store DB2B.
Then in the ESQL, I get the value from DB and use it in my database statements.

EG: SET RW_Properties.Properties[]=PASSTHRU (CH_HotelSelectProperties TO Database.{DataSource_1P} VALUES(CH_LastRetrieve,CH_LastRetrieve));
Where the value of DataSource_1P comes from the database.

The challenge is that if a compute node has code to connect to database, then the node property "data Source" is mandatory. So I should hard code to DB2A or DB2B.
If I hard code DB2B, then the flow is not working in test because DB2B is not a valid datasource in test. Though in the ESQL I will be using DB2A, I believe the broker will try connecting to the DataSource configured as Node property, irrespective of whether it is used in the ESQL.

I also tried to override this property via ESQL (similar to how you change the Directory of a FileRead node or URL of a HTTLRequest node), but could not find the right way to do it.

Can you please suggest a way out?

Thank you!