You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@tomcat.apache.org by bu...@apache.org on 2011/06/16 23:15:52 UTC
DO NOT REPLY [Bug 51388] New: SlowQueryReport should respect
Statement.getQueryTimeout() value
https://issues.apache.org/bugzilla/show_bug.cgi?id=51388
Bug #: 51388
Summary: SlowQueryReport should respect
Statement.getQueryTimeout() value
Product: Tomcat Modules
Version: unspecified
Platform: All
OS/Version: All
Status: NEW
Severity: enhancement
Priority: P2
Component: jdbc-pool
AssignedTo: dev@tomcat.apache.org
ReportedBy: hay_dave@yahoo.com
Classification: Unclassified
It would be nice if the threshold for slow queries could be configured on a
per-query basis.
This could be done by respecting the value returned from
Statement.getQueryTimeout() in AbstractQueryReport.StatementProxy. If the
value returned from the Statement is non-zero and greater than the
SlowQueryReport 'threshold', the the value from the query is used instead.
This behavior should probably be something that could be toggled on or off.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@tomcat.apache.org
For additional commands, e-mail: dev-help@tomcat.apache.org
DO NOT REPLY [Bug 51388] SlowQueryReport should respect
Statement.getQueryTimeout() value
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=51388
Lucas Pouzac <lu...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |lucas.pouzac.pro@gmail.com
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@tomcat.apache.org
For additional commands, e-mail: dev-help@tomcat.apache.org
DO NOT REPLY [Bug 51388] SlowQueryReport should respect
Statement.getQueryTimeout() value
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=51388
Filip Hanik <fh...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |WONTFIX
--- Comment #1 from Filip Hanik <fh...@apache.org> 2012-03-20 17:12:58 UTC ---
If you setQueryTimeout(5 seconds) then the query would timeout through a
SQLExeption at that time, and the threshold for SlowQueryReport would not be
met.
The only option would be to not propagate setQueryTimeout, but that would
fundamentally change the way an application works, and could leave queries
hanging unintentionally.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@tomcat.apache.org
For additional commands, e-mail: dev-help@tomcat.apache.org
DO NOT REPLY [Bug 51388] SlowQueryReport should respect
Statement.getQueryTimeout() value
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=51388
Lucas Pouzac <lu...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC|lucas.pouzac.pro@gmail.com |
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@tomcat.apache.org
For additional commands, e-mail: dev-help@tomcat.apache.org