I have SailPoint IdentityIQ running on MySQL and wanted to use Oracle SQL Developer for general query purpose to see some data.
One first query execution was successful but on the 2nd query execution I was getting below error "Query Execution was Interrupted". I also see the error code as "Vendor Code 1317".
I tried different other options as suggested over internet but nothing worked for me.
On research I found that this issue was resolved with MySQL Connector version of 5.0.x but I was getting this error with 5.0.4.
Finally it was resolved by using updated versions of mysql connector i.e. 5.1.48 (mysql-connector-java-5.1.48) or 5.1.29 (mysql-connector-java-5.1.29).