wa is connection pooling? how do u create connection pooling?wat is use connec

wa is connection pooling? how do u create connection
pooling?wat is use connection pooling?

Question Posted / elamathi

1 Answers
6327 Views
Covansys, I also Faced
E-Mail Answers

wa is connection pooling? how do u create connection pooling?wat is use connection pooling?..

Answer / rikin patel

What is connection pooling?
=>
With servlets, opening a database connection is a major
bottleneck because we are creating and tearing down a new
connection for every page request and the time taken to
create connection will be more. Creating a connection pool
is an ideal approach for a complicated servlet. With a
connection pool, we can duplicate only the resources we
need to duplicate rather than the entire servlet. A
connection pool can also intelligently manage the size of
the pool and make sure each connection remains valid. A
number of connection pool packages are currently available.
Some like DbConnectionBroker are freely available from Java
Exchange Works by creating an object that dispenses
connections and connection Ids on request. The
ConnectionPool class maintains a Hastable, using Connection
objects as keys and Boolean values as stored values. The
Boolean value indicates whether a connection is in use or
not. A program calls getConnection() method of the
ConnectionPool for getting Connection object it can use; it
calls returnConnection() to give the connection back to the
pool.

Is This Answer Correct ?

5 Yes

3 No

Post New Answer

More JDBC Interview Questions

What is the use of dialect?

0 Answers

Different statements in JDBC?

3 Answers

dear friends I have made connection with SQLSERVER where the following code is compiling properly but giving error at the runtime . I think error in this line where i am sending the value through string Connection connection = DriverManager.getConnection ( "jdbc:microsoft:sqlserver://localhost:1433","sa",""); import java.sql.*; //import mssqlserver.*; public class TestSQLCON { public TestSQLCON() throws Exception { // Get connection DriverManager.registerDriver(new com.microsoft.jdbc.sqlserver.SQLServerDriver()); System.out.println(); System.out.println("Successfully connected one"); System.out.println(); Connection connection = DriverManager.getConnection ( "jdbc:microsoft:sqlserver://localhost:1433","sa",""); if (connection != null) { System.out.println(); System.out.println("Successfully connected"); System.out.println(); // Meta data DatabaseMetaData meta = connection.getMetaData(); System.out.println("\nDriver Information"); System.out.println("Driver Name: " + meta.getDriverName()); System.out.println("Driver Version: " + meta.getDriverVersion()); System.out.println("\nDatabase Information "); System.out.println("Database Name: " + meta.getDatabaseProductName()); System.out.println("Database Version: "+ meta.getDatabaseProductVersion()); } } public static void main (String args[]) throws Exception { TestSQLCON test = new TestSQLCON(); } } so please help me

2 Answers

How do I find jdbc version?

0 Answers

java based application for hospital management

0 Answers

How to check null value in JDBC?

1 Answers CTS,

Explain about the Try Block?

0 Answers

Does jdbc use ssl?

0 Answers

What is JDBC Connection? Explain steps to get Database connection in a simple java program.