HOW TO CAPTURE SQL submitted to server

Questions and answers regarding general SQL and backend databases

HOW TO CAPTURE SQL submitted to server

Postby dlclark » Thu Mar 24, 2022 5:51 pm

I remember a comment during one of the WEBINARS regarding the ability to log SQL Queries submitted to the server.

Not finding documentation on setup?

Daryl
dlclark
 
Posts: 38
Joined: Sat Jan 08, 2022 5:39 pm

Re: HOW TO CAPTURE SQL submitted to server

Postby swingman » Thu Mar 24, 2022 10:51 pm

Hi Daryl,

If you simply want to look at the queries, the quickest is to look at the database performance screen in servoy-admin.

<yourserverurlhere>/servoy-admin/database-performance

This also works in Servoy Developer.

Hope this helps,
Christian Batchelor
Certified Servoy Developer
Batchelor Associates Ltd, London, UK
http://www.batchelorassociates.co.uk

http://www.postgresql.org - The world's most advanced open source database.
User avatar
swingman
 
Posts: 1472
Joined: Wed Oct 01, 2003 10:20 am
Location: London

Re: HOW TO CAPTURE SQL submitted to server

Postby dlclark » Fri Mar 25, 2022 3:36 pm

Thanks, after setting to unlimited and restarting, I see there is now a LINK for the database and after starting up the client - the SQL is logged!

Daryl
dlclark
 
Posts: 38
Joined: Sat Jan 08, 2022 5:39 pm


Return to SQL Databases

Who is online

Users browsing this forum: No registered users and 9 guests