Re: DbConnectionPool over multiple servlets

Ernie V Sat, 19 Feb 2000 16:40:05 -0800

You need to create a servlet that does nothing but create the connection pool then add the servlet to the servlet context. In that servlet, lets call it ConnPoolServlet, provide at least two methods, getConnection() and close().

You can add the servlet to the servlet context from the ConnPoolServlet init() method as follows:

public void init(ServletConfig cfg) throws ServletException
{
super.init(cfg);

// Create our connection pool
_connPool = new ConnPoolServlet();

// Initialize the connection pool.
try {
   _connPool.initialize();
} catch (Exception ex) {
   ex.printStackTrace();
   throw new ServletException ("Unable to initialize connection pool");
}
// Add this servlet to the context
getServletContext().setAttribute("connpool", this);
}

You can then obtain a connection from another servlet by getting a reference to the ConnPoolServlet from the servlet context using the key "connpool" like this:

ConnPoolServlet servlet = (ConnPoolServlet)getServletContext().getAttribute("connpool");

-ernie

Stuart Norton wrote:

Hi,
This is my first post on the list, so I've finally come out of the woodwork!
I'm using the com.javaexchange.dbConnectionPool class (from
www.javaexchange.com) to access a database through an ODBC driver. This
works with one servlet, where I define a new instance of the class in the
init() of my servlet, but I'm confused about what happens when I use another
servlet that needs to talk to the same DbConnectionPool class.
The init() code in my second class contains the same code as the first (ie.
myBroker = new DbConnectionPool(...blah, blah..);), so I'm wondering whether
it's talking to the other instance from the first servlet, or making a new
instance.
Can anyone please help me.
Stuart Norton,
Densitron Technologies plc, UK
e: [EMAIL PROTECTED]
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html

begin:vcard
n:Varitimos;Ernie
tel;cell:781-929-3856
tel;home:781-784-1997
tel;work:781-784-3900
x-mozilla-html:TRUE
url:http://www.skyserver.com
org:Skyserver Consulting, Inc.
adr:;;144 Upland Rd;Sharon;MA;02067;
version:2.1
email;internet:[EMAIL PROTECTED]
title:President
fn:Ernie Varitimos
end:vcard

Re: DbConnectionPool over multiple servlets

Reply via email to