Meaningless Drivel is fun!
The moose likes JDBC and Relational Databases and the fly likes Connection pools Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Building Microservices this week in the Design forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Connection pools" Watch "Connection pools" New topic

Connection pools

alain martin
Ranch Hand

Joined: Apr 11, 2005
Posts: 43
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?

<a href="" target="_blank" rel="nofollow"></a>
Praveen Babu
Ranch Hand

Joined: Jul 30, 2006
Posts: 138

Follow the link for some good 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,
alain martin
Ranch Hand

Joined: Apr 11, 2005
Posts: 43
thank you, its a good link.

�Whitch have the best performance?
Masoud Kalali
Ranch Hand

Joined: Jul 08, 2004
Posts: 531

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 .

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 :

using connection pool ,in brief, improve the performance by reusing the connections instead of creating connections each time that you need a connection.

Masoud Kalali
Software Engineer - My Weblog - GlassFish Security
Have you checked out Aspose?
subject: Connection pools
It's not a secret anymore!