I thought this got fixed but turns out its happening again. If you open up a sql server query analyzer window and execute the following query:
WAITFOR DELAY '00:00:20'
Then hit the cancel button, you get the following execption:
>[Error] Script lines: 1-1 --------------------------
Invalid state, the Statement object is closed.
>[Error] Script lines: 1-1 --------------------------
I/O Error: Expecting a TDS_DONE or TDS_DONEPROC.
java.sql.SQLException: Invalid state, the Connection object is closed.
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.checkOpen(ConnectionJDBC2.java:1718)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.createStatement(ConnectionJDBC2.java:2334)
at com.aquafold.aquacore.scripts.WrapperConnection.createStatement(WrapperConnection.java:40)
at com.aquafold.aquacore.scripts.ConnectionProperties.getCurrentDatabase(ConnectionProperties.java:3254)
at com.aquafold.aquacore.scripts.PooledConnection.close(PooledConnection.java:93)
at com.aquafold.aquacore.scripts.PooledConnection.decrementAcquirer(PooledConnection.java:389)
at com.aquafold.datastudio.queryanalyzer.QueryThread.run(QueryThread.java:912)
This issue not reproducible in ads version 17.0.0-rc-20.It shows message 'Cancel has been invoked on this Statement' for all above ms sql server.