I can find tools in Azure to monitor and get logs on the performance of the Azure SQL database. However, what tools are available in the Azure portal to see logs of failed SQL data manipulation …
Tag: logging
How to enable logging for SQL statements when using JDBC
I am trying to enable logs using my JDBC program by connecting to Oracle database in eclipse IDE. I have gone through this SO post JDBC logging to file then I have created below java program and running it from my eclipse IDE, but I was not able to see any logs generated by the JDBC driver classes. and I
How to show SQL query log generated by a RSpec test?
I am writing a spec for my rails 3 application. I want to test that db transactions are really working. It would be really helpful to be able to see the sql queries being generated my app while being driven by the spec. Is there a way to see the queries just like in the rails console? I’m using Rails
MySQL create time and update time timestamp
I am creating some tables where I want to store the time when a record was created and when it was last updated. I thought I could have two timestamp fields where one would have the value …
How to log SQL statements in Grails
I want to log in the console or in a file, all the queries that Grails does, to check performance. I had configured this without success. Any idea would help.
How can I use a PostgreSQL triggers to store changes (SQL statements and row changes)
Using PostgreSQL triggers, is it possible to record the changes that have happened to a table due to INSERT or UPDATE SQL statements and log them to a file for later execution. This is only to be used temporally so just something quick and dirty would do. Answer example of an audit trigger from https://www.postgresql.org/docs/current/static/plpgsql-trigger.html