1. Developing SOA Applications with Oracle SOA Suite
  2. Sharing Functionality Across Service Components
  3. Working with Cross References
  4. Creating and Running the Cross Reference Use Case
  5. How to Create the Use Case
  6. Task 1: How to Configure the Oracle Database and Database Adapter

Task 1: How to Configure the Oracle Database and Database Adapter

To configure the Oracle database and database adapter:

  1. You need the SCOTT database account with password TIGER for this use case. You must ensure that the SCOTT account is unlocked.

    You can log in as SYSDBA and then run the setup_user.sql script available in the XrefOrderApp1M/sql directory to unlock the account.

  2. Run the create_schema.sql script available in the XrefOrderApp1M/sql directory to create the tables required for this use case.
  3. Run the create_app_procedure.sql script available in the XrefOrderApp1M/sql directory to create a procedure that simulates the various applications participating in this integration.
  4. Run the createschema_xref_oracle.sql script available in the OH/rcu/integration/soainfra/sql/xref/ directory to create a cross reference table to store runtime cross reference data.
  5. Copy the ra.xml and weblogic-ra.xml files from $BEAHOME/META-INF to the newly created directory called META-INF on your computer.
  6. Edit the weblogic-ra.xml file available in the $BEAHOME/META-INF directory as follows:

    • Modify the property to xADataSourceName as follows: 

      <property>
 <name>xADataSourceName</name>
 <value>jdbc/DBConnection1</value>
</property>

    • Modify the jndi-name as follows: 

      <jndi-name> eis/DB/DBConnection1</jndi-name>

    This sample uses eis/DB/DBConnection1 to poll the SAP table for new messages and to connect to the procedure that simulates Oracle EBS and Siebel instances.

  7. Package the ra.xml and weblogic-ra.xml files as a RAR file and deploy the RAR file by using Oracle WebLogic Server Administration Console.
  8. Create a data source using the Oracle WebLogic Server Administration Console with the following values:

    • jndi-name=jdbc/DBConnection1

    • user=scott

    • password=tiger

    • url=jdbc:oracle:thin:@host:port:service

    • connection-factory factory-class=oracle.jdbc.pool.OracleDataSource

  9. Create a data source using the Oracle WebLogic Server Administration Console with the following values:

    • jndi-name=jdbc/xref

    • user=scott

    • password=tiger

    • url=jdbc:oracle:thin:@host:port:service

    • connection-factory factory-class=oracle.jdbc.pool.OracleDataSource