I'll edit the JDBC doc. I believe in config.xml it now does have this, but it didn't when 2.0a2 was built, and anyway it seems that 10 would be a better default than 2 ;-)
> -----Original Message----- > From: Sam Kirkpatrick [mailto:[EMAIL PROTECTED]] > Sent: 15 May 2002 21:43 > To: James Users List > Subject: Re: MySQL - No Connections Available > > > Thanks, Danny, it indeed worked like a dream. > > May I suggest this be added to the list of configuration options > in the "Use > Instructions" of the "Using JDBC" guide and/or the FAQ? I > searched all over > for a setting like this, but didn't find one documented anywhere. Also, I > suggest the default config.xml have this setting included, perhaps > commented out. > > Sam > > > ----- Original Message ----- > From: "Danny Angus" <[EMAIL PROTECTED]> > To: "James Users List" <[EMAIL PROTECTED]> > Sent: Wednesday, May 15, 2002 2:18 PM > Subject: RE: MySQL - No Connections Available > > > > Increase (or add) the "max" setting in your data-source, it works like a > > dream, I find 10-20 cures in most cases :-) > > > > <data-source name="maildb" > > > class="org.apache.james.util.mordred.JdbcDataSource"> > > <driver>org.gjt.mm.mysql.Driver</driver> > > <dburl>jdbc:mysql://192.168.0.1/mail</dburl> > > <user>u</user> > > <password>p</password> > > <max>20</max> > > </data-source> > > > > > > > Using James 2.0a3 on RH Linux 7.2 (JDK 1.4) with MySQL 3.23.49a: > > > > > > I am seeing a problem fairly frequently where I get > > > "SQLException: Giving up... no connections available." > > > > > > -- > > 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]>
