aspose file tools
The moose likes JDBC and Relational Databases 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 Head First Android this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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: 5850
    
    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> <+918866008962>
"Helping hands are better than praying lips......"
Peter Johnson
author
Bartender

Joined: May 14, 2008
Posts: 5850
    
    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.
 
Don't get me started about those stupid light bulbs.
 
subject: which sql going in database
 
It's not a secret anymore!