Re: Tracing a StoredProcedure call,
Andreas Schlicker <[email protected]>
| Newsgroups | gmane.comp.db.mysql.java |
|---|---|
| Message-ID | <[email protected]> |
Hi Simon, > Wondering if anyone has source for tracing a JDBC Call (execution time, parameters, stored procedure called) or could point me in the right direction. It has been a wile since I used but, P6Spy (http://www.p6spy.com/) could help you out. It tunnels all calls to the MySQL Connector and traces execution time and parameters and so on, and creates a text file with all the information. You can use SQL Profiler (http://www.jahia.net/jahia/page597.html) as graohical front-end for P6Spy. It processes the text output and shows the information tabulated. Both are very easy to use and the only thing you have to change is to use P6Spy as DB-Driver and P6Spy forwards everything to the configured real driver. Hope that helps. Andreas -- MySQL Java Mailing List For list archives: http://lists.mysql.com/java To unsubscribe: http://lists.mysql.com/[email protected]