[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 481
  • Last Modified:

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
0
grchap
Asked:
grchap
1 Solution
 
dgofmanCommented:
you are getting exception on executing
empVO.setNamedWhereClauseParam("pstatus", "H");
add try / catch wrapper on this line
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Tackle projects and never again get stuck behind a technical roadblock.
Join Now