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]>
