Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Connection Pooling Tomact vs. Java based

 
Bobby Cunningham
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have heard that it is better to do your connection pooling on the server vs in the code is that true? If so how will it benefit me doing on Tomcat. We currently run Tomcat 5.5 and we have a Sybase database here at my company. Any tips that you have would be welcomed. . .. Help plz!!!
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Bobby,
Welcome to JavaRanch!

You are correct that a connection pool managed by the server will be better. The server is able to better manage resources than the code. This is more true for the bigger app servers like WebSphere that use a DataSource for EJBs.

Tomcat uses a a free library from Jakarta Commons for the connection pooling. This is likely better optimized than one you would write yourself.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic