This week's book giveaway is in the OCAJP forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide 1Z0-808 and have Jeanne Boyarsky & Scott Selikoff on-line! See this thread for details.
Sriram, Yes, a database session is open until the connection is closed - not just returned to the pool. This is how we can get a StaleConnection error. Sometimes a connection is in the pool that is no longer valid.