How to check the SQL statements generated

[Rauf]

I just want to see the SQL statements generated by a Find/Browse form.
For example,
I accessed P01012 from Solution Explorer -> Tools -> EnterpriseOne Menu -> [Fast Path] -> P01012.
Then in the 'Alpha Name' of P01012, I put *RAUF* and clicked Find. I got a list of values, but I did not see any SELECT commands in JDEDEBUG.LOG.
The JDE.ini file contains the following settings,

[DEBUG]
TAMMultiUserOn=0
Output=FILE
;Output=NONE
ServerLog=0
LEVEL=BSFN,EVENTS,SF_CONTROL,SF_GRID,SF_PARENT_CHILD,SF_GENERAL,SF_MESSAGING,SF_WORKFLOW,SF_WORKFLOW_ADMIN,SF_MEDIA_OBJ
;LEVEL=BSFN,EVENTS
;BSFN,EVENTS,SF_CONTROL,SF_GRID,SF_PARENT_CHILD,SF_GENERAL,SF_MESSAGING,SF_WORKFLOW,SF_WORKFLOW_ADMIN,SF_MEDIA_OBJ
DebugFile=c:\jdedebug.log
JobFile=c:\jde.log
Frequency=10000

How can I see the generated SQL statements ?

 

[Adrian_Chimirel]

You may want to read ID 201057344 (attached).

 

[jdelisths]

Rauf - For the WebDev client, you can turn on logging in the jdelog.properties file. It is located here:

<e1 install folder>\system\OC4J\j2ee\home\applications\webclient.ear\webclient\WEB-INF\classes

This assumes that you are using OAS as the local web server. It should be a similar location for WebSphere.

Here is how this file looks like with debugging turned on:

#The section name should be E1LOG. This logs all the log messages above WARN
[E1LOG]
FILE=log/jderoot.log
LEVEL=WARN
FORMAT=APPS
MAXFILESIZE=10MB
MAXBACKUPINDEX=20
COMPONENT=ALL
APPEND=TRUE

#Logging runtime and JAS above APP level will be helpful for application developers.
#Application developers should use this log as a substitute to analyze the flow of events
#in the webclient.
[LOG1]
FILE=log/jas.log
LEVEL=APP
FORMAT=APPS
MAXFILESIZE=10MB
MAXBACKUPINDEX=20
COMPONENT=RUNTIME|JAS|JDBJ
APPEND=TRUE


#Logging runtime and JAS at DEBUG level will be helpful for tools developers.
#Tool developers should use this log ato debug tool level issues
#[LOG2]
#FILE=log/jasdebug.log
#LEVEL=DEBUG
#FORMAT=TOOLS_THREAD
#MAXFILESIZE=10MB
#MAXBACKUPINDEX=20
#COMPONENT=ALL
#APPEND=TRUE

The logs are created here (based on the settings above):

<e1 install folder>\system\OC4J\j2ee\home\log