This week's giveaway is in the EJB and other Java EE Technologies forum. We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan on-line! See this thread for details.
Rajeev, In all likelyhood a specific table is locked rather than the whole database. Does the console have a query open? Maybe it has a write lock on the table which would prevent other apps from accessing it.