syamala

• Mar 20th, 2006

 

please give me the answers for the above questions

damodar

• 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.

ajaykjha

 Profile Answers by ajaykjha 

• 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);