Skip to main content

How many way we can get database connection and which one is best approaches and why ??

How many way we can get database connection and which one is best approaches and why ??
Basiacally there r two way to get:- connection from DB .
👉1.DriverManager
👉2.DataSource 
but in real time 2nd one is preferable.coz in case of DriverManager we have to remember all the connection property to get connection from Db.nd it is also not reusablity nature. Suppose u create one connection obj then u can perform one time operation any other class can't reuse that connection again. .
so to over come it we use DataSource(I) to get connection .from DataBase.in nd case by using this DataResource
we achive connection pool concept.in this case we need not to set connection properties and we no need to take headach for creating object to get connection
that work is done/set by ADMIN in DataSource Implementation class object nd these property r bind with
JNDI(java naming directory interface) registry. we just lookup from registry to get that object nd make connection with DB.... ..
🌍.This whole concept is designed based on ServiceLocator Design Pattern
so it is most prefereble....

Comments

Post a Comment

Popular posts from this blog

Mockito interview Questions

1.       Question 1. What Is Mockito? Answer : Mockito allows creation of mock object for the purpose of Test Driven Development and Behavior Driven development. Unlike creating actual object, Mockito allows creation of fake object (external dependencies) which allows it to give consistent results to a given invocation. 2.       Question 2. Why Do We Need Mockito? What Are The Advantages? Answer : Mockito differentiates itself from the other testing framework by removing the expectation beforehand. So, by doing this, it reduces the coupling. Most of the testing framework works on the "expect-run-verify". Mockito allows it to make it "run-verify" framework. Mockito also provides annotation which allows to reduce the boilerplate code. 3.       Question 3. Can You Explain A Mockito Framework? Answer : In Mockito, you always check a particular class. The dependency in that class is injected using m...
2 comments
Read more

JAVA Expert Interview Questions Answers 2017

Java Basics ::  Interview Questions and Answers Home  »  Interview Questions  »  Technical Interview  »  Java Basics  » Interview Questions 1.     What is the difference between a constructor and a method? A constructor is a member function of a class that is used to create objects of that class. It has the same name as the class itself, has no return type, and is invoked using the new operator. A method is an ordinary member function of a class. It has its own name, a return type (which may be void), and is invoked using the dot operator. 2.     What is the purpose of garbage collection in Java, and when is it used? The purpose of garbage collection is to identify and discard objects that are no longer needed by a program so that their resources can be reclaimed and reused. A Java object is subject to garbage collection when it becomes unreachable to the program in which it is used. 3.  ...
3 comments
Read more

JAVA A to Z Interview Questions Answers4

DBMS Interview Questions A list of top frequently asked  DBMS interview questions  and answers are given below. 1) What is DBMS? DBMS is a collection of programs that facilitates users to create and maintain a database. 2) What is a database? Database is a logical, consistent and organized collection of data that it can easily be accessed, managed and updated. For more information:  Click here 3) What is a database system? The collection of database and DBMS software together is known as database system. 4) What are the advantages of DBMS? Redundancy control Restriction for unauthorized access Provides multiple user interfaces Provides backup and recovery Enforces integrity constraints For more information:  Click here 5) What is checkpoint in DBMS? A Checkpoint is like a snapshot of the DBMS state. 6) When does checkpoint occur in DBMS? By taking checkpoints, the DBMS can reduce the amount of work to...
Post a Comment
Read more