> -----Original Message----- > From: Damian Steer [mailto:[email protected]] > Sent: Monday, January 30, 2012 7:28 AM > To: [email protected] > Subject: Re: Fuseki (broken pipe) > > -----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?
Since it's in the java.sql.Connection class I suspect that the implementation is done there (possibly doing a SELECT 1 query) rather than expecting that the jdbc driver is going to implement a isValid() method. > > > 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? I'm currently using fusecki 0.2.1 and SDB 1.3.3. I think I tried SDB 1.3.4 but had some unresolved dependencies.
