wat happen when the connection is nt closed in jdbc
n what vl happen when i interchange in executequery n
execute statements

Answers were Sorted based on User's Feedback



wat happen when the connection is nt closed in jdbc n what vl happen when i interchange in executeq..

Answer / sitaram

when con.close() is executed the memory deallocated in the
server. if we don't use con.close(),connection will be
increased in the server. suppose the connections size are
reached to max connection, nobody access the database in the
site. This is performance issue.

Is This Answer Correct ?    4 Yes 0 No

wat happen when the connection is nt closed in jdbc n what vl happen when i interchange in executeq..

Answer / prasanthi reddy

when con.close() is executed the memory allocated for the
connection in the server is deallocated,and the connection
with the client will be terminated.
if we dont use con.close() even if our requirement is
completed,the connection will be remain in the server it is
the more burden to the server,it will kills the performance

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Struts Interview Questions

What is the purpose of @emailvalidator?

0 Answers  


What is the purpose of @result annotation?

0 Answers  


how canu done chechin and check out of u r project using with sample examples?

8 Answers   CTS, Logica CMG,


What happens when Two users requests for same action class? How the threads are controlled?

4 Answers  


How is declarative handling of exceptions done in struts ?

0 Answers  






What is validate() and reset() functions?

0 Answers  


What’s the utilization of struts.xml configuration file?

0 Answers  


What is strut action mapping?

0 Answers  


What is the differences between struts1 and struts2?

0 Answers  


Which tag is used to declare constants in struts xml?

0 Answers  


What is the purpose of form-be tag in struct-config.xml?

0 Answers  


What are the life cycle methods of interceptor?

0 Answers  


Categories