ADF 11g introduces a new SQL mode for view objects to complement the existing "Normal Mode" and "Expert Mode". The new mode is called "SQL Independence Mode" in the 11g Tech Preview release (although the name might change by production). When a view object is in SQL Independence Mode, you cannot type hand-written SQL for the WHERE clause or ORDER BY clause. Instead, you define the where clause using a declarative view criteria and define the order by clause by picking view object attribute names. At runtime, these are translated into SQL by the current SQLBuilder implementation you are running with (Oracle, SQLServer, DB2, etc.). Give it a try and give us your feedback in the Oracle JDeveloper and OC4J 11g Technology Preview OTN Discussion forum.
4:24:45 PM
|
|