• 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
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Connection pools

 
Ranch Hand
Posts: 45
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I'm developing a web service application. I want use a pool connection. I searched in google and I found it can be done with tomcat, jdbcconnection poool and jndi.

I don't know the advantages and incenvenients of them. �which do you recomend me?
Thanks
 
Ranch Hand
Posts: 138
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,

Follow the link for some good connection pools.

http://java-source.net/open-source/connection-pools

The only difference between them are that they are from different vendors and also the performance. If you want the one with better performance, you still need to google.

Hope this helps you a little.

Bye & Regards,
Praveen
 
alain martin
Ranch Hand
Posts: 45
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
thank you, its a good link.

�Whitch have the best performance?
 
Author
Posts: 531
Mac OS X Netbeans IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
to have a connection pool you have at least two options:

-use a library that create the pool (you create it in your application and your application manage the pool) and use this pool to retrieve the connections.
-use applications server to create and manage the pool.

in first solution you download the library and use it to create a pool according to its manual, apache DBCP is a good option.
and here is a link to almost all open source connection pooling library that you can use for your connection pooling .
http://java-source.net/open-source/connection-pools

in the second solution you build the connection pool/datasource in application server admin console (web / command line /swing ) and then you can access to that data source using JNDI .you can also configure the pool in the context file for tomcat.
here is the reference : http://tomcat.apache.org/tomcat-4.1-doc/jndi-datasource-examples-howto.html

using connection pool ,in brief, improve the performance by reusing the connections instead of creating connections each time that you need a connection.
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic