Hi,
Using the following database/driver:
Database Version = 11.7.4
Driver Name = OpenEdge
Driver Version = 5.1.4.000130 (F000322.U000140)
We are able to succesfully make queries to the database via a java component, however, when performing longer queries problems occur. The queries no longer return anything and the connection seems stuck.
Here is the spy log following a single thread:
spy(Worker32-800)(2019/01/30 16:42:03.845)>> sql = <LONG QUERY>
spy(Worker32-800)(2019/01/30 16:42:03.872)>> OK (PreparedStatement[17])
spy(Worker32-800)(2019/01/30 16:42:03.872)>> PreparedStatement[17].executeQuery()
spy(Worker32-800)(2019/01/30 16:42:03.896)>> OK (ResultSet[17])
spy(Worker32-800)(2019/01/30 16:42:03.896)>> ResultSet[17].getMetaData()
spy(Worker32-800)(2019/01/30 16:42:03.896)>> OK (ResultSetMetaData[17])
spy(Worker32-800)(2019/01/30 16:42:03.896)>> ResultSetMetaData[17].getColumnCount()
spy(Worker32-800)(2019/01/30 16:42:03.896)>> OK (35)
spy(Worker32-800)(2019/01/30 16:42:03.896)>> ResultSet[17].next()
....
<MANY SUCCESFUL QUERIES FROM OTHER THREADS>
...
spy(Worker32-800)(2019/01/31 09:15:20.555)>> java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver][OpenEdge] Query aborted on user request (7495) ErrorCode=-30001 SQLState=HY000
java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver][OpenEdge] Query aborted on user request (7495)
at com.ddtek.jdbc.openedge.client.dde.ah(Unknown Source)
at com.ddtek.jdbc.openedge.client.dde.ag(Unknown Source)
at com.ddtek.jdbc.openedge.dde.a(Unknown Source)
at com.ddtek.jdbc.openedgebase.ddcq.aa(Unknown Source)
at com.ddtek.jdbc.openedgebase.dddm.next(Unknown Source)
at com.ddtek.jdbcspyopenedge.SpyResultSet.next(Unknown Source)
...
spy(Worker32-800)(2019/01/31 09:15:20.555)>> PreparedStatement[17].close()
spy(Worker32-800)(2019/01/31 09:15:21.160)>> java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver]Software caused connection abort: recv failed. ErrorCode=0 SQLState=HY000
java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver]Software caused connection abort: recv failed.
Has anyone had this kind of problem? I wonder if it is because of too many queries..?
Thanks,
Artturi
> On Feb 1, 2019, at 9:48 AM, artturisuominen wrote:
>
> JDBC Driver]Software caused connection abort: recv failed. ErrorCode=0 SQLState=HY000
> java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver]Software caused connection abort: recv failed.
this looks like the SQL server process has crashed. look at the database log file.