Developing RIA with Oracle ADF SOA Suite


Time needed to try it ourself :
1 hour depending on your hardware and setup of Oracle Fusion Env.

Purpose :
JSF page showing oracle table content using Oracle ADF. Fusion

What it covers :
    (1) Create database user using Oracle XE web admin console
    (2) Creating a table using Fusion Database Designer
    (3) Create a Fusion Web Application (ADF)
    (4) JSF page for some web UI
    (5) Monitor Request / Transactions using Weblogic EM
    (6) Test using a browser window
    (7) Issues I ran into while trying to get this to work
    (8) Some help full url's and more info

Implementation Details .....

(1) Create database user using Oracle XE web admin console

    Open a browser and go to your Oracle XE admin page.
    Login using system/welcome1 etc depending on your xe setup
    some_text


    Click on Administration
    some_text



    Click on Database User
    some_text



    Click on Create (let's create a new user so that we can have our own solo tables)
    Solo is my dogs name
    some_text



    Populate with "solo" as username and password it will be easy to remember later
    Give solo the super powers so that we can manipulate the tables as we please.
    some_text



    Your are done once you see the solo icon in user section.
    some_text




(2) Creating a table using Fusion Database Designer
    Click on New -> make sure you see "All Tec....." pick the db designer then ok
    some_text



    Drag the table from right in JDeveloper to your desing window"
    some_text



    if this window comes up just click ok we just need to define the table
    some_text



    Make sure you set the LIGHT as primary key otherwise you will run into EJB Object issues later
    some_text



    We should be good if you see something like this in the DB Designer
    some_text



(3)Create a Fusion Web Application (ADF)

    Open JDeveloper File->New pick ADF name it RIAJSFView

    some_text


    some_text



    some_text



    some_text



    some_text



    some_text



    some_text



    some_text



    some_text



    some_text



    some_text



    some_text



    some_text



    some_text



    some_text



    some_text



    some_text



    (4)JSF page for some web UI
      some_text



      some_text



      some_text



      some_text



      some_text



      some_text



      some_text



      some_text



    (5)Monitor Request / Transactions using Weblogic EM
      some_text



      some_text



      some_text



    (6)Test using a browser window
      some_text



    (7)Issues I ran into while trying to get this to work
      Had some issues with jdbc connection at runtime user cannot login errors.
      Solution : had to change the java properties in setenv weblogic to include

      had to deploy as application and not project deploy

      had to deploy as ear and fusion project

      had to use the context faces/index.jspx since the default test url was giving 403 errros.

    (8)Some help full url's and more info
      Oracle docs on RIA
      Right click on the AppModule on the left window and click Run.
      This can be used to populate some content into your tables if you do not have any yet.
      You will need to click the commit so that you save the data to the table
      some_text



      some_text



      some_text



      some_text





Add new comment

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.