what is meant by connection pooling?
Answers were Sorted based on User's Feedback
Answer / sknkarthik
connection pooling is collection of data base collection
that are opend once and loded in to the memory. so these
connection can reuse without reconnect in to the dbms
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / mayilvahanan
Connection pooling is the proper way of handling a database
connection.
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / guest
Pre creation of connection objects ,by using jndi
or
implementing our own method()
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / bawa
<<collection of data base collection>> should be corrected as "collection of data base connections"
| Is This Answer Correct ? | 0 Yes | 1 No |
Difference between Dirty, commited ,phantom,repeatable reads?
Explain the necessary steps to connect to the database in java?
Why “no suitable driver” error occurs?
What do you mean by metadata and why we are using it?
How do we call a stored procedure from jdbc?
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
how to prevent finally block from execution
Why can't I invoke the ResultSet methods afterLast and beforeFirst when the method next works?
When do we use execute method in java jdbc?
What are the main steps in java to make JDBC connectivity?
What are drivers available?
How do I know which jdbc driver to use?