Hi, I just had an idea: it could be this is not your application's fault. We've had these in the past where the DB ran out of processes, for example if several apps or people were using it at once. Ask your DB for a breakdown of where the 200 processes are coming from.
Yoav Shapira Millennium Research Informatics >-----Original Message----- >From: Shilpa Nalgonda [mailto:[EMAIL PROTECTED] >Sent: Tuesday, September 28, 2004 3:04 PM >To: Tomcat Users List >Subject: RE: Tomcat 4.1 Connection Pooling... > >how can i check that and how to resolve it... > >-----Original Message----- >From: Dale, Matt [mailto:[EMAIL PROTECTED] >Sent: Tuesday, September 28, 2004 3:06 PM >To: Tomcat Users List >Subject: RE: Tomcat 4.1 Connection Pooling... > > > >Perhaps your application is hanging on to the database connections and not >returning them to the pool? > >-----Original Message----- >From: Shilpa Nalgonda [mailto:[EMAIL PROTECTED] >Sent: 28 September 2004 19:43 >To: Tomcat Users List; Peter Lin >Subject: RE: Tomcat 4.1 Connection Pooling... > > >I have updated with classes12.jar, but still i have this problem. But >Peter >what ii sthe bug that you >mentioned, i have the problem of >java.sql.SQLException: ORA-00020: maximum number of processes (200) >exceeded > > > >-----Original Message----- >From: Peter Lin [mailto:[EMAIL PROTECTED] >Sent: Tuesday, September 28, 2004 2:23 PM >To: Tomcat Users List >Subject: Re: Tomcat 4.1 Connection Pooling... > > >Yoav is correct, you should be using the newer driver and not the >older one. good thing I asked which version the driver is. > >that's a really old bug in the old driver. I remember reporting the >bug back in 99 and the support rep said something like, "yeah, lots of >people have been reporting the bug." > >peter > > > >On Tue, 28 Sep 2004 14:16:43 -0400, Shapira, Yoav <[EMAIL PROTECTED]> >wrote: >> >> Hi, >> You're wrong. You can and should use classes12.zip (renamed to >> classes12.jar) with Oracle 8i. You can even use the modern ojdbc14.jar >> drivers. >> >> Yoav Shapira >> Millennium Research Informatics >> >> >> >> >> >-----Original Message----- >> >From: Shilpa Nalgonda [mailto:[EMAIL PROTECTED] >> >Sent: Tuesday, September 28, 2004 2:09 PM >> >To: Tomcat Users List; Peter Lin >> >Subject: RE: Tomcat 4.1 Connection Pooling... >> > >> >I am using Oracle 8i, and Oracle drivers i use is Oracle111.jar, and >> use >> >DBCp for connection Pooling with Tomcat4.1, >> >i thought classes112 is for 9i...correct me if i am wrong... >> > >> >-----Original Message----- >> >From: Peter Lin [mailto:[EMAIL PROTECTED] >> >Sent: Tuesday, September 28, 2004 2:01 PM >> >To: Tomcat Users List >> >Subject: Re: Tomcat 4.1 Connection Pooling... >> > >> > >> >I thought Oracle fixed that bug in their connectionPooling driver back >> >in 2001. Am I missing something? Are you using some other driver to >> >create a pool of jdbc connections to Oracle? sorry for the question if >> >it's already been answered in earlier messages. >> > >> >I've used classes112.zip jdbc driver from oracle without any problems >> >with connection pooling. If you're using classes111.zip driver from >> >oracle, you should update your driver to the latest. >> > >> >just in case no one else mentioned it. >> > >> >peter >> > >> > >> >On Tue, 28 Sep 2004 13:55:18 -0400, Shapira, Yoav >> <[EMAIL PROTECTED]> >> >wrote: >> >> >> >> Hi, >> >> Hmm ;) There's a good reason there's no close method on >> >> javax.sql.DataSource. There's also a good reason the J2EE spec calls >> >> for the container, not the user, to manage the lifecycle of JNDI >> >> resources such as DataSources. IF you go with this >> >> ServletContextListener approach to take over lifecycle management of >> a >> >> server-provided JNDI resource, you'll be in a murky space at best. >> >> >> >> Yoav Shapira >> >> Millennium Research Informatics >> >> >> >> >-----Original Message----- >> >> >From: Phillip Qin [mailto:[EMAIL PROTECTED] >> >> >Sent: Tuesday, September 28, 2004 1:27 PM >> >> >To: 'Tomcat Users List' >> >> >Subject: RE: Tomcat 4.1 Connection Pooling... >> >> > >> >> >For connecion pooling, when you close the connection, you don't >> >> actually >> >> >close the physical link. After several shutdown/sartup of your >> >> application, >> >> >open connection accumulates and exceeds Oracle's 200 thus you >> receive >> >> that >> >> >SQLException. >> >> > >> >> >To solve your problem, I would implement a ServletContextListener to >> >> >initialize connection pool when my context is in the initialization >> >> (public >> >> >method contextInitialized) and close data source when my context is >> >> >destroyed (public method contextDestroyed). >> >> > >> >> >If you have defined loadonstartup servlet in your web.xml, in the >> >> destroy >> >> >method, explicitly close your data source. >> >> > >> >> >> > >> >--------------------------------------------------------------------- >> >To unsubscribe, e-mail: [EMAIL PROTECTED] >> >For additional commands, e-mail: [EMAIL PROTECTED] >> > >> > >> >--------------------------------------------------------------------- >> >To unsubscribe, e-mail: [EMAIL PROTECTED] >> >For additional commands, e-mail: [EMAIL PROTECTED] >> >> >> This e-mail, including any attachments, is a confidential business >communication, and may contain information that is confidential, >proprietary >and/or privileged. This e-mail is intended only for the individual(s) to >whom it is addressed, and may not be saved, copied, printed, disclosed or >used by anyone else. If you are not the(an) intended recipient, please >immediately delete this e-mail from your computer system and notify the >sender. Thank you. >> >> >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> >> > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] > > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] > > > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
