You can assign a new value to the JCA property using either the mediator as BPEL.
In the mediator click on the assign value option and add the right assign to the JCA property jca.db.DataSourceName.
In BPEL doucle click on the invoke to the DB adapter, go to the properties tab and add the right assign to the JCA property jca.db.DataSourceName.
If you want to use a configuration file to set the value, I suggest a BPEL property, the value can be replaced using a config file and can be assigned to the JCA property by using ora:getPreference("prefName as string");
When using a mediator you can't use a preference and you might use a placeholder that you replace when you compile the SCA composite. With ANT in combination with hudson you can easily replace the value (hardcoded) per environment.
Robert van Mölken
Oracle Integration Specialist
Message was edited by: robertvm
1 person found this helpful
In my experience i think you can not change the value of location, you can only set the value of jca property. Also why do you need to change jndi name, if you are deploying on different server then you can keep the same jndi name.
I think you are correct in that I can have the same name. Actually i think may be it is not a bad idea, so far I created the name to reflect the instance name as CRP1, DEV and so forth, but you are right - nothing prohibits me from having it the same across multiple deployments.
Thank you Robert, that works nicely.