Hello
Servlet /JDBC experts,
I need some urgent help regarding ConnectionPool .
I have created connection pool of max 15 connections in init()method of servlet.
I am creating a connection object from the pool and passing that object to a class trhough its constructor .This class uses the connection object and fetches the data and returns the same trhu a
string object to the main servlet.
Problem here is that the connection used by another class is not getting released thru the'release connection' method of connectionpool trhu finally clause in the main servlet.Connections are stopped after 15 connections.
Can anyone help me for the saem.
public class servlet {
init(){connectionpool}
doget{
connection con=conpool.get....
someclass class=new someclass(con);
String r=class.str();
p.println(r)
}
finally(!con=null){conpool.releaseconnection)
}//doget over