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]
