• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Connection Pools won't recycle connections

 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hello,
I am experiencing a problem with connection pooling. Our Java app is using Weblogic61SP3 and an Oracle 8.1.7 database, connection via oracle:thin.
Each call by the application to our production database, opens up a new connection. Once the db call is done the connection isn't recycled and sent back into the pool, like it should. It's kept alive, and each subsequent db call opens up another db connection. Connections keep increasing until the max connection limit is reached. We are sure to close all connections within the code. Looking at these sessions on the Oracle side, shows each of these 'hung' connections to be inactive.
We pointed the same app to our test and staging databases (which are identical to production) and the connections shrink fine. Is there some setting on the Oracle side that I'm missing? They're on different boxes. Is WEblogic the culprit? Any help would be greatly appreciated.
Thanks
[ October 31, 2003: Message edited by: John Sam ]
 
Ranch Hand
Posts: 3695
IntelliJ IDE Java Ubuntu
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I once worked in an Oracle shop.

Our app was experiencing quirky behaviour, and we eventually tracked it to the database holding open connections. It would *appear* to the pool that connections were being released, but the db itself still held them open.

When confronted with this, Oracle fessed up there was a bug in the Oracle connection pooling, on the DB itself, not the driver. Ok, it might not be that they so much as 'fessed up', as we discovered the OTN entry regarding that known issue. "Known" only to Oracle I guess. :roll:

If you have a half-decent support arrangement with Oracle, you might investigate this. I'd search OTN for you, but I no longer have access.
 
Ranch Hand
Posts: 1143
1
Eclipse IDE Oracle Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Mike,
OTN requires registration in order to access it, but registration is free. So OTN is accessible to everyone. I think, perhaps, you were referring to MetaLink, which requires that you have an active Oracle support contract in order to access it.
[Just wanted to clarify that.]
Good Luck,
Avi.
 
Bartender
Posts: 9626
16
Mac OS X Linux Windows
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by John Sam:

Each call by the application to our production database, opens up a new connection. Once the db call is done the connection isn't recycled and sent back into the pool, like it should.


You ARE returning connections to the pool by invoking connection.close() on each instance inside a finally block (so it gets returned whether an exception occurs or not), right?
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic