Here are some code fragments from our servlet (we use a single dispatcher servlet):
public void init(ServletConfig iConfig) throws ServletException { super.init(iConfig); ... initializeDbConnectionBroker(iConfig); ... } private void initializeDbConnectionBroker(ServletConfig iConfig) { String dbDriver = getInitParameter("DB_DRIVER"); String dbName = getInitParameter("DB_NAME"); String dbUser = getInitParameter("DB_USER"); String dbPassword = getInitParameter("DB_PSWD"); String logfile = getInitParameter("DB_LOG_FILE"); int initConn = new Integer(getInitParameter("DB_INITCONN")).intValue(); int maxConn = new Integer(getInitParameter(DB_"MAXCONN")).intValue(); int connTimeOut = new Integer(getInitParameter("DB_CONNTIMEOUT")).intValue(); double maxConnTime = new Double(getInitParameter("DB_MAXCONNTIME")).doubleValue(); try { logMessage("Initializing DB connection pool."); ConnectionPool.initialize(dbDriver, dbName, dbUser, dbPassword, logfile, initConn, maxConn, connTimeOut , maxConnTime); logMessage("DB connection pool initialized."); } catch (Exception e) { logException(e, this); logMessage("ConnectionPool.init error: " + e.toString()); } } public class ConnectionPool extends Object { private static DbConnectionBroker myBroker = null; private static int connTimeOut = 0; public static void initialize(String DBDriver, String DBName, String DBUser, String DBPsWd, String Logfile, int initConn, int maxConn, int iConnTimeOut, double maxConnTime) throws IOException { if (DBDriver != null && DBDriver.length() > 0) { myBroker = new DbConnectionBroker(DBDriver, DBName, DBUser, DBPsWd, initConn, maxConn, Logfile, maxConnTime); connTimeOut = iConnTimeOut; } } public static synchronized DbConnectionBroker getBroker() { return myBroker; } public static synchronized void shutDown() { try { myBroker.destroy(connTimeOut); } catch(SQLException e){} } } Jim > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf > Of Lev Assinovsky > Sent: Tuesday, March 05, 2002 9:10 AM > To: Tomcat Users List > Subject: Re: Who uses connection pool? > > > Good! I just found out that ConnectionPoolDataSource is not properly > implemented in tyrex stuff (Tyrex people acknowledged that). > Did you hardcode pool instance creation or found a way when JNDI do that? > > Jim Urban wrote: > > > DBConnectionBroker > http://opensource.devdaily.com/ddConnectionBroker.shtml > > > > > -----Original Message----- > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf > > > Of Lev Assinovsky > > > Sent: Tuesday, March 05, 2002 7:47 AM > > > To: Tomcat Users List > > > Subject: Re: Who uses connection pool? > > > > > > > > > Which one? > > > Jim Urban wrote: > > > > > > > We do. > > > > > > > > Jim Urban > > > > Product Manager > > > > Netsteps Inc. > > > > Suite 505E > > > > 1 Pierce Pl. > > > > Itasca, IL 60143 > > > > Voice: (630) 250-3045 x2164 > > > > Fax: (630) 250-3046 > > > > > > > > > -----Original Message----- > > > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf > > > > > Of Lev Assinovsky > > > > > Sent: Tuesday, March 05, 2002 3:09 AM > > > > > To: 'Tomcat Users List' > > > > > Subject: Who uses connection pool? > > > > > > > > > > > > > > > Hi! > > > > > Could you tell me please, > > > > > does anybody successfully use database connection pool? > > > > > > > > > > > > > > > -- > > > > > Lev Assinovsky Peterlink Web > > > > > Programmer St. Petersburg, Russia > > > > > Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Á > > > > > E-mail: [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > To unsubscribe: > <mailto:[EMAIL PROTECTED]> > > > > > For additional commands: > <mailto:[EMAIL PROTECTED]> > > > > > Troubles with the list: > <mailto:[EMAIL PROTECTED]> > > > > > > > > > > > > > > > > > > -- > > > > To unsubscribe: > <mailto:[EMAIL PROTECTED]> > > > > For additional commands: > <mailto:[EMAIL PROTECTED]> > > > > Troubles with the list: > <mailto:[EMAIL PROTECTED]> > > > > > > -- > > > Lev Assinovsky Peterlink Web > > > Programmer St. Petersburg, Russia > > > Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Á > > > E-mail: [EMAIL PROTECTED] > > > > > > > > > > > > > > > -- > > > To unsubscribe: <mailto:[EMAIL PROTECTED]> > > > For additional commands: <mailto:[EMAIL PROTECTED]> > > > Troubles with the list: <mailto:[EMAIL PROTECTED]> > > > > > > > > > > -- > > To unsubscribe: <mailto:[EMAIL PROTECTED]> > > For additional commands: <mailto:[EMAIL PROTECTED]> > > Troubles with the list: <mailto:[EMAIL PROTECTED]> > > -- > Lev Assinovsky Peterlink Web > Programmer St. Petersburg, Russia > Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Á > E-mail: [EMAIL PROTECTED] > > > > > -- > To unsubscribe: <mailto:[EMAIL PROTECTED]> > For additional commands: <mailto:[EMAIL PROTECTED]> > Troubles with the list: <mailto:[EMAIL PROTECTED]> > > -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>