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

REST Methods

GET ============================================= HTTP GET method is used to **read** (or retrieve) a representation of a resource. According to the design of the HTTP specification, GET requests are used only to read data and not change it. Therefore, when used this way, they are considered safe. That is, they can be called without risk of data modification or corruption. Means calling it once has the same effect as calling it 10 times. Additionally, GET is idempotent which means that making multiple identical requests ends up having the same result as a single request. Donot expose unsafe operations via GET. It should never modify any resources on the server. Example: ------------    GET http://www.example.com/customers/12345/orders POST =================================== -> The POST verb is most-often utilized to **create** new resources. In particular, it's used to create subordinate resources. -> That is, subordinate to some other (e.g. parent) reso...
Post a Comment
Read more