Seeing the underlying SQL in the Spring JdbcTemplate?

by

The Spring documentation says they’re logged at DEBUG level:

All SQL issued by this class is logged at the DEBUG level under the category corresponding to the fully qualified class name of the template instance (typically JdbcTemplate, but it may be different if you are using a custom subclass of the JdbcTemplate class).

In XML terms, you need to configure the logger something like:

<category name="org.springframework.jdbc.core.JdbcTemplate">
    <priority value="debug" />
</category>

This subject was however discussed here a month ago and it seems not as easy to get to work as in Hibernate and/or it didn’t return the expected information: Spring JDBC is not logging SQL with log4j This topic under each suggests to use P6Spy which can also be integrated in Spring according this article.

More Related Contents:

  1. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  2. Does the JDBC spec prevent ‘?’ from being used as an operator (outside of quotes)?
  3. Error: Column does not exist
  4. When I call PreparedStatement.cancel() in a JDBC application, does it actually kill it in an Oracle database?
  5. The network adapter could not establish the connection – Oracle 11g
  6. How do I execute a MS SQL Server stored procedure in java/jsp, returning table data?
  7. Call stored procedure with table-valued parameter from java
  8. SQL is null and = null [duplicate]
  9. Aggregate columns with additional (distinct) filters
  10. Reset identity seed after deleting records in SQL Server
  11. How to avoid the “divide by zero” error in SQL?
  12. SQLite Reset Primary Key Field
  13. Using an ORM or plain SQL? [closed]
  14. How to declare variable and use it in the same Oracle SQL script?
  15. Dynamic SELECT TOP @var In SQL Server
  16. MySQL’s now() +1 day
  17. Laravel Eloquent: sum with groupBy
  18. Are a CASE statement and a DECODE equivalent?
  19. Can you access the auto increment value in MySQL within one statement?
  20. Generate script in SQL Server Management Studio
  21. Oracle SQL – Identify sequential value ranges
  22. How can I include null values in a MIN or MAX?
  23. How can I alter this computed column in SQL Server 2008?
  24. How to get the size of a varchar[n] field in one SQL statement?
  25. SQL Server Update Group by
  26. Query for getting value from another record in same table and filter by difference greater than a gap threshold
  27. Closing connection when using Dapper
  28. SQL CREATE LOGON – can’t use @parameter as username
  29. In Oracle, is it possible to INSERT or UPDATE a record through a view?
  30. Return rows from INSERT with ON CONFLICT without needing to update

Leave a Comment