Category Archives: Oracle

Insert Rows in ADF View Object Programatically

Suppose that I have EmpVO view object which have below attributes EmpId, FirstName,┬áLastName We can do inserting rows by two ways in data model layer (Application Model or View Object classes) I will write my code in ApplicationModuleImpl class try … Continue reading

Posted in Oracle, Oracle ADF | Tagged , , , , , , | Leave a comment

How to pass Service Name or SID in JDBC URL

Below is the way to send either Service Name or SID in JDBC URL to connect to Oracle SQL For Service Name @//host_name:port_number/service_name For example: jdbc:oracle:thin:scott/tiger@//myhost:1521/myservicename For SID @//host_name:port_number:service_name For example: jdbc:oracle:thin:scott/tiger@//myhost:1521:myservicename Oracle DOC

Posted in Oracle, Oracle SQL | Tagged , , , , | Leave a comment

When and how much to mix technologies for a project?

The main idea behind using a technology is to harness the power of code re-usability and libraries that have already been worked on and trusted to be working and functional with minimal or no issues. The term “Technology” does not … Continue reading

Posted in Oracle, Oracle ADF, Oracle SQL, OSB, Weblogic | Tagged , , , , , , , , , , | Leave a comment

How to add DVT Graph Programmatically

This tutorial is to show how to inject a DVT graph programmatically in Oracle ADF Step 1: Define a List Data Model: Java Code for Data List<Object[]> listObject = null; if (listObject == null) { listObject = new ArrayList<Object[]>(); Object[] … Continue reading

Posted in Oracle, Oracle ADF | Tagged , , , , | Leave a comment

How to add ValueChangeListener Programmatically

Using an EL String, we can add ValueChangeListener in Oracle ADF using the below code: private static MethodBinding getValueChangeListener(String el) { Class[] parms = new Class[] { ValueChangeEvent.class }; MethodBinding mb = FacesContext.getCurrentInstance().getApplication().createMethodBinding(el, parms); return mb; } pass the EL … Continue reading

Posted in Oracle, Oracle ADF | Tagged , , , , | Leave a comment

How to Add an ActionListener programmatically

Using an EL String, we can add ActionListener in Oracle ADF using the below code: private ActionListener getActionListener(String el) { //here Testbean is the name of ManagedBean MethodExpression methodExp = getMethodExpressionForAction(el); return new MethodExpressionActionListener(methodExp); } private MethodExpression getMethodExpressionForAction(String actionName) { … Continue reading

Posted in Oracle, Oracle ADF | Tagged , , , , | Leave a comment

Oracle SQL Joins

Image | Posted on by | Tagged , , | Leave a comment