Re: java.net.SocketException: Software caused connection abort: recv failed

[Armin Ulbrich]

Hello all!
For all of you who have not solved this problem by now, I would like to propose a 'solution' or at least some workaround from code I am using (see below).
Hope it helps!
armin_

try {

statement_ = connection_.createStatement();
res = statement_.executeQuery(selectStatement); // in this line the trouble sets in in case of a time-out!

} catch (SQLException ex) {

try {

connection_.close();
Class.forName( Drivername );
Properties info = new Properties();
info.setProperty("user", User);
info.setProperty("password", Password);
connection_ = DriverManager.getConnection(DatabaseUrl, info);

// Now retry executing the query. If it was a time-out, this time it should work

statement_ = connection_.createStatement();
res = statement_.executeQuery(selectStatement);

} catch (SQLException secondEx) {
// this was not a time-out -- do some error handling
}
}