Path: csiph.com!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail From: Cecil Westerhof Newsgroups: comp.lang.java.programmer Subject: Re: Not closing connections and statements Date: Sat, 13 Aug 2016 12:21:26 +0200 Organization: Decebal Computing Lines: 15 Message-ID: <87twepj7fd.fsf@Equus.decebal.nl> References: <87shuakxjq.fsf@Equus.decebal.nl> <87k2fllkjf.fsf@Equus.decebal.nl> Mime-Version: 1.0 Content-Type: text/plain Injection-Info: mx02.eternal-september.org; posting-host="12baf5125b19322b899c79c2e3878015"; logging-data="18865"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18ToFL0Ymz8ndA8LW0MmtKJxCxvemvGCDw=" User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/24.3 (gnu/linux) X-Homepage: http://www.decebal.nl/ Cancel-Lock: sha1:TuP3zYQRSqZSVo0B/5IpHQNdKVs= sha1:K9Oc7eSLvGUbeS2Hrtwfsivl4U8= Xref: csiph.com comp.lang.java.programmer:35301 On Saturday 13 Aug 2016 10:05 CEST, Andreas Leitgeb wrote: > Marcel Mueller wrote: >> However, it might or might not be a good advice to intentionally >> keep a DB connection idle for an hour. > > I've seen too many firewalls shut off connections after an hour or > even earlier to leave the "might"-option uncontradicted. SQLite uses a local file, so I do not have to worry about firewalls. -- Cecil Westerhof Senior Software Engineer LinkedIn: http://www.linkedin.com/in/cecilwesterhof