Can i get the sql query which is being generated to fetch data for lists in the browse screen ?

Support
#1

Hi,
Can i get the sql query which is being generated for the list of data in the browse screen ?

For Example:
Suppose i have a “Persons” browse screen, where different fields are there like


 <u><b>Name </b></u>       <u><b>DOB</b> </u>       <u><b>Gender</b></u>      <u><b>Occupation</b></u>
 Bismay     13/06/91     Male      Java Developer

Can i get the query generated for fetching the data in the list ?

#2

You can see SQL statements being executed in the application log (build/tomcat/logs/app.log) if you set “eclipselink.sql” logger to “DEBUG”. You can do it in Administration > Server Log > Options or directly in tomcat/conf/logback.xml.
See also Setting up Logging in Tomcat - CUBA Platform. Developer’s Manual

#3

Thank u Konstantin,
Its really helped a lot.