passing parameters in oracle jdeveloper adf

Using "Passing Parameters to ADF Application through URL" by Shay Shmeltzer's Weblog
http://blogs.oracle.com/shay/2010/10/passing_parameters_to_adf_appl.html
I created a jsfx page and it runs fine. I use Jdev 11.1.1.3.

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.
#{bindings.ShowAll.execute}

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();
System.out.println("==test1");
empVO.setNamedWhereClauseParam("pstatus", "H");
System.out.println("==test2");
empVO.executeQuery();
}

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

Thanks
grchapAsked:
Who is Participating?
 
dgofmanConnect With a Mentor Commented:
you are getting exception on executing
empVO.setNamedWhereClauseParam("pstatus", "H");
add try / catch wrapper on this line
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.