aspose file tools*
The moose likes Performance and the fly likes Websphere dbpool vs C3PO vs DBPool Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Performance
Bookmark "Websphere dbpool vs C3PO vs DBPool" Watch "Websphere dbpool vs C3PO vs DBPool" New topic
Author

Websphere dbpool vs C3PO vs DBPool

Sergio Felix
Greenhorn

Joined: Oct 31, 2008
Posts: 9
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

Joined: Oct 29, 2001
Posts: 8866
    
    8

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.


"blabbing like a narcissistic fool with a superiority complex" ~ N.A.
[How To Ask Questions On JavaRanch]
Sergio Felix
Greenhorn

Joined: Oct 31, 2008
Posts: 9
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

Joined: Oct 29, 2001
Posts: 8866
    
    8

When I say "container" in my post above, I mean the application container, as in Weblogic/Websphere/Tomcat.
Billy Tsai
Ranch Hand

Joined: May 23, 2003
Posts: 1297
Just use the connection pool provided by the application server


BEA 8.1 Certified Administrator, IBM Certified Solution Developer For XML 1.1 and Related Technologies, SCJP, SCWCD, SCBCD, SCDJWS, SCJD, SCEA,
Oracle Certified Master Java EE 5 Enterprise Architect
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Websphere dbpool vs C3PO vs DBPool