[Pharo-users] Stale SQLite connection

2020-03-12 Thread Jeff Gray
In my code I'm opening a sqlite connection and keeping it open rather than opening and closing one on each transaction. Generally it's working well. I often save and close my image. When I then reopen the image I still have a connection and it says it's open, but using it gives me an error. This

Re: [Pharo-users] Stale SQLite connection

2020-03-12 Thread Vince Refiti
lf Of Jeff Gray Sent: Friday, 13 March 2020 3:21 PM To: pharo-users@lists.pharo.org Subject: [Pharo-users] Stale SQLite connection EXTERNAL: Do not click links or open attachments if you do not recognize the sender. In my code I'm opening a sqlite connection and keeping it open rather th

Re: [Pharo-users] Stale SQLite connection

2020-03-13 Thread Erik Stel
Jeff, You could have a look at SmalltalkImage>>#addToShutDownList: and SmalltalkImage>>#addToStartUpList: to stop/(re)start the connection when image is closed or a snapshot is taken. Add a method #startUp: to handle reconnecting. See for example Clipboard>>#startUp: Cheers, Erik -- Sent from

Re: [Pharo-users] Stale SQLite connection

2020-03-16 Thread Jeff Gray
Hey Vince! Yes it's me. Hope you're well. Those meetings were fun. Shame they petered out, though I now live much further away so I wouldn't be attending anymore. Yep - that lazy eval looks very similar to my code. I think that in general operation, my application would not normally have a proble