Using the EJB or Java Datacontrol in ADF Rich Faces

In my previous blogspot I showed you the new JDeveloper 11gR2 EJB and ADF DataControl features and in this blogpost I will use this EJB or Java DataControl in a JSF page.

I made a simple EJB model project which uses the dept and emp tables of the Scott schema. This project also contains with a Session Bean on which I generated an ADF DataControl.

When you open the DataControls.dcx in your model project and select one of your DataControl entries you can click on the edit button. This will open and generate an ADF entity xml in which you can change some properties.
We will add a new Named Criteria in which you can search on a particular location of the department. This criteria can be used in a Query Panel.

The criteria dialog, where I add the location attribute of the dept entity and compare it with a bind variable.

When we switch to the ViewController project, you will see this criteria in the DataControl Window.

Drag All Queriable Attributes on the JSF Page and choose for ADF Query Panel with Table.

You can run this page and in the top right Combobox you can select your criteria,  next the bind variable will be shown on the query panel.

The saving of your own custom queries in the MDS store is not working (yet) with this DataControl. You will get a viewobject error. And I can't define a list of values on an attribute, so no nice combobox in the query panel.

The second part of this blogpost will show you, how you can change a department of a employee.  Here you can see that the employee entity has the department entity as attribute( no dept_id attribute).

Drag the empFindAll operation on the page and choose for ADF Form

You can see that there is no combobox option for the department entity but you can include its attributes.

On runtime it will look like this.

I removed the entity attributes of  Dept and drag the dept attribute from the DataControl on the Form and choose for ADF Select One Choice.

The Base Data Source is the dept entity inside the Employee entity and add a new other department operation as List Data Source

Add the data mapping and display some department attributes.

This time a combobox is displayed and you can change the department on the employee

That's all for now.