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 |
can we use more than one controller in web application
When servlet object is created?
Explain the methods in Generic and HTTP Servlets?
What is a servlet-to-servlet communcation?
What is the difference between doGet and doPost?
When a client request is sent to the servlet container, how does the container choose which servlet to invoke?
How to notify an object in session when session is invalidated or timed-out?
what is the difference between ServletContext and ServletConfig
What is cookies in servlet with example?
Why don't we write a constructor in a servlet?
Can we refresh servlet in client and server side automatically?
Explain servlet events?