What are the parameters used in Connection pooling?

Showing Answers 1 - 3 of 3 Answers


  • Mar 20th, 2006

please give me the answers for the above questions

  Was this answer useful?  Yes


  • Apr 8th, 2006

Connection pooling is one the new features introduced in ODBC 3.0. Connection pooling enables an ODBC application to reuse a connection from a pool of connections. Once a connection has been created and placed in the pool, an ODBC application can reuse the same driver and the connection within the same shared environment (henv) without performing the complete connection process. However, a connection can never be reused between different henv or different drivers.

  Was this answer useful?  Yes


  • Oct 24th, 2006

Creating a Connection object is one of the most expensive operations in database programming so we use connection pooling.When the application starts, a certain number of Connection objects are created and stored in a pool. When a database client, such as servlet, needs to use a Connection object, it does not create the object but instead requests one from pool. When the client is finished with it, the Connection object is returned to the pool.To use the Connection pooling feature in the javax.sql package, you need to connect to the data source using the javax.sql.DataSource interface. The sample code is:Context context = new InitialContext();DataSource ds = (DataSource) context.lookup("jdbc/myDB");Connection con = ds.getConnection(user, password);

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions