You can see the executed queries and its bind values in the jdeveloper console or messages window.
By default, this option is not available in jdeveloper.
To enable the debug console option in 11g and 12c
I was just going through my previous posts and found the this option still works on Jdeveloper 11g and 12c. So you could use the debug option on the ADF BC - Model project and it will log all the queries on the jDeveloper console during execution.
Just follow same set of instructions as given for 10g jdeveloper.
To enable the debug console option in 10g
1. Right click on project and select project properties
2. Select Run/Debug
3. Ensure Default in selected in Run configurations
4. Select Edit button.
5. You can see the Launch Settings window.
6. Add the following parameter in the java options
-Djbo.debugoutput=console
7. Select OK
8. Rebuild the project and run again to see the debug information in jdeveloper log window
To enable the debug console option in Jdev 9i
1. Right click on project and select project properties
2. Navigate Configurations -> Development -> runner
3. Add the following parameter in the java options
-Djbo.debugoutput=console
4. Select OK
5. Rebuild the project and run again to see the debug information in jdeveloper log window
This option would be very helpful in finding out what going on in the bc4j objects. Including LOV queries, poplist queries, VOs etc. Whenever the query is executed through the AM or procedure is called, the bind variable values and executed sql will be displayed in the jdeveloper message window.
Article By:
Prasanna Jayaraman
Please post your Ideas and Comments
No comments :
Post a Comment