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
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.