• 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
  • Tim Cooke
  • Devaka Cooray
  • Ron McLeod
  • Jeanne Boyarsky
Sheriffs:
  • Liutauras Vilda
  • paul wheaton
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Piet Souris
  • Carey Brown
  • Tim Holloway
Bartenders:
  • Martijn Verburg
  • Frits Walraven
  • Himai Minh

Connection Pooling - causes Hang up the Server

 
Ranch Hand
Posts: 125
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Friends,

We are encountering a problem in Websphere Connection Pooling.
We have set max connection as 10.

In a While loop we are calling a method which updates database. We are closing the connection in that database method at end.


If the while exceeds 10 iteration, we are facing the server hang up. It seems the close connection doesn't return connection immediately to the connection pool.

Please tell me, what could be the problem?. Is there any setting we have to change.
 
Ranch Hand
Posts: 66
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I cannot be but sceptical about this code. Why do you want 10 connections? There is no guarantee that you will be taking only 10 connections or that when you close the connection, it would go back to the pool.

The question I have is whether you really require to open the connection in the called function. Open one connection for all your transactions and one you are done with it, close it. To effectively utilize the pooling of the App Server, you will be needed to code within its limits.

You can definitley increase the connections from 10 to how many you want. But that will not solve this problem.

No solution, but redesign!
 
What kind of corn soldier are you? And don't say "kernel" - that's only for this tiny ad:
the value of filler advertising in 2021
https://coderanch.com/t/730886/filler-advertising
reply
    Bookmark Topic Watch Topic
  • New Topic