A
artturisuominen
Guest
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 = 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() .... ... 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
Continue reading...
Continue reading...