> -----Oorspronkelijk bericht----- > Van: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Namens Michiel Meeuwissen > Verzonden: maandag 28 juni 2004 16:49 > Aan: [EMAIL PROTECTED] > Onderwerp: Re: Connection pools vs. server.xml host entries > > Ronald Wildenberg <[EMAIL PROTECTED]> wrote: > > I have just discovered a quite disturbing MMBase connection > > pooling issue/bug. > > > > We run MMBase 1.7 inside Tomcat 4.1.24. The server.xml file > > contains six <host .../> entries, all pointing to the same > > appBase (which contains an MMBase application). This MMBase > > app is configured to open at most 20 database connections. > > > > However, for each <host .../> entry, 20 database connections > > are opened! For our six <host .../> entries, this results in > > 120 database connections. When we remove an entry, 20 less > > database connections are opened. > > > > Could someone please shed some light on this issue? > > If you find 20 connection per mmbase instance too much, I > suggest you set it lower. > > MMBase instances do not share there connection pools. You > also might give the app-server's connection pooling a try in stead. >
Indeed it turned out not to be an MMBase issue, but a Tomcat feature I did not know about. For each virtual host in server.xml, a new application instance is created, each in its own classloader. So 6 virtual hosts lead to six MMBase instances even if they represent the exact same web app. These six instances each have their own connection pool. Regards, Ronald. -----------------------Disclaimer------------------------- Dit bericht (met bijlagen) is met grote zorgvuldigheid samengesteld. Voor mogelijke onjuistheid en/of onvolledigheid van de hierin verstrekte informatie kan Kennisnet geen aansprakelijkheid aanvaarden, evenmin kunnen aan de inhoud van dit bericht (met bijlagen) rechten worden ontleend. De inhoud van dit bericht (met bijlagen) kan vertrouwelijke informatie bevatten en is uitsluitend bestemd voor de geadresseerde van dit bericht. Indien u niet de beoogde ontvanger van dit bericht bent, verzoekt Kennisnet u dit bericht te verwijderen, eventuele bijlagen niet te openen en wijst Kennisnet u op de onrechtmatigheid van het gebruiken, kopi�ren of verspreiden van de inhoud van dit bericht (met bijlagen). This message (with attachments) is given in good faith. Kennisnet cannot assume any responsibility for the accuracy or reliability of the information contained in this message (with attachments), nor shall the information be construed as constituting any obligation on the part of Kennisnet. The information contained in this message (with attachments) may be confidential or privileged and is only intended for the use of the named addressee. If you are not the intended recipient, you are requested by Kennisnet to delete this message (with attachments) without opening it and you are notified by Kennisnet that any disclosure, copying or distribution of the information contained in this message (with attachments) is strictly prohibited and unlawful. ----------------------------------------------------------
