Hi Friends What is "Connection Pooling" I am developing Java Application using ms sql server 2000 database Pl explain me about this thanxinadvance yours Suji
posted 14 years ago
Connection Pooling is a concept in which u can make a pool of connections to enhance the performance of your application.This is quite helpful as sometimes making and tearing a connection is more costly than actually executing the sql command.For this reason a pool is made to keep the connection alive and application can get the connection frm this pool to execute commands after which the connection is returned to the pool to be used again.If all the connections of the pool are being used, then new connections are made available to the application. Connection pooling is supported by JDBC 2.0 in which a class called DBConnectionPool is there which provided methods to get an open connection from the pool, return a connection to the pool, release all resources and close all connections at shutdown. It also handles connection failures, such as time-outs, communication failures, etc. and can limit the number of connections in the pool to a predefined max value Recently released JDBC 3.0 API provided some more new methods added to DBConnectionPool.Apert from it, JDBC 3.0 also provides method to pool Prepared statements which greatly enhances the application performance by saving resources.