Labs SEI >

Table of Contents

About VirtualBox

VirtualBox is a virtualization software package that can be installed on an existing host operating system as an application and allows allows additional guest operating systems, to be loaded and run, each with its own virtual environment.

For this course we are using a SOA and BPM Development Virtual Machine available at Oracle Technology Network. You can find more information at the Download and Instructions page.

Import appliance

  1. Start VirtualBox
  2. Import Appliance - the image occupies 32 GB after installation
  3. Adjust the 'System', 'Memory' to 4GB and 'Processor' to 2 cores, if possible. These are the minimum recommended values.

Start the VirtualBox image

  1. Start the Virtual Machine (VM) and wait for system to boot.
  2. Linux console login oracle:oracle (user:pass)
  3. Choose 'Start Desktop', 'OK'
  4. In 'Domain Setup', choose 'dev_bpm' updated
    5. screenshot
  5. In 'VM Control Center', 'JVM Settings'. Change 'AdminServer', 'Heap (MB)', 'Min:' 1536, 'Max:' 1536.
  6. In 'VM Control Center', 'Select All' servers and 'Start'. Wait. This can take up to 10 minutes. 'Server Status' can be used to check if servers are stopped or running (also accessible through desktop shortcut 'Start/Stop Weblogic Servers').
  7. Meanwhile, adjust other settings:
    • If screen size is too large, change resolution by going to 'System', 'Preferences', 'Screen Resolution', e.g. choose '1024x768'
    • If keyboard is not working properly, go to 'System', 'Keyboard', 'Layout' and add a suitable layout (e.g. Portuguese)
    • Adjust time zone e.g. to Lisbon, Portugal

Test other software

  1. Open Oracle WebLogic Server Administration Console
    2. screenshot
  2. Open 'Oracle Enterprise Manager Fusion Middleware Control'
    3. screenshot
    • http://localhost:7001/em
      When the 'Loading...' message appears wait. This can take up to 2 minutes. If it takes too long, enter the initial address again.
    • Login: weblogic:welcome1
    • If operation is successful: 'Login is successful, loading next page ...'
      • screenshot
  3. Start 'Oracle JDeveloper'
    4. screenshot
    • Click desktop icon.
    • Select 'Default Role'

Configure database

Several configuration steps are required to properly configure the database for use with the DBAdapter component.

First, the database has to be created, then a data source, next a data source pool, and finally use it in a DBAdapter, dragged to a BPEL project

  1. Ignore 'Get Started With Oracle Database 11g Express Edition'. We will use the console instead.
  2. Open Oracle DB Env Terminal
    3. screenshot
    • sqlplus system/welcome1
      • CREATE USER soa_user IDENTIFIED BY welcome1;
GRANT connect, resource TO soa_user;
  3. Note: These commands can be scripted and then piped to the sqlplus program
    • sqlplus system/welcome1 < script.sql
  4. To test:
    • sqlplus soa_user/welcome1
      • CREATE TABLE test (name VARCHAR(255), value VARCHAR(255));
INSERT INTO test (name, value) VALUES ('1', 'one');
SELECT * FROM test;
  5. Open Oracle WebLogic Server Administration Console
    6. screenshot
    • http://localhost:7001/console
    • Login: weblogic:welcome1
      • screenshot
    • Create Data Source
      • Go to: 'Data sources'
        • screenshot
      • 'New', 'Generic Data Source'
      • Name: My JDBC Data Source
      • JNDI Name: jdbc/mydb
      • Database Type: 'Oracle'
      • Click 'Next'
      • Accept Database Driver suggestion and click 'Next'
      • At 'Transaction Options' click 'Next'
      • Database Name: XE
      • Host Name: localhost
      • Port: 1521
      • Database User Name: soa_user
      • Click 'Next'
        • screenshot
      • Click 'Test Configuration' button
      • If operation is successful: 'Connection test succeeded.'
        • screenshot
      • Define the data source target server
      • Choose the application server
        • screenshot
      • Click 'Finish'
    • Configure DbAdapter connection pool
      • Go to 'Deployments'
        • screenshot
      • Find 'DbAdapter' on table and click on it.
        • screenshot
      • 'Configuration', 'Outbound Connection Pools'
      • In 'Outbound Connection Pool Configuration Table', click 'New'
      • Select 'javax.resource.cci.ConnectionFactory'
      • JNDI Name: eis/DB/mydb
      • 'Finish'
      • In 'Outbound Connection Pool Configuration Table', expand 'javax.resource.cci.ConnectionFactory'
      • Click 'eis/DB/mydb'
      • Edit property 'xADataSourceName' and set value to 'jdbc/mydb'
      • 'Save'
      • If operation is successful: 'Success All changes have been activated. No restarts are necessary.'
      • Go to 'Deployments', select 'DbAdapter' and redeploy (select and update)
        • screenshot
    • Configure DbAdapter on SOA project
        • screenshot
      • Inside a BPEL project
      • Drag DB Adapter
        • screenshot
      • Configure database
        • screenshot
      • The JNDI name must match the name of the connection pool: eis/DB/mydb

(with thanks to Filipe Azevedo for assisting in this configuration)

References