> On Dec 30, 2021, at 4:33 PM, Eric Robinson <eric.robin...@psmnv.com> wrote: > > Hi Rob, > >>> On Dec 30, 2021, at 4:03 PM, Eric Robinson <eric.robin...@psmnv.com> >> wrote: >>> >>> Chris, >>> >>> If I want to ignore the vendor's recommendation and try connection >> pooling anyway, is that something I can enable with a config file setting, >> or do >> they actually have to trigger it from within their code? >>> >>
>> Up thread, didn’t you say tomcat was the client? Are servlets in tomcat >> making db requests? What database system is under this? >>> > > Yes, tomcat is the client and the database is MySQL. There are, in fact, many > tomcat instances on the same server, each connecting to its own dedicated > MySQL database located in a farm of MySQL servers. > And then each tomcat instance has a single <Resource/> identifying the db server? It could be possible to redirect that Resource to a Connector/J fronting MySQL. It would not be perfectly seamless but could be pretty quick, per tomcat instance. >>>> -----Original Message----- >>>> From: Eric Robinson <eric.robin...@psmnv.com >>>> <mailto:eric.robin...@psmnv.com>> >>>> Sent: Thursday, December 30, 2021 12:00 PM >>>> To: Tomcat Users List <users@tomcat.apache.org >>>> <mailto:users@tomcat.apache.org>> >>>> Subject: RE: Do I Need Network NameSpaces to Solve This >>>> Tomcat+Connector/J Problem? >>>> >>>> Chris, >>>> >>>>> Not pooling connections will very likely negatively affect performance. >>>>> >>>>> When you say "they ... have an issue with connection pooling" do you >>>>> mean that they have a technical problem, or do you mean that there >>>>> is some ill- conceived policy against them? >>>>> >>>>> Oh, maybe they are paranoid about cross-client leakage between >>>>> connections. Well, if the application can't be trusted not to leak >>>>> that kind of info, then it can't be trusted to make the connections >>>>> properly in the first place. >>>>> >>>>> -chris >>>>> >>>> >>>> Hard to say what their issue is. We've asked about implementing it >>>> before, but they don't support it. You know how software companies >>>> are. Maybe they had a technical problem with it years ago and have just >> not revisited it. >>>> They're stuck in a rut and there is too much inertia to get them out of it. >>>> >>>> --Eric >>>> >>>> >>>> >>>> >>>> Disclaimer : This email and any files transmitted with it are >>>> confidential and intended solely for intended recipients. If you are >>>> not the named addressee you should not disseminate, distribute, copy >>>> or alter this email. Any views or opinions presented in this email >>>> are solely those of the author and might not represent those of >>>> Physician Select Management. Warning: Although Physician Select >>>> Management has taken reasonable precautions to ensure no viruses are >>>> present in this email, the company cannot accept responsibility for any >> loss or damage arising from the use of this email or attachments. >>> Disclaimer : This email and any files transmitted with it are confidential >>> and >> intended solely for intended recipients. If you are not the named addressee >> you should not disseminate, distribute, copy or alter this email. Any views >> or >> opinions presented in this email are solely those of the author and might not >> represent those of Physician Select Management. Warning: Although >> Physician Select Management has taken reasonable precautions to ensure >> no viruses are present in this email, the company cannot accept >> responsibility >> for any loss or damage arising from the use of this email or attachments. >>> >>> --------------------------------------------------------------------- >>> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org >>> <mailto:users-unsubscr...@tomcat.apache.org> >>> For additional commands, e-mail: users-h...@tomcat.apache.org >>> <mailto:users-h...@tomcat.apache.org> > Disclaimer : This email and any files transmitted with it are confidential > and intended solely for intended recipients. If you are not the named > addressee you should not disseminate, distribute, copy or alter this email. > Any views or opinions presented in this email are solely those of the author > and might not represent those of Physician Select Management. Warning: > Although Physician Select Management has taken reasonable precautions to > ensure no viruses are present in this email, the company cannot accept > responsibility for any loss or damage arising from the use of this email or > attachments. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > <mailto:users-unsubscr...@tomcat.apache.org> > For additional commands, e-mail: users-h...@tomcat.apache.org > <mailto:users-h...@tomcat.apache.org>