DB Schema Name Appears in the DB Adapter Mappings File, which Makes Migration of the SOA Composite App Difficult

(Doc ID 1571814.1)

Last updated on FEBRUARY 02, 2015

Applies to:

Oracle SOA Platform - Version and later
Information in this document applies to any platform.


When the DB Adapter is configured to connect to a database in JDeveloper, the resulting artifact files created by the DbAdapter wizard can contain the Database schema name.

reference files:




As an example,

In the EMPDB-properties.xml file:

   <?xml version = '1.0' encoding = 'UTF-8'?>
    <!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
       <entry key="DEV_DBCB.EMPLOYEE.IDNUME:db_column_type">DECIMAL</entry>
       <entry key=""DEV_DBCB.EMPLOYEE.IDAGRU:db_column_size">20</entry>

And In the EMPDB-or-mappings.xml file:

      <class-mapping-descriptor xsi:type="object-relational-class-mapping-descriptor">


 and:     <tables>
            <table name="DEV_DBCB.EMPLOYEE"/>

Because these are .xml files, they cannot be modified via a config plan. A strategy is needed for migrating the DB Adapter related code to different environments.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms