Statement calling procedures with fetch size (result streaming) will not finished in a stable state, according to fetch size value and procedure resultset size.

Example :
/*
DELIMITER $$
Create procedure testCallWithFetchSize ()
BEGIN
SELECT 1;
SELECT 2;
END$$
DELIMITER;
*/

try (Statement statement = sharedConnection.createStatement()) {

	statement.setFetchSize(1);

	try (ResultSet resultSet = statement.executeQuery("CALL testCallWithFetchSize()")) {

		int rowCount = 0;

		while(resultSet.next()) {

			rowCount++;

		}

	}

}

//next query will fail.

Procedure result differ from other query, since can have differents results.

JDBC indicate that procedures are normally called using CallableStatement , but there is not reason to block that for PrepareStatement/statement.