Forums Register Login

Hibernate Connection Pool conf versus App Server Connection Pool conf

+Pie Number of slices to send: Send
What are the benefits of using a connection pool configured in the application server (JBoss, Weblogic, etc) than a connection pool configured in the cfg to hibernate?
+Pie Number of slices to send: Send
Your connection pooling, and efficient use of connections is an absolutely critical part of your entire architecture. Working with WebSphere, I always prefer to defer to WebSphere connection pooling. Why? Bias perhaps, but I like the idea of offloading this important work to the server provider. I'm assuming the server vendor has put more work into making their pooling services more reliable and robust than the ones that are managed and maintained within a give web app or ejb app. Plus, if something goes wrong, I've got the vendor's 'throat to choke.' If something goes wrong with Hibernate connection pooling, whose throat do you go for? With IBM, there's always a sales guy with a sore neck willing to offer support.

-Cameron McKenzie
+Pie Number of slices to send: Send
Hi Cameron,

I agree, but let us suppose that I am using JBoss and I don't have support. So, there is a benefit (maybe performance, manageability, etc)? Or is the same in both cases?

Thank-you
+Pie Number of slices to send: Send
Actually, I've always found that JBoss had the best paid support out there, but that's another story.

Beyond just trusting the vendor, I'm not sure of any definitive benefits. Maybe someone else can pipe in? Even my justification is more based on "Fear, Uncertainty and Doubt" as opposed to any real or calculated metrics or comparisons.

-Cameron McKenzie
+Pie Number of slices to send: Send
Thank's Cameron.
+Pie Number of slices to send: Send
I'm using an Apache DBCP datasource with hibernate. Works perfectly. There's no magic around pooling database connections. ;)
Live a little! The night is young! And we have umbrellas in our drinks! This umbrella has a tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 2041 times.
Similar Threads
No error/exception in log on insert yet no row inserted to db
MySQL Connection Pooling
Cannot find ActionMappings or ActionFormBeans collection
Can the properties file be maintained as part of the EAR or WAR, instead of in \conf (ie. seprately)
using a connection from the pool.
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 09:28:34.