This week's giveaway is in the Spring forum.
We're giving away four copies of Learn Spring Security (video course) and have Eugen Paraschiv on-line!
See this thread for details.
Win a copy of Learn Spring Security (video course) this week in the Spring forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Websphere dbpool vs C3PO vs DBPool

 
Sergio Felix
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • 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 =)
 
Joe Ess
Bartender
Posts: 9256
9
Linux Mac OS X Windows
  • Mark post as helpful
  • send pies
  • 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
  • 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: 9256
9
Linux Mac OS X Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
When I say "container" in my post above, I mean the application container, as in Weblogic/Websphere/Tomcat.
 
Billy Tsai
Ranch Hand
Posts: 1304
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Just use the connection pool provided by the application server
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic