Tarek Fathy

Hi Suppose you have "Employee" table which contains many attributes. Some of these attributes are :EmpNameArabic,EmpNameEnglish,StatusArabic,StatusEnglish. The problem is how to query the "EmpNameArabic" attribute in case of the locale is "ar" and how to query"EmpNameEnglish" in case of the local is "en". Solution 1- In the EmployeeVO view object , click on the query tab and edit the query as following: Edit the query to add "Decode(:p_lang,'en',EmpNameEnglishmEmpNameArabic) Emp_name" then click ok 2- Add the  bind  variable Select expression and write : " adf.context.locale.language" click ok and test the page and change the direction to test.

@ECHO OFF @REM WARNING: This file is created by the Configuration Wizard. @REM Any changes to this script may be lost when adding extensions to this configuration. @REM ************************************************************************* @REM This script is used to setup the needed environment to be able to start Weblogic Server in this domain. @REM @REM This script initializes the following variables before calling commEnv to set other variables: @REM @REM WL_HOME         - The BEA home directory of your WebLogic installation. @REM JAVA_VM         - The desired Java VM to use. You can set this environment variable before calling @REM                   this script to switch between Sun or BEA or just have the default be set. @REM JAVA_HOME       - Location of the version of Java used to start WebLogic @REM                   ...

To get the current row index and the rows count  value="[#{bindings.AdmMissionReqHdrVO1Iterator.rangeStart + bindings.AdmMissionReqHdrVO1Iterator.currentRowIndexInRange +1}/#{bindings.AdmMissionReqHdrVO1Iterator.estimatedRowCount}] "/>

To ensure that the credentials that you supply in the database connections for your ADF Application are deployed and include the password, add  -Djps.app.credential.overwrite.allowed=true  to the JAVA_PROPERTIES entry in the FMW_HOME /user_projects/domains/ yourdomain /bin/setDomainEnv.sh file (or setDomainEnv.cmd if you are on Windows), and restart the server using FMW_HOME /user_projects/domains/ yourdomain /bin/startWebLogic.sh. This is what you need to do if you have deployed an ADF application to your server but are seeing the following errors when the application is accessed: oracle.jbo.DMLException: JBO-26061: Error while opening JDBC connection. at oracle.jbo.server.ConnectionPool.createConnection(ConnectionPool.java:253) at oracle.jbo.server.ConnectionPool.instantiateResource(ConnectionPool.java:168) at oracle.jbo.pool.ResourcePool.createResource(ResourcePool.java:546) at oracle.jbo.pool.ResourcePool.useResource(ResourcePool.java:327) at oracle.jbo.server.Conn...

Application Server JDeveloper ADF Oracle WebLogic 11g Release 1 (10.3.x) Supported See below Oracle WebLogic 11g Release 1 (10.3.5) Certified with 11.1.2.0.x, 11.1.2.1.x, 11.1.2.2.x Certified with 11.1.2.0.x, 11.1.2.1.x; requires ADF 11.1.2.x patches onto Application Development Runtime 11.1.1.5.x Certified with 11.1.2.2.x; requires ADF 11.1.2.2.x patches onto Application Development Runtime 11.1.1.6.x Oracle WebLogic 11g Release 1 (10.3.6) Certified with 11.1.2.2.x Certified with 11.1.2.2.x; requires ADF 11.1.2.x patches onto Application Development Runtime 11.1.1.6.x IBM WebSphere 7 Certified Certified with WebSphere 7.0.0.13 AS or ND Tomcat 6 Certified Not Supported JBoss 5 Certified Not Supported

Some times you  want to check if the data has been modified by the user or not. We can remember how easily we make this in forms builder using ":System.record_status" or :System.block_status" or :System.form_status". But the ADF world is somehow different. Just write this code