Win a copy of React Cookbook: Recipes for Mastering the React Framework this week in the HTML Pages with CSS and JavaScript forum!
  • 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
  • Ron McLeod
  • Paul Clapham
  • Rob Spoor
  • Liutauras Vilda
Sheriffs:
  • Jeanne Boyarsky
  • Junilu Lacar
  • Tim Cooke
Saloon Keepers:
  • Tim Holloway
  • Piet Souris
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
Bartenders:
  • Frits Walraven
  • Himai Minh

What is "Connection Pooling"

 
Ranch Hand
Posts: 35
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
That is a really big piece of pie for such a tiny ad:
the value of filler advertising in 2021
https://coderanch.com/t/730886/filler-advertising
reply
    Bookmark Topic Watch Topic
  • New Topic