Hi: You can put it in tomcat use " System.getProperties().put(key,value); System.getProperties().getProperty(key); " Here is my solution. I create the connections in constructor "ConnectionPool()". I new the ConnectionPool instance in where I need to use it. " ConnectionPool dbPool = new ConnectionPool(); Connection c = dbPool.getConnection(); "
Jacob FanChiang >From Taiwan Assoiciate Researcher Customer Care and Billing System Dept. Telecommunication Laboratories Chunghwa Telecom Co., Ltd. Tel: +886 2 3707 1098 Fax +886 2 2325 5844 Email: [EMAIL PROTECTED] ----- Original Message ----- From: "Pablo Morillas" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 03, 2001 6:07 AM Subject: Pool connection to database > Hello all. > > I have a problem that I suppose is resolved by Tomcat. I'm using Tomcat 3.2 > and I can connect to an Oracle 8i database. The problem is that a process is > created by oracle in any connection to the database done from mines > servlets. I want to use a pool of connection for limit the number of > connection actives. > Is there any way to specify a class that run when I start tomcat? If I have > any pool connection running inside tomcat I think that I will get the pool, > won't I? > > Thanks to all in advance. > > ================================== > Pablo Morillas > http://www.sortes.com > [EMAIL PROTECTED] > ================================== >
