We have a Red Prairie Integrator software which disconnects from the DB server about once a day, sometimes more.
The database is MS SQL 2012 SP2 running on Linux.
The application server is 2012R2 running the RP software.
JDA/RP does not seem to understandy why.
java.sql.SQLException: I/O Error: Software caused connection abort: recv failed
at net.souceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1053)
at net.souceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:537)
at net.souceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723)
at net.souceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1160)
at sun.reflect.GeneratedMethodAccessor81.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
This usually means that there was a network error or the server prematurely closed the connection. I don't think this has anything to do with the jTDS driver.