Hi Friends,
Suppose you have a web appliction which consists of 100
clients are connected with Connection pooling and they are
associated with 100 connection objcet and connected
with DB sever,Due some problem DB-Server suddenly crashed
and server came to down state for a while after few minutes
DB-server once again up,Now how will I manage my Pool
Management with my 100 clients...can any one tell
me??????????????????
Answers were Sorted based on User's Feedback
Answer / sathya
Dear Friend,
U r designing a web application,if it is crashing frequetly
means,User can loss their session,Maintain another host
machine if one server crashes the user can still access the
site.Use Load balancer server.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / sreenu bassha
When the server is up all the database interactions are
executing at the time of server down are not committed. As
the server is up and start working fine (no need to worry
about the connections) connections are maintained by the
server.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / amit arora
I believe if db server suddenly crashed, then all the
connections are lost.
Also, all the sessions are expired for each and every
client.
now, when db-server is again up.
As soon as first client request for any data. (if session
tracking) then It will creates new session and create first
connection.(or get the first connection from the connection
pool). Summary- Connection pool need to be reset from
begining, and this will grow up the conections as per your
original logic.
Is This Answer Correct ? | 0 Yes | 0 No |
What is servlet?
What do you mean by web applications?
Can we override servlet service method?
Why do we have servlet filters?
What are the key methods that are involved in processing of http servlets?
Name the servers that can be used to develope and deploy Servlets?
How does java thread pool work?
What are the exceptions thrown by servlets? Why?
What is the structure of the http response
How to read request headers from servlets?
How many ways are available to ger RequestDispatcher object?
Difference between get and post in java servlets?