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??????????????????
- 3 Answers
- 7394 Views
- ProgressSoft, I also Faced
- E-Mail Answers
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 |
How to run a servlet program?
What do you mean by a filter and how does it work?
What is difference between Forward() and sendRedirect() methode?
What is meant by session? Tell me something about httpsession class?
What is servlet and its life cycle?
What is war file?
Is dispatcher servlet a singleton?
Is it possible to call servlet with parameters in the URL?
What is the default http method in the servlet?
Explain Action Servlet?
What is MIME Type?
How can the referrer and the target urls be used in servlet?
Core Java 
