This week's giveaway is in the Spring forum.
We're giving away four copies of Microservices Testing (Live Project) and have Chris Love & Andres Sacco on-line!
See this thread for details.
Win a copy of Microservices Testing (Live Project) this week in the Spring 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Liutauras Vilda
  • Henry Wong
  • Devaka Cooray
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Al Hobbs
  • Carey Brown
Bartenders:
  • Piet Souris
  • Mikalai Zaikin
  • Himai Minh

Websphere dbpool vs C3PO vs DBPool

 
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hey guys!

I've been using the DBPool in most of my web applications with good performance. A few days ago the "server department" decided to buy Websphere Aplication Server (WAS). So the questions are:

Should I bother rewriting my applications to use WAS's db pool or should I stick with the other pools?

Is websphere's connection pool any better then the others? If so, how?

Thanks for taking the time to read this =)
 
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
My wild guess would be that the time spent obtaining a connection from any brand of database connection pool will be dwarfed by practically every other operation in your application, so I'd be hard pressed to recommend one pool over another.
I have applications running on Weblogic and Tomcat. I always use the container-managed database pool. My reasoning is that my application can focus on business problems rather than configuring the environment and setting up resources, and it's one less third-party dependency I have to manage.
In your situation, I would probably leave my existing applications as-is, but look at using container-managed pools for future applications.
 
Sergio Felix
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thankyou for responding, Joe Ess. My application does have containers that work with the pool. They are written on Java classes that get called by the JSP's. Is this the correct approach to the container-based applications that you mention?
 
Joe Ess
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
When I say "container" in my post above, I mean the application container, as in Weblogic/Websphere/Tomcat.
 
Ranch Hand
Posts: 1327
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Just use the connection pool provided by the application server
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic