How are you doing the transaction?
Is it one transaction per request, or do you have multiple transactions per request?
Are you using a transaction for reads? Do you comit these?
Yes i do transactions for read.No i didn't commit.
properly end the transaction when you've finished with it.
What are transaction for? They are for ensuring data integrity during updates
No i don't use the transaction when i select some thing.I want to update database.
No I trying to tell when i use transactions within the this application.
I am properly ended every transaction.
So, re-reading your original problem. Do you actually have out of memory errors? Or are you just worried this may cause them? The awaiting command state shouldn't be causing much in the way of memory issues in Tomcat.