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 |
difference between forward and sendredirect
How to make sure a servlet is loaded at the application startup?
Which is better jsp or servlet?
What are the disadvantages of storing session state in cookies?
Tell us something about servletconfig interface.
Can we refresh servlet in client and server side automatically?
What is the ServletConfig() and what is its use?
What are the different session tracking techniques?
What is SingleThreadModel interface?
What's the use of servletcontext?
How to create war file?
Servlet is pure java object or not?