Hello Any body can tell me i am doing a connection pooling programe in websphere 3.0.2 and back end is DB2 as400
when i was writting a program i forgot close the connection context.close in my programe do i need to close alway this context. Because my connection pooling programe is faiiling , i could not able to find the reason. i think it may one reason. can any body tell me do i need to close it(context.close()) I would appricate any bodys help Thank YOu Babu
Kyle Brown
author
Ranch Hand
Joined: Aug 10, 2001
Posts: 3878
posted
0
If you mean close each Connection the answer is YES. Closing a connection returns it to the connection pool in the datasource. Otherwise, it will remain "used" until the reaper thread recovers it (the default timeout here is 30 minutes -- see the Websphere admin documentation on DataSource setup). If you mean InitialContexts or Datasources, no you do not close them. Kyle ------------------ Kyle Brown, Author of Enterprise Java (tm) Programming with IBM Websphere See my homepage at http://members.aol.com/kgb1001001 for other WebSphere information.