What is Connection pooling? Explain Pros and Cons?

Answer / niranjanravi

Connection pooling is the process of resuing the database
connections between application and the server to increase
in the perfaomance of the application.

Is This Answer Correct ?    9 Yes 1 No

Post New Answer

More Core Java Interview Questions

What are the limitations for static method?

3 Answers   Greenwood,

can we take more than one null values for Unique constraints.

1 Answers   3i Infotech,

The following program reads data (details of students) from a file named students.txt and converts it into e-mail addresses. The results are written to a file named studentemail.txt. students.txt consists of a number of lines, each containing the data of a student in colon delimited format: Last Name:First Name:Student Number Each input record is converted to an e-mail address and written to studentemail.txt in the following format: the first character of the last name + the first character of the first name + the last four digits of the student number + “@myunisa.ac.za” import java.io.*; public class EmailConverter { public static void main(String[] args) throws IOException { BufferedReader input = new BufferedReader(new FileReader ("students.txt")); PrintWriter output = new PrintWriter(new FileWriter ("studentemail.txt")); String line = input.readLine(); while (line != null) { // Extract the information for each student String[] items = line.split(":"); // Generate the email address String email = "" + items[0].charAt(0) + items[1].charAt(0) + items[2].substring(4,8) + "@myunisa.ac.za"; email = email.toLowerCase(); // Output output.println(email); line = input.readLine(); } input.close(); output.close(); } } Rewrite the class so that it handles possible errors that may occur. In particular, it should do the following: • It should catch at least three appropriate exceptions that might occur, and display suitable messages. • At this stage, the program will not run correctly if there is an empty line in the input file. Change the program so that if an empty line is encountered, an exception is thrown and the empty line is ignored. This exception should be handled with the display of a suitable error message. • Before the e-mail address is added to the output file, check if the student number has 8 digits. If not, throw an InvalidFormatException (which the program should not handle itself)

0 Answers  

How to sort the elements in HashMap

3 Answers   Ness Technologies,

How does access modifiers work?

1 Answers   Wipro,

How are this() and super() used with constructors?

9 Answers  

How to print nodes of a Binary tree?

1 Answers   TCS,

What is light weight component?

3 Answers  

What is meant by controls and types?

1 Answers  

What Method and class used for Connection pooling ?

5 Answers   TCS, Wipro,

what is mean by method signature?

7 Answers   Satyam,

What are the uses of final, finally and finalize in java?

2 Answers   HCL, Agiline, FINO PayTech,