On Wed, 19 Jan 2005 16:43:25 +0530, Kalluru Uma. Maheswar <[EMAIL PROTECTED]> wrote: > Hi, > I am looking for an example using org.apache.commons.dbcp.BasicDataSource and > more over, I cant use a .war file to deploy my app (there are some problems)
If I understand you right, you need to set up your connection pool manually. In such case you should instantiate it once when your web appcation starts (probably in your servlet's init method or using a Struts Plugin) and then place it into the application scope (servletContext.setAttribute() method). Then whenever you need to talk to database, you can simply get your db pool using something like DataSource ds = (DataSource) servletContext.getAttribute (DATASOURCE_KEY) Pavel --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]