Connection pooling

[Cherry Mathew]

Hi,
I ned to do a database connection pooling in my project.
i need to develop the project for web environment and also as an application.
my first questuion is if i use a connection pool where will i get the connection in a sevlet in the init() method or the servic() method.
is it advicable to have it in the service method?
Will i get ready code for connection pooling and from where?
What are the issues i need to take care when developing the connection pool
Cherry

[Frank Lin]

You should put it in the service() method in order to effectively use connection pool.
Check the servlet forum on Javaranch, you would find more info there.

[Karthik Guru]

you can probably check this out..sample connection pool code. http://www.webdevelopersjournal.com/columns/connection_pool.html
I w'd probably put it in the init() method.
I don't know why it s'd be initialised in the service().
init() w'd be called when u load the servlet through the web server. So i guess all initialisation can go there?
cheers,
karthik.