Re: [Squirrel-sql-users] MariaDB connections start failing after idle and won't reconnect

[Gerd W. <ger...@t-...>]

Here's another trial to answer a question you haven't already found out 
yourself.
I was a bit busy lately and am going through several mails now. Sorry.

Am 26.04.2017 um 21:48 schrieb KARR, DAVID:
> I'm connecting to a MariaDB database.  The app running in Tomcat that
> uses the database is now setting "testWhileIdle" and "testOnReturn"
> to true, because the connections seem to time out after a while of
> being idle.  Those appear to mitigate the problem in the app itself.
>
> In SQuirreL, if I leave a connection open for a while, I get similar
> errors like: ---------- Error: (conn:121) Could not read packet:
> unexpected end of stream, read 0 bytes from 4 ---------
>
> It's not clear to me how to configure the connection automatically to
> mitigate these problems.
>
> What's even worse is that when I try to "Reconnect", it just fails
> with "Error: (conn:121) Connection is close".  I actually have to
> completely close the connection and reopen it, and then it works
> until I go idle again.
>
> What can I do to mitigate these problems in SQuirreL?

Right click your Alias -> Alias properties -> Tab 'Connection'. The SQL 
entered there will be executed periodically with configurable repeat time.