• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

java.sql.SQLException: No available resource. Wait-time expired.

 
RajKumar Boga
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

I am using Sun Application Server 7 and backend is Oracle 9i.
In our project we are getting Exception as follows:


(i.e there are may be connections/cursors not closing at Database side
even if i am closing the connection as follows :



Is there any other way to close the connction?

thanks and regards
Rajkumar Boga
 
vishwanath nadimpally
Ranch Hand
Posts: 116
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


This is the preferred way of closing the db resources.
 
RajKumar Boga
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,


yes i agreee to that i have tried that too, but still no luck. What happens is when i create a new connection the server takes a existing opened connection from the Container connection pool, and the only way to get this resourse back to the container is to close the connection after use which we are doing by using the connection.close() method.

But, i think the connections are not getting replace back to the connection pool, cause the pool size that we have fixed is 30 and it exceeds this 30 connection when we check the connections opened from the database side....

I think we are missing something here, if any body can help me out with this issue that it would be very great!

Regards
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic