Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Provide option to return SQL generated / execution stats

Description

Shantanu: Provide a mechanism to show the SQL being executed (configurable, so that it can be turned off)

Sean: Good idea. Even better, a way to access statistics about the prepared statement after execution - timing etc?

Shantanu: Yes, that would be an add-on value to show how are the queries performing.

Environment

None

Activity

Sean Corfield August 27, 2015 at 3:02 AM

Since there is no portable way to do this and the output of (.toString stmt) differs across drivers such that extracting the generated SQL / parameters in any meaningful way is difficult, I'm going to decline this one.

Sean Corfield January 16, 2015 at 7:17 PM

Sounds like not all drivers can support this but PreparedStatement.toString() returns the generated SQL for some databases: http://stackoverflow.com/questions/2683214/get-query-from-java-sql-preparedstatement

Sean Corfield September 15, 2013 at 10:21 PM

Post 0.3.0

Declined

Details

Assignee

Reporter

Priority

Created May 9, 2011 at 3:12 AM
Updated June 1, 2016 at 6:41 PM
Resolved June 1, 2016 at 6:41 PM