passing parameters in oracle  jdeveloper adf

Posted on 2011-04-19
Last Modified: 2012-05-11
Using "Passing Parameters to ADF Application through URL" by Shay Shmeltzer's Weblog
I created a jsfx page and it runs fine. I use Jdev

I read 2 params from the URL .
PARAM1 is "status". (if this is H, shows all employees . if this param is "" shows only active employees)
PARAM2 is dept.

Say, my page now shows currently for DEPT 1 only and active emplyees. (In the url, status is "" and dept = 1)

In the jspx page I need to add a button "Show All" which when clicked will show all emplyees for that DEPT 1.

I added a method ShowAll() to the AM. In the pagedef, added the methodaction ShowAll for this.

In the button, the action listener is is executing this method as below.

When I run, I see this method is getting executed. But some how the same results are shown back.

I see the message "==test1" but not "==test2".

The page seems to be refreshing but I see the same results. Any idea why ?

AM method
public void ShowAll() {
ViewObjectImpl empVO = this.getEmpView1();
empVO.setNamedWhereClauseParam("pstatus", "H");

PS: The same button logic works fine in another application but that does have any passing Parameters to Application through
URL though.

Question by:grchap
    1 Comment
    LVL 29

    Accepted Solution

    you are getting exception on executing
    empVO.setNamedWhereClauseParam("pstatus", "H");
    add try / catch wrapper on this line

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
    Introduction A previously published article on Experts Exchange ("Joins in Oracle", makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
    This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
    This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now