RE: what is connection pooling? what is the main advan...
whenever our web app needs an access to database it connects to the database. it will be disadvantageous if it connect every time a user sends a request for a particular data.so the server maintains a pool of connection instances. so if a request comes it will take a instance from the pool and serve.because the database connection is tedious task so it is better to maintain a pool of connection instances. it makes the access faster.
RE: what is connection pooling? what is the main advantage of using connection pooling?
in traditional jdbc we are able to create two-tier applcns by creating various DSNs in the localmachine. creating various DSNs for various JDBC applcns may also kill the performance of the JDBC applcn. whereas in JDBC 3.0, we have a concept calllng CONNECTION POOLING through which we can develop three tier applcns without creating any DSNs into the local machine (Connection Pooling is a process of maintaining pool of readily available database connection objects.). This concept comealong with J2EE enabled servers like weblogic, websphere,etc....
RE: what is connection pooling? what is the main advantage of using connection pooling?
Connection pooling is used to improve the performance of an application.here we can create any number of connection objects and keep it in a pool. When we want to use connection object , we can take an object from a pool ,use it .Instead of throwing it out , again put into the pool so that you can use it at a later point of time.
if you take weblogic , you need DataSource object to get the connection from connection pool.
RE: what is connection pooling? what is the main advantage of using connection pooling?
To connecting with any data base need connection and afetr compltion of task that connection get expire so next tim again we need to create connection its degrade the performance To avoid this we have coonction pooling in the connection pooling we can crete some coonection wn needed take connection use it and afetr that connection will return to the pool...By this way we can increase performance
