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
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.