S1000 Operation not allowed after ResultSet closed in Intellij only

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP



S1000 Operation not allowed after ResultSet closed in Intellij only



When using



When I execute a call to a stored procedure, I get an error message


[S1000] Operation not allowed after ResultSet closed



A simple stored procedure for testing


DELIMITER $$
CREATE PROCEDURE test1()
BEGIN
SELECT 'THIS IS A TEST TEXT';
END $$
DELIMITER ;



The call


CALL test1();



The output



The error message



The query result



NOTE: I don't get the issue when using console.





Which version of MySQL Connector/J are you using?
– Mark Rotteveel
Aug 12 at 6:43





mysql-5.7.17-winx64
– zessi
Aug 12 at 8:05





That is your MySQL version, I asked about the MySQL Connector/J version (the version of the MySQL JDBC driver you use in IntelliJ).
– Mark Rotteveel
Aug 12 at 8:06





5.1.64 in intellij settings.Don't know which one datagrip uses.
– zessi
Aug 12 at 8:09





There is no version 5.1.64, did you mean 5.1.46?
– Mark Rotteveel
Aug 12 at 8:09










By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Popular posts from this blog

Firebase Auth - with Email and Password - Check user already registered

Dynamically update html content plain JS

How to determine optimal route across keyboard