Hi Alexander, Thanks for the tip. I have just tried this additional flag and on exiting my JC app, the server side threw this:
Component: com.webobjects.eodistribution.WOJavaClientApplet Exception message: endUndoGrouping: undo manager is in invalid state, endUndoGrouping called with no matching begin Stack Trace... java.lang.IllegalStateException: endUndoGrouping: undo manager is in invalid state, endUndoGrouping called with no matching begin John On 13 Mar 2014, at 13:48, Alexander Spohr <[email protected]> wrote: >> 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(). > > > Am 13.03.2014 um 14:04 schrieb Aaron Rosenzweig <[email protected]>: > >> 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(); > > > Please be aware that this bug might kill your database after a while! > > At least using PostgreSQL, the database will keep all changes since the start > of the app, as long as the „Database Info“ transaction is not committed - > which it never will be. > > To avoid this we append „?useBundledJdbcInfo=true“ to all database urls. > > atze > _______________________________________________ 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]
