Friday, January 3, 2014

ADF selectBooleanCheckbox lost values

This is JDeveloper 11.1.1.6. In order to test it, I created a table in HR schema.

CREATE TABLE "DEPT_WITH_FLAG"
( "DEPTNO" NUMBER(2,0) PRIMARY KEY,
"DNAME" VARCHAR2(14),
"LOC" VARCHAR2(13),
"FLAG" CHAR(1)
) ;


Oracle ADF faces component selectBooleanCheckbox has an issue.

It can be reproduced with a very simple application created:
- create an entity object with database table
(one of the table columns has only Y/N values, which is the recommended way of boolean type column)
- create a view object based on this entity object
- create a page and drag the VO created to page as a table
- create a button binding and assoociate it to the boolean cloumn
- create a button to show / hide the table

When using selectBooleanCheckbox as column in a table, After hide -> show the table, all checked checkbox lost their value (unchecked). You can download the test source here: Checkbox.zip

Oracle forum for this issue:
https://community.oracle.com/thread/2594029