Win a copy of Zero to AI - A non-technical, hype-free guide to prospering in the AI era this week in the Artificial Intelligence and Machine Learning forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Paul Clapham
  • Bear Bibeault
  • Jeanne Boyarsky
Sheriffs:
  • Ron McLeod
  • Tim Cooke
  • Devaka Cooray
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Jj Roberts
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • salvin francis
  • Scott Selikoff
  • fred rosenberger

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

 
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
 
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
 
Don't play dumb with me! But you can try this tiny ad:
the value of filler advertising in 2020
https://coderanch.com/t/730886/filler-advertising
reply
    Bookmark Topic Watch Topic
  • New Topic