Thanks Arik. I will review this document. This is what I was looking for.
Please let me know how to update the following database adapter JCA file using Configuration Plan.
<adapter-config name="OFSDEV" adapter="Database Adapter" wsdlLocation="OFSDEV.wsdl" xmlns="http://platform.integration.oracle/blocks/adapter/fw/metadata">
<connection-factory location="eis/db/OFSDEV1" UIConnectionName="OFSDEV" adapterRef=""/>
<endpoint-interaction portType="OFSDEV_ptt" operation="insert">
<property name="DescriptorName" value="OFSDEV.Test"/>
<property name="DmlType" value="insert"/>
<property name="MappingsMetaDataURL" value="OFSDEV-or-mappings.xml"/>
<property name="DetectOmissions" value="true"/>
<property name="GetActiveUnitOfWork" value="false"/>
I need to update connection-factory to the following so the database adapter point to UAT instance.
<connection-factory location="eis/db/OFSUAT1" UIConnectionName="OFSUAT" adapterRef=""/>
I tried using configuration plan updating the reference section, it was not working as expected.
Here is the code from config file.
<binding type="jca"> <attribute name="location"> <searchReplace> <search>eis/db/OFSUAT1</search> <replace>eis/db/OFSDEV1</replace> </searchReplace> </attribute> </binding>
You may want to try with search DEV1 and replace with UAT1. you are doing the reverse.
If you are on a dev environment using a config plan is a good approach
but in higher environment ant script is the preferred one for deployment.
You may also follow the ant deployment for soa codes.
There are some excellent blogs on the same.
I have a similar question, although a bit different.
I have a DBAdapter the inserts data into an AS400 file in a specific library. The problem is that even though the file structure is exactly the same between Production and QA environment, the library name does get changed. So in PD, I would have to insert into LibraryPD.File, but in QA its LibraryQA.File.
Where can I add the search and replace in the configuration plan? Should I upldate the "-or-mappings.xml" file that specify the table to update?
Has anyone gotten the answer to this? I am performing the same task.