Posts

Showing posts from 2012

ADF project integration

Operating system user for Host credentialsRemoteOperationException: ERROR: Invalid username and/or password .

Image
RemoteOperationException: ERROR: Invalid username and/or password Hi Do you face this problem? When you try to start up the oracle database using EM,you are prompted to enter windows username and password.And you are sure that the username and password are correct, however this error occurs. This is the solution: Step1 : Goto control panel -> Administrative Tool -> Local Security Settings.        Local Policies -> User Rights Assignment -> double click on 'Log on as a batch job' Step 2 : Add the user here which you are trying accessing the OEM and click apply and OK. Step3 : Follow the step 2 for adding user to 'Log on as a service'. Step4 : Now try to log on to OEM.           You will get the following screen if db is down. Hope this could help you to resolve the error.

Error occurs when sending email from database 11g triiger

We had 9i database and we migrated to 11g. one of the problems that occurred was   executing the "demo_mail" package that sends emails. The problem Sending mail via UTL_TCP and UTL_SMTP failes ERROR at line 1: ORA-24247: network access denied by access control list (ACL) ORA-06512: at "SYS.UTL_TCP" , line 17 ORA-06512: at "SYS.UTL_TCP" , line 246 ORA-06512: at "SYS.UTL_SMTP" , line 115  Cause : The Database user which execute the demo_mail package is not authorized to open connection and send a mail. Solution : suppose that the user executes the package is "Scott" and  smtp_host is " email2.dhaman.org" SQL> EXECUTE DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(acl => 'send_mail.xml',description => 'send_mail ACL',principal => 'scott',is_grant => true,privilege => 'connect'); PL/SQL procedure successfully completed. SQL> EXECUTE DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl ...

I love this Symfony

I love this  Symfony. But I do not know what is its name!

Deploying Oracle ADF Essentials Applications to Glassfish

Image
Oracle Introduces Free Version of Oracle Application Development Framework New Oracle ADF Essentials Brings ADF Benefits to the Broader Developer Community Redwood Shores, Calif. – September 24, 2012 News Facts Oracle today released  Oracle Application Development Framework (ADF) Essentials . Oracle ADF Essentials enables the global developer community to leverage the core capabilities of  Oracle Application Development Framework  free of cost. Oracle ADF Essentials is standards-based and deploys on  GlassFish Server Open Source Edition , giving developers the ability to adopt and extend Oracle ADF functionality to new environments. To simplify the developer experience and deliver rich functionality,  Oracle JDeveloper provides visual and declarative development capabilities for Oracle ADF Essentials. Oracle Enterprise Pack for Eclipse  is intended to support Oracle ADF Essentials in a future release.    for more information...

How to get a value form the resource bundle file in ADF

Image
Hi So many times we need to show message to the users. The problem is that we do not want to pass the message text as hard coded. We sometimes need to read this message from the resource bundle. In this discussion , I will show how to achieve this task within both the ViewController and Model project. 1- How to achieve this in the ViewController Project. The following method accepts a String parameter which is the KEY and return the text for this key in the resource bundle. String resourceBundle is variable represents the class name of the resource bundle file. In order to now the resource bundle for the project , Just go to the project property,Resource Bundle /** * added by tarek fathy  * oct 02 2012  * use this method to return a value from the ViewControllerBundle file  * just pass the key  * @param identifier  * @return String  * this method will work only if the rec...

ADF sample projects

http://java.net/projects/smuenchadf/pages/ADFSamples

How to change the content language according to the page locale

Image
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.

setDomainEnv file in weblogic

@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                   ...

how To get the current row index and the rows count

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

java.sql.SQLException: ORA-01005: null password given; logon denied

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...

ADF (or JRF) support for third party application servers

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

Retrieving the previous value of an ADF BC attribute

Image

Checking Data Changes in ADF

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

How to get value form a list or poplist

Instead of looping throw the iterator to get the value from the index, You can simply set the property "valuePassThrough" = true in the list

How to make summary Column.How to calculate Sum of a column.

Image
Hi I have a af:table that displays information about Employee vacation. I want to sum the value of the column "ActualNumberOfDays". Here is the table. I will Explain how I calculated the total of the "Acutal days" column. 1- I Created a readonly view based on Query SELECT     v_emv.ID emv_id,     v_emp.EMP_ID emp_id,     v_emp.EMP_NAME_AR ar_name_full,     v_emp.EMP_NUM,     v_vat.NAME_AR,     v_emv.START_DATE,     v_emv.END_DATE,     v_emv.NUMBER_OF_DAYS,     v_set.ACTUAL_END_DATE set_end_date,     v_emv.HOLIDAYS,     v_emv.VACATION_STATUS,     v_set.ACTUAL_NUMBER_OF_DAYS - NVL(v_set.ACTUAL_HOLIDAYS, 0) - NVL(v_set.MISSION_DAYS, 0) actual_number_of_days  FROM     HRS_V_EMP_BASIC_INFO v_emp,     HRS_V_EMP_VACATIONS v_emv,     HRS_V_VACATION_TYPES v_vat,...