-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 30/01/12 11:59, John Fereira wrote:
Hi John, > >> -----Original Message----- From: Damian Steer >> [mailto:[email protected]] Sent: Saturday, January 28, 2012 >> 8:44 AM To: [email protected] Subject: Re: Fuseki >> (broken pipe) >> 2) Before every SDB operation check the status of the connection >> (e.g. 'SELECT 1') and, if necessary, reconnect. > > As of java 6 there is a java.sql.Connection.isValid(int timeout) > method that could be used. What are the minimum java requirements > for SDB? If it's Java 6, using the isValid() method might be the > easiest way to fix this. Oh, that would be useful. Wonder how many drivers implement it? > On Friday I updated the mysql Connector/J jar file to the latest > version and added autoReconnect=true to the jdbcUrl. I don't see > a Stacktrace anymore. autoReconnect is a bad idea anyway, since it loses things like temporary tables. I had a crack at reopening SDB connections here: <https://github.com/shellac/ReconnectingSDB> (instructions to follow) What versions of fuseki and SDB are you using? Damian -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk8mjMIACgkQAyLCB+mTtyk2rQCgjoem7xV6Q92tDBXEHtPJMVth jlsAoIsZ4fBGHXmPD4pmGT0p5Nh7fVlj =te5B -----END PGP SIGNATURE-----
