What Select statement did my ADF application send to the database

A question came up on our internal mail lists asking whether a view object might "trim" its select statement if some of the attributes we never used; e.g. they weren't bound to a page.

I wanted to test this out so a simple trick to ensure you can see the select statement that is being sent to the database is the following.  For the ViewController project, right click and Select Project Properties and then Run/Debug/Profile.  In the resulting dialog set Java Options to -Djbo.debugoutput=console

This will ensure that the SELECT statement (and alot more besides) will be sent to the log console window in JDeveloper, as show below.

This is a really valuable tip for tracing out what the framework is doing when you perform specific actions in your application

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

Tips, Tricks, Events and Information around Oracle JDeveloper, ADF, and Oracle Forms

Search

Archives
« April 2014
MonTueWedThuFriSatSun
 
1
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
    
       
Today