your description is quite mixed, or i am not able to get it properly.
your method A calls B (in method B you are creating a connection) after processing of B again you are creating a connection and sharing it with methdo C.
now question is why are you not sharing connection with B ???
create connection before calling method B and pass the connection in method B.
Then pass same connection to method C
and in finally block of A close one connection.
I can only guess that probably you are processing some resultset or anything else which is dependant of connection created in method B.
pasting actual code here will help [ March 15, 2005: Message edited by: Shailesh Chandra ]
Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
Joined: Apr 20, 2001
It's quite possible that method c() throws an exception and close the connection which may cause by many problems including db server is down or network has been dropped. You may need to handle this type of exception in mehod b().