A few weeks ago I got a PANS about this article.
I except that somebody called PSC and asked them about this topic as I did months ago without a resolution.
No I read this article and tried it again with Squirrel and it doesn't works (again) and I re-opened my case.
Meanwhile I got a very honest reply from PSC:
The problem here is that the cancel operation is supported with the JDBC OpenEdge driver but our OpenEdge SQL server does not support an ability for a client to cancel an executing statement
Perhaps it's a big misunderstanding from my side?
There is a KB article for OpenEdge 11.x with a well described example but it does not work?!
It seems to be that the ODBC/JDBC development team has a communication issue.
Canceling is very important to give the j(o)dbc users a availability to cancel misformed long running queries which increase performance.
Article Number | 000074191 |
Environment | Product: OpenEdge Version: 11.x OS: All supported platforms Other: SQL |
Question/Problem Description |
|
Steps to Reproduce |
Clarifying Information |
|
Error Message |
Defect/Enhancement Number |
Cause |
|
Resolution |
|
Hi Stefan,
It's not a misunderstanding from your side, but rather a mistake on our side. Our apologies for causing the confusion. When the KBase article was initially created we failed to check whether this was also supported by the SQL engine. The KBase article in question has now been updated with the correct information.
Regards,
Donicello Lampe
The blame was that I trusted the KB and asked the squirrel developer that something is wrong on his side.
Please tell me who wrote this KB because he and others (any customer) seems to think that it really works.
Please vote for it, or is nobody using JDBC for OpenEdge for live queries on production server?
(only reliable if not using the new width features)
Hi Stefan,
I voted already, hopefully more people will as well. It looks like this feature has not been requested a lot, because that KBase article was only used once before (now twice with your case). As you mentioned, still some people may believe that this should work, so we will take care of informing all parties involved regarding this KBase article to prevent any further confusion.
Regards,
Donicello Lampe