*
The moose likes JDBC and the fly likes which sql going in database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "which sql going in database" Watch "which sql going in database" New topic
Author

which sql going in database

Karan Johar
Greenhorn

Joined: Oct 02, 2009
Posts: 25
how to know which sql is going to database and how many time it going.
any tool can tell me how to see.
Peter Johnson
author
Bartender

Joined: May 14, 2008
Posts: 5812
    
    7

What database are you using? The ones I know of provide means to log all SQL statements.


JBoss In Action
Karan Johar
Greenhorn

Joined: Oct 02, 2009
Posts: 25
it is mysql
ujjwal soni
Ranch Hand

Joined: Mar 28, 2007
Posts: 403
Hi There,

Check out below link.

http://www.mysql.com/why-mysql/white-papers/mysql_wp_queryanalyzer.php


Cheers!!!
Ujjwal B Soni <baroda, gujarat, india> <+919909981973>
"Helping hands are better than praying lips......"
Peter Johnson
author
Bartender

Joined: May 14, 2008
Posts: 5812
    
    7

For MySQL you can set the "log" and "log-update" entries in the config file (see the docs for details). Or you can use the Admin GUI to turn the logs on.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: which sql going in database
 
Similar Threads
ORA-01009-missing mandatory parameter
Code compatibilty in j2ee application while migrating from SQL Server 2000 to SQL Server 2005
SQL Jobs
Using Indexing concept for performance ?
JUnit and SQL isolation