Expose ADF BC as RESTful Web Service

Expose an ADF BC as SOAP Web Service is very simple. All you have to do is enable your Application Module to support Service Interface. But, how can I expose this same Application Module as RESTful Web Service?

In this post, you will learn how to expose ADF BC as RESTful Web Service using JDeveloper 12c (12.1.3). Download the sample application: ADFRESTApp.zip.

Create an ADF Fusion Web Application, and call it as ADFRESTApp.

Create the Business Components, using the Employees table.

This way, you have a simple ADF Application with two projects, Model and ViewController.
Now, we have to create a project to organize the RESTful codes.
Create a new ADF Model RESTful Web Service Project.

To use Application Module from Model project, you need to add the Model Project as a dependency project.
Double-click RESTWebService project and add the Model Project as a dependency project.

Create the Employee and Employees Entities.
In the Applications window, right-click RESTWebService Project and choose New > From Gallery.
In the New Gallery dialog, choose General > Java Class, and click OK.
In the Create Java Class dialog, change the Name to Employee and click OK.
Copy the following code inside Employee class:

@XmlRootElement
public class Employee {
  @XmlElement
  private Integer employeeId;
  @XmlElement
  private String firstName;
  @XmlElement
  private String lastName;
  @XmlElement
  private String email;
  @XmlElement
  private String phoneNumber;
  @XmlElement
  private Date hireDate;
  @XmlElement
  private String jobId;
  @XmlElement
  private BigDecimal salary;
  @XmlElement
  private BigDecimal commissionPct;
  @XmlElement
  private Integer managerId;
  @XmlElement
  private Integer departmentId;
    
  public Employee() {
    super();
  }
  public void setEmployeeId(Integer employeeId) {
    this.employeeId = employeeId;
  }
  public Integer getEmployeeId() {
    return employeeId;
  }
  public void setFirstName(String firstName) {
    this.firstName = firstName;
  }
  public String getFirstName() {
    return firstName;
  }
  public void setLastName(String lastName) {
    this.lastName = lastName;
  }
  public String getLastName() {
    return lastName;
  }
  public void setEmail(String email) {
    this.email = email;
  }
  public String getEmail() {
    return email;
  }
  public void setPhoneNumber(String phoneNumber) {
    this.phoneNumber = phoneNumber;
  }
  public String getPhoneNumber() {
    return phoneNumber;
  }
  public void setHireDate(Date hireDate) {
    this.hireDate = hireDate;
  }
  public Date getHireDate() {
    return hireDate;
  }
  public void setJobId(String jobId) {
    this.jobId = jobId;
  }
  public String getJobId() {
    return jobId;
  }
  public void setSalary(BigDecimal salary) {
    this.salary = salary;
  }
  public BigDecimal getSalary() {
    return salary;
  }
  public void setCommissionPct(BigDecimal commissionPct) {
    this.commissionPct = commissionPct;
  }
  public BigDecimal getCommissionPct() {
    return commissionPct;
  }
  public void setManagerId(Integer managerId) {
    this.managerId = managerId;
  }
  public Integer getManagerId() {
    return managerId;
  }
  public void setDepartmentId(Integer departmentId) {
    this.departmentId = departmentId;
  }
  public Integer getDepartmentId() {
    return departmentId;
  }
}

Repeat the step above and create the Employees class.
Copy the following code inside Employees class:

@XmlRootElement
public class Employees {
  @XmlElement(name = "employee")
  private List employees;

  public Employees() {
    super();
  }
  public void setEmployees(List employees) {
    this.employees = employees;
  }
  public List getEmployees() {
    return employees;
  }
  public void addEmployees(Employee employee) {
    if (employees == null) {
      employees = new ArrayList();
    }
    employees.add(employee);
  }
}

Create the Employees RESTful Service.
In the Applications window, right-click Rest Project and choose New > From Gallery.
In the New Gallery dialog, choose General > Java Class, and click OK.
In the Create Java Class dialog, change the Name to EmployeesResource and click OK.
Copy the following code inside EmployeesResource class:

public class EmployeesResource {
  private static final String amDef = "br.com.waslleysouza.model.AppModule";
  private static final String config = "AppModuleLocal";

  public EmployeesResource() {}

  public void update(Employee employee) {
    ApplicationModule am = Configuration.createRootApplicationModule(amDef, config);
    ViewObject vo = am.findViewObject("EmployeesView1");

    Key key = new Key(new Object[] { employee.getEmployeeId() });
    Row[] rowsFound = vo.findByKey(key, 1);
    if (rowsFound != null && rowsFound.length > 0) {
      Row row = rowsFound[0];
      if (employee.getEmail() != null && !employee.getEmail().isEmpty()) {
        row.setAttribute("Email", employee.getEmail());
      }
      if (employee.getHireDate() != null) {
        row.setAttribute("HireDate", employee.getHireDate());
      }
      if (employee.getJobId() != null && !employee.getJobId().isEmpty()) {
        row.setAttribute("JobId", employee.getJobId());
      }
      if (employee.getLastName() != null && !employee.getLastName().isEmpty()) {
        row.setAttribute("LastName", employee.getLastName());
      }
    }
    am.getTransaction().commit();
    Configuration.releaseRootApplicationModule(am, true);
  }

  public Employee getById(Integer id) {
    ApplicationModule am = Configuration.createRootApplicationModule(amDef, config);
    ViewObject vo = am.findViewObject("EmployeesView1");
    Employee employee = null;

    Key key = new Key(new Object[] { id });
    Row[] rowsFound = vo.findByKey(key, 1);
    if (rowsFound != null && rowsFound.length > 0) {
      Row row = rowsFound[0];
      employee = new Employee();
      employee.setEmployeeId((Integer) row.getAttribute("EmployeeId"));
      employee.setEmail((String) row.getAttribute("Email"));
      employee.setHireDate((Timestamp) row.getAttribute("HireDate"));
      employee.setJobId((String) row.getAttribute("JobId"));
      employee.setLastName((String) row.getAttribute("LastName"));
    }
    Configuration.releaseRootApplicationModule(am, true);
    return employee;
  }

  public void deleteById(Integer id) {
    ApplicationModule am = Configuration.createRootApplicationModule(amDef, config);
    ViewObject vo = am.findViewObject("EmployeesView1");

    Key key = new Key(new Object[] { id });
    Row[] rowsFound = vo.findByKey(key, 1);
    if (rowsFound != null && rowsFound.length > 0) {
      Row row = rowsFound[0];
      row.remove();
    }
    am.getTransaction().commit();
    Configuration.releaseRootApplicationModule(am, true);
  }

  public void add(Employee employee) {
    ApplicationModule am = Configuration.createRootApplicationModule(amDef, config);
    ViewObject vo = am.findViewObject("EmployeesView1");

    Row row = vo.createRow();
    vo.insertRow(row);
    row.setAttribute("EmployeeId", employee.getEmployeeId());
    row.setAttribute("LastName", employee.getLastName());
    row.setAttribute("Email", employee.getEmail());
    row.setAttribute("HireDate", new Timestamp(employee.getHireDate().getTime()));
    row.setAttribute("JobId", employee.getJobId());
    am.getTransaction().commit();
    Configuration.releaseRootApplicationModule(am, true);
  }

  public Employees findAll() {
    ApplicationModule am = Configuration.createRootApplicationModule(amDef, config);
    ViewObject vo = am.findViewObject("EmployeesView1");
    vo.executeQuery();
    Employees employees = new Employees();

    while (vo.hasNext()) {
      Row row = vo.next();
      Employee employee = new Employee();
      employee.setEmployeeId((Integer) row.getAttribute("EmployeeId"));
      employee.setEmail((String) row.getAttribute("Email"));
      employee.setHireDate((Timestamp) row.getAttribute("HireDate"));
      employee.setJobId((String) row.getAttribute("JobId"));
      employee.setLastName((String) row.getAttribute("LastName"));
      employees.addEmployees(employee);
    }
    Configuration.releaseRootApplicationModule(am, true);
    return employees;
  }
}

In the Applications window, right-click EmployeesResource class and choose Create RESTful Service.
Choose JAX-RS 2.0 Style and click Next.
Configure the RESTful Service and click Finish.

In the Return Type Warning dialog, click OK.

Done!
To test the RESTful Service, right-click EmployeesResource class and choose Test Web Service.
You may test each service operation using HTTP Analyzer.
Select the findAll operation and click Send Request button.

When you try to execute a PUT or POST operation, like the add operation, you receive the following error:

Root cause of ServletException.
A MultiException has 1 exceptions.  They are:
1. java.lang.RuntimeException: Security features for the SAX parser could not be enabled.
at org.jvnet.hk2.internal.Utilities.createService(Utilities.java:2494)
at org.jvnet.hk2.internal.ServiceHandleImpl.getService(ServiceHandleImpl.java:98)
at org.jvnet.hk2.internal.ServiceHandleImpl.getService(ServiceHandleImpl.java:87)
at org.glassfish.jersey.internal.inject.ContextInjectionResolver$1.provide(ContextInjectionResolver.java:114)
at org.glassfish.jersey.message.internal.XmlRootElementJaxbProvider.readFrom(XmlRootElementJaxbProvider.java:138)
Truncated. see log file for complete stacktrace
Caused By: java.lang.RuntimeException: Security features for the SAX parser could not be enabled.
at org.glassfish.jersey.message.internal.SecureSaxParserFactory.(SecureSaxParserFactory.java:103)
at org.glassfish.jersey.message.internal.SaxParserFactoryInjectionProvider.provide(SaxParserFactoryInjectionProvider.java:78)
at org.glassfish.jersey.message.internal.SaxParserFactoryInjectionProvider.provide(SaxParserFactoryInjectionProvider.java:57)
at org.jvnet.hk2.internal.FactoryCreator.create(FactoryCreator.java:96)
at org.jvnet.hk2.internal.SystemDescriptor.create(SystemDescriptor.java:456)
Truncated. see log file for complete stacktrace
Caused By: javax.xml.parsers.ParserConfigurationException: SAX feature 'http://xml.org/sax/features/external-general-entities' not supported.
at oracle.xml.jaxp.JXSAXParserFactory.setFeature(JXSAXParserFactory.java:272)
at weblogic.xml.jaxp.RegistrySAXParserFactory.setFeature(RegistrySAXParserFactory.java:134)
at org.glassfish.jersey.message.internal.SecureSaxParserFactory.(SecureSaxParserFactory.java:100)
at org.glassfish.jersey.message.internal.SaxParserFactoryInjectionProvider.provide(SaxParserFactoryInjectionProvider.java:78)
at org.glassfish.jersey.message.internal.SaxParserFactoryInjectionProvider.provide(SaxParserFactoryInjectionProvider.java:57)
Truncated. see log file for complete stacktrace

This is a known issue for JDeveloper and ADF 11g Release 2, but I didn’t find anything about it in Release Notes from JDeveloper and ADF 12c.
Probably this issue continues in JDeveloper and ADF 12c, so let’s use the workaround for 11g.

Create a Java Class that extends org.glassfish.jersey.server.ResourceConfig and set the MessageProperties.XML_SECURITY_DISABLE property to TRUE.

@ApplicationPath("/resources/")
public class MyResourceConfig extends ResourceConfig {

  public MyResourceConfig() {
    super();
    property(MessageProperties.XML_SECURITY_DISABLE, Boolean.TRUE);
  }
}

Done!
Test your RESTful Web Service again, and execute the PUT and POST operations successfully!