cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Stephen Ng" <stephen...@verizon.net>
Subject RE: Datasource pooling issue. Connections exceed limit.
Date Thu, 20 Jun 2002 18:52:08 GMT
Aaron,

I have an app that does quite a bit of data access and haven't noticed
this at all.  BTW, are you using SQLTransformer or esql to get the data?

Steve

> -----Original Message-----
> From: SANSONE, AARON M [AG-Contractor/1000] 
> [mailto:aaron.m.sansone@monsanto.com] 
> Sent: Wednesday, June 19, 2002 10:11 AM
> To: 'cocoon-users@xml.apache.org'
> Subject: RE: Datasource pooling issue. Connections exceed limit.
> 
> 
> Tom,
> 
> Thanks for your response but this is being done within the 
> Cocoon framework.
> I do not have any Java code running in Cocoon that opens a 
> connection to the
> database.  The Cocoon framework is repsonsible for handling 
> connections for
> me and yet I am still seeing the issue with many connections 
> being created
> in excess of the specified datasource pooling parameters set in the
> cocoon.xconf.
> 
> Any other ideas?
> 
> -Aaron
> 
> > -----Original Message-----
> > From: Tom Klaasen [mailto:tom.klaasen@pandora.be]
> > Sent: Tuesday, June 18, 2002 8:06 AM
> > To: cocoon-users@xml.apache.org
> > Subject: Re: Datasource pooling issue. Connections exceed limit.
> > 
> > 
> > SANSONE, AARON M [AG-Contractor/1000] wrote:
> > > We are using a build of Cocoon from early March.  We 
> > connect to an Oracle
> > > database and have specified the connection pooling to use a 
> > minimum of 5
> > > connections and a max of 10 connections.  What we are 
> > seeing, is that our
> > > number of connections to Oracle grows with each new 
> > connection from Cocoon
> > > to our database way past 10 (we currently are looking at 55 
> > connections). 
> > > 
> > > Has anyone experienced this issue in either older versions 
> > or the current
> > > build?  Is this a known issue that has been resolved?  I 
> > have been unable to
> > > find any information in the archives on this issue.
> > 
> > Don't forget to close the connection in your code: 
> conn.close(). This 
> > will not actually close the connection, but give it back to 
> the pool.
> > 
> > At least, that's the way it was way back in September.
> > 
> > 
> > 
> > -- 
> > tomK
> > 
> > 
> > This is a test of the emergency signature system.  Were 
> this an actual
> > signature, you would see amusing mottos, disclaimers, a zillion net
> > addresses, or edifying philisophical statements.  This is 
> only a test.
> > 
> > 
> > 
> ---------------------------------------------------------------------
> > Please check that your question  has not already been 
> answered in the
> > FAQ before posting.     
> <http://xml.apache.org/cocoon/faq/index.html> >
> > 
> > To 
> unsubscribe, e-mail:     
> <cocoon-users-unsubscribe@xml.apache.org>
> > For additional commands, e-mail:   
> <cocoon-users-help@xml.apache.org>
> > 
> 
> ---------------------------------------------------------------------
> Please check that your question  has not already been answered in the
> FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>
> 
> To unsubscribe, e-mail:     <cocoon-users-unsubscribe@xml.apache.org>
> For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>
> 
> 


---------------------------------------------------------------------
Please check that your question  has not already been answered in the
FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>

To unsubscribe, e-mail:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>


Mime
View raw message