JDBC connection pooling : Java Glossary

*0-9ABCDEFGHIJKLMNOPQRSTUVWXYZ (all)

JDBC connection pooling
There is quite an overhead to setting up a connection to an SQL (Standard Query Language) database via JDBC (Java Data Base Connectivity). You want to avoid doing it if possible for every transaction. On the other hand, there is a fair overhead for each connection and sometimes a fairly small limit on the simultaneous number of connections enforced by licencing. So you can’t very well leave a connection open per session. JDBC connections are single thread, so you cannot easily use a single connection for mulitiple purposes. The solution is to use a pool of connections, which works much like a pool of corporate vehicles. The pool of connections stay open, with a connection assigned to only a single given purpose at a time. Happily, it is unlikely you will need to write your own code to manage the pool of connnections.

Tips

Learning More


Apache DBCP: connection pooling
Apache MyFaces
EE connection pooling
EJB
GlassFish
Hibernate
Java Ranch connection pooling tips
JBoss
JDBC
JDBC 3 connection pooling
JNDI
JPA
JSF
MiniConnectionPoolManager: a lightweight standalone JDBC connection pool manager
MVC
Oracle TopLink
performance tuning connection pooling
SQL
Tomcat
Tomcat: JNDI connection pooling how to
Tomcat: JNDI Datasource connection pooling examples

This page is posted
on the web at:

http://mindprod.com/jgloss/jdbcconnectionpooling.html

Optional Replicator mirror
of mindprod.com
on local hard disk J:

J:\mindprod\jgloss\jdbcconnectionpooling.html
Canadian Mind Products
Please the feedback from other visitors, or your own feedback about the site.
Contact Roedy. Please feel free to link to this page without explicit permission.

IP:[65.110.21.43]
Your face IP:[3.238.233.189]
You are visitor number