I see that constructing ERXObjectStoreCoordinator(true) is another way to work around the issue of closing the db connection. However, I still get two connections created and only one closed when disposed. John
On 13 Mar 2014, at 14:33, John Pollard <[email protected]> wrote: > Thanks Aaron, half way there, that closed one of the two connections, but > neither of mine were closing so still one left open after the following code? > John > > On 13 Mar 2014, at 13:04, Aaron Rosenzweig <[email protected]> wrote: > >> Hi John, >> >> Yes, that’s a known Apple bug. It creates an extra one to read “Database >> info” and then never releases it. There is a Wonder method to close database >> connections like that. >> >> ec.dispose(); >> ERXEOAccessUtilities.closeDatabaseConnections(objectStore); >> objectStore.dispose(); >> >> Cheers, >> AARON ROSENZWEIG / Chat 'n Bike >> e: [email protected] t: (301) 956-2319 >> >> >> On Mar 13, 2014, at 8:40 AM, John Pollard <[email protected]> wrote: >> >>> Hi List, >>> >>> I have noticed that the database connections (seen using "show processlist" >>> within mysql) are not being released. >>> I create my own ERXObjectStoreCoordinator and this results in two new mysql >>> connections appearing. >>> When later I call dispose() on that ERXObjectStoreCoordinator, the database >>> connections are not being freed up. >>> The dispose() call is in a Session.terminate() method, called after >>> super.terminate(). >>> >>> Thanks for any thoughts on this. >>> >>> John >>> _______________________________________________ >>> Do not post admin requests to the list. They will be ignored. >>> Webobjects-dev mailing list ([email protected]) >>> Help/Unsubscribe/Update your Subscription: >>> https://lists.apple.com/mailman/options/webobjects-dev/aaron%40chatnbike.com >>> >>> This email sent to [email protected] >> >
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
