SQL queries run when a Page is hit

[Vikas V, módosítva 11 év-val korábban]

Am using Liferay 6.0 CE.

Where can I get the SQL queries run (Select, delete, insert etc) which perform on tables (User_, Group_ , contact_ etc)
when we click on a page which has portlet configured to it.

I have different pages like /web/portal/home1, /web/portal/accounts1 etc. and each have been configured with its corresponding portlets.

When these pages are hit/viewed, what are the SQL statements run to fetch details from DB?

Regards

[Juhi Kumari, módosítva 11 év-val korábban]

Hi
Put this line in your portal-ext.properties to see sql queries in console.

hibernate.show_sql=true

Regards
Juhi