We are database independent. If you look at the initializeDbConnectionBroker method you will see we load all that information from the web.xml via servlet init parameters. Our code can use any database you have a driver for (granted it supports ANSI SQL)..
Jim > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf > Of Lev Assinovsky > Sent: Tuesday, March 05, 2002 1:42 PM > To: Tomcat Users List > Subject: Re: Who uses connection pool? > > > Jim, that's fine! > But how to provide the same through JNDI to be free of > particular DB? > > Jim Urban wrote: > > > 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]> > > -- > 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]>
