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 pure servlet?
What is load-on-startup in servlet?
When is the servlet instance created in the life cycle of servlet? What is the importance of configuring a servlet?
Explain the architechure of a servlet?
How do I support both get and post from the same servlet?
What is new in ServletRequest interface ? (Servlet 2.4)
What is the type of method for sending request from http server?
What do you mean by servlet?
What is the workflow of a servlet?
What’s the use of the servlet wrapper classes??
What is servlet? Explain
Is servlet thread safe?