Deepak Bala wrote:A select query does not need a commit.
You can set a connection to auto commit or set method level transactions or some other form of transaction level management to take care of commits
Largely correct. However, most databases will have to rely on their time out behvaiour to release the resources associated with the transaction if you don't commit or rollback. So if you start one, its a good idea to finish it. Like you said, the best approach for selects is not to use a transaction.