I am new to Oracle SOA. I am developing a new service which uses a database adapter to write request data to database.
Currently I am developing in a development environment and the database adapter is working as expected.
My question is should I keep changing the server connection details in the db adapter before moving the service to new environment(say from DEV to UAT then UAT to PROD) ?
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.
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?