Hello
I have some problems with streaming result set. I get the following exception:
java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@f8395f is still active. No statements may be issued when any streaming result sets are open and in use on a given connection. Ensure that you have called .close() on any active streaming result sets before attempting more queries.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)
at com.mysql.jdbc.MysqlIO.checkForOutstandingStreamingData(MysqlIO.java:2518)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1748)
...
I need to keep a streaming result set open while some other tables are updated. Looking at the documentation was not very helpful but i found the following info in the bug database:
"Streaming result sets only allow one open result set at a time on a given connection, which also doesn't adhere to the JDBC API (but which is also a trait shared with other vendors, some who open whole new connections for each new statement, and thus aren't capable of running transactions in this mode). That's why it's not the default for MySQL."
http://bugs.mysql.com/bug.php?id=18148
Is this info still valid?
Are there any plans for allowing a streaming result set to be open while some other tables are updated?
If not, is moving the streaming result set to a separate connection a solution?
Best regards
/Fredrik