Debugging ADF Apllication


  1. How to Enable ADF Business Components Debug Diagnostics
open the Run/Debug/Profile page in the Project Properties dialog for your data model project. Click Edit to edit the chosen run configuration, and add following string to the Java Options field in the page.

-Djbo.debugoutput=console


Example:



Diagnostic Output of Business Component Browser


:
[355] Oracle SQLBuilder: Registered driver: oracle.jdbc.OracleDriver
[356] Creating a new pool resource
[357] **** DBTransactionImpl establishNewConnection
[358] Successfully logged in
[359] JDBCDriverVersion: 11.1.0.7.0-Production
[360] DatabaseProductName: Oracle
[361] DBTransactionImpl initTransaction
[362] Replacing: null with: StoreServiceAM_AddressesPageDef
[363] Replacing: null with: StoreServiceAM_MostPopularProductsByCategoriesPageDef
...
[537] Orders ViewRowSetImpl.execute caused params to be "un"changed
[538] Column count: 41
[539] ViewObject: Orders Created new QUERY statement
[540] Orders>#q computed SQLStmtBufLen: 952, actual=865, storing=895
[541] SELECT OrderEO.ORDER_ID, OrderEO.ORDER_DATE, OrderEO.ORDER_SHIPPED_DATE,
       FROM ORDERS OrderEO ORDER BY OrderEO.ORDER_DATE desc
[542] Bind params for ViewObject: Orders




Another Effective way to debug all SQL and DML statemnts occurs on your application is to set oracle.jbo.common.ADFLoggerDiagnosticImpl to FINEST






To do this follow these steps


1- Run or debug you application


2-From window menu>select Application server










3-Right click on Integrated weblogic server and select configure oracle disgnosics


4-expand the tree oraclejbo , you will not Find oracle.jbo.common.ADFLoggerDiagnosticImpl so you have tto add it
















5- to add it click om add button above and write oracle.jbo.common.ADFLoggerDiagnosticImpl to search it and add it











NOW YOU CAN SEE THE qUERY AND dml STATMENTS IN YOU LOG PAN



ENJOY





















































Comments








Post a Comment













Popular posts from this blog









Another user has changed the row with primary key oracle.jbo.Key[12 ].




















Image







     Try these solutions:    make sure that you check "refresh after insert" and refresh after update" for the primary key column in you entity object.  in the application module tab Click the Properties tab and select jbo.locking.mode. Double click the “pessimistic”value next to the property to open the field editor and type “optimistic” over the value.Press enter.  if error still exist then you must set "refresh after insert" and refresh after update" as true for all attributes in the entity object  another way is to execute the View Object after the commit operation to bring back updated data to ViewObject. For this we need to override the  afterCommit()  of ViewObject class as follows:                     public void afterCommit(TransactionEvent){                          executeQuery();                   ...








Read more










weblogic windows JPS-01050: Opening of wallet based credential store failed. Reason java.io.IOException: Failed to lock cwallet.sso.lck





















Integreated weblogic serer cannot be started and retuen this error weblogic windows JPS-01050: Opening of wallet based credential store failed. Reason java.io.IOException: Failed to lock cwallet.sso.lck Solution is simple  just remove the cwallet.sso file and cwallet.sso.lck located in C:\Users\tarek.DHAMAN\AppData\Roaming\JDeveloper\system12.2.1.4.42.190911.2248\o.jdeveloper.rescat2.model Then open jevveloper again and start weblogic again








Read more










Working With File Throgh WebUtill





















-------------------------------------------------- Required Configuraion : By default the file transfer is disabled in webutil for a security measure. So, you have to enable File transfer configuration in webutil.cfg file. The webutil.cfg file is located in  forms\server. Open The webuil.cfg file and edit the following parameters : transfer.database.enabled=FALSE   Change To TRUE transfer.appsrv.enabled=FALSE       Change to TRUE WebUtil_File contains APIs to manipulate files and directories on the client. These Functions Or APIs are: Copy_File :  Copies a file Returns a Boolean to indicate success.  Syntax :   Webutil_File.Copy_File(SourceFileName in Varchar2 , Destination In Varchar2) Return Boolean  Example   Declare  vCopied Boolean;  Begin   vCopied :=  Webutil_File.Copy_File('C:\temp\mypic.jpg','X:\destination_folder');   If vCopied = true Then    Message('File copied Successfully');  Else   Message('Error in Copying File');  End if; Delete_File:  ...








Read more