Developing RIA with Oracle ADF SOA Suite
Submitted by ravi manthena on Mon, 08/13/2012 - 09:43
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
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
(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
![]() |
Click on Administration
![]() |
Click on Database User
![]() |
Click on Create (let's create a new user so that we can have our own solo tables)
Solo is my dogs name
![]() |
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.
![]() |
Your are done once you see the solo icon in user section.
![]() |
-
Click on New -> make sure you see "All Tec....." pick the db designer then ok
![]() |
Drag the table from right in JDeveloper to your desing window"
![]() |
if this window comes up just click ok we just need to define the table
![]() |
Make sure you set the LIGHT as primary key otherwise you will run into EJB Object issues later
![]() |
We should be good if you see something like this in the DB Designer
![]() |
-
Open JDeveloper File->New pick ADF name it RIAJSFView
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
(4)JSF page for some web UI
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
-
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.
- 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
![]() |
![]() |
![]() |
![]() |
Add new comment