If you have your Oracle jars in the common/lib I believe you have to restart tomcat to make sure everything gets released since they are shared across all apps.
Take a look at your Turbine log to make sure that you don't see any errors say that your DBConnection was finalized before being returned to the pool. When I started with turbine I noticed a few of them. Didn't realize I needed to release the connection. Newbie thing for me. The OM is the object model created by the TDK or Torque. Depending on what your using. -----Original Message----- From: Bob Swerdlow [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 12:53 PM To: Turbine Users List Subject: Re: DB Pooling and Processes Yes, we are using Tomcat and it did seem to let go of the processes when I restarted it. However, we are running more than one project under Tomcat, not all of which access the same database, so it is unfortunate to have to stop them all if we need to fix one. I've checked the code to ensure that the connections are being returned and actually added logging so I can see that when they are created and released. That all looks fine. Pardon my denseness - what's the OM? ----- Original Message ----- From: "Phee, Martin J (Jump Tech)" <[EMAIL PROTECTED]> To: "'Turbine Users List'" <[EMAIL PROTECTED]> Sent: Wednesday, March 13, 2002 1:39 PM Subject: RE: DB Pooling and Processes > Are you using Tomcat? You might need to restart it also. Also, make sure > you release your connections back to turbine, and close any statements you > are using. Are you using the OM? > > -----Original Message----- > From: Bob Swerdlow [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, March 13, 2002 12:30 PM > To: Turbine Users List > Subject: Re: DB Pooling and Processes > > > Thanks, Ian. I'll get the number of processes and connections into line. > > Any idea how can I get rid of all the old connections when I reload the > project? > > Thanks, > Bob > > ----- Original Message ----- > From: "Ian Huynh" <[EMAIL PROTECTED]> > To: "Turbine Users List" <[EMAIL PROTECTED]> > Sent: Wednesday, March 13, 2002 1:12 PM > Subject: RE: DB Pooling and Processes > > > > Bob > > I believe Oracle uses 1 process for each connection by default unless > > you've set up Oracle to use the MTS dispatcher. > > > > And also by default 50 is the default max process for Oracle. > > You can control this file by editing your INIT*.ORA file typically found > > in %ORACLE_HOME%\<YourSID>\pfile\init*.ora and look for the > > entry > > > > PROCESSES=100 > > > > BTW, you also need to restart your Oracle server to pick up the new value. > > > > Since connections are pooled (Don't know much about Turbine Pooling) but > > in theory, if you app uses connection wisely, you shouldn't need too many > 'physical' > > connections. BUt that entirely depends on your concurrent load and length > > of time a connection is used by a thread in your app. You need to load > test your > > app to find the right number. > > > > Also beware that Oracle also limits 300 open cursors by default. This > > is another area where most people also run into trouble. You can > > change this param in your init*.ora file as well. If you need a large > > number of connections, chances are you probl. will run into this limit as > well. > > > > open_cursors = 300 > > > > > > > > > > -----Original Message----- > > From: Bob Swerdlow [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, March 13, 2002 10:06 AM > > To: [EMAIL PROTECTED] > > Subject: DB Pooling and Processes > > > > > > Hi, y'all - > > > > Is there documentation somewhere about how to set up Oracle with Turbine > DB > > Pooling? > > > > We ran into a problem recently where we were getting "cannot get > connection" > > errors. I found that our TurbineProperties.Resources had: > > > > # The number of database connections to cache per ConnectionPool > > # instance (specified per database). > > database.default.maxConnections=3 > > > > Since the failure happend when our code was setting up 4 connections, I > knew > > I had to change this. After a bit of web-snooping, I changed it to 100. > > > > Now we are getting this error: > > ORA-00020: maximum number of processes (50) exceeded > > > > This actually happened after reloading the project a few times. > > > > So my questions are: > > 1. What is an appropriate value for database.default.maxConnections? > This > > will be a public web site with many concurrent users retrieving pages that > > will access the database > > 2. Do I need to coordinate the number of connections with the number of > > Oracle processes? How do I control this in Oracle? > > 3. Should reloading the project release all of the connections? It does > > not seem to have done so, however, when I restarted Tomcat, those > processes > > seemed to go away. > > 4. What else should I worry about? > > > > Thanks for your help! > > > > Bob Swerdlow > > Chief Operating Officer > > Transpose, LLC > > [EMAIL PROTECTED] > > > > > > > > > > > > > > -- > > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > > > > > > -- > > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > > > > > -- > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
