java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@14fc557 is still active. Only one streaming result set may be open and in use per-connection. Ensure that you have called .close() on any active result sets before attempting more queries.

hivmr.com | 4 months ago
  1. 0

    db:: 3.27::Cant load object using JasperReports 1k

    hivmr.com | 4 months ago
    java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@14fc557 is still active. Only one streaming result set may be open and in use per-connection. Ensure that you have called .close() on any active result sets before attempting more queries.
  2. 0

    java.lang.OutOfMemoryError when using jasperreports

    Oracle Community | 1 decade ago | 843859
    java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@14fc557 is still active. Only one streaming result set may be open and in use per-connection. Ensure that you have called .close() on any active result sets before attempting more queries.
  3. 0

    How to reproduce: - Have a simple transformation with a Table Input and a Database Lookup step pointing to the same connection (see attached) - Do a preview on Database Lookup step - Stop the transformation The Table Input step errors out: orderdetails.0: Unexpected error closing query : org.pentaho.di.core.exception.KettleDatabaseException: orderdetails.0: Couldn't close query: resultset or prepared statements orderdetails.0: Query execution was interrupted pentaho_oltp: Error disconnecting from database: pentaho_oltp: pentaho_oltp: Error comitting connection pentaho_oltp: Streaming result set com.mysql.jdbc.RowDataDynamic@2fa8d4e2 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. pentaho_oltp: org.pentaho.di.core.exception.KettleDatabaseException: pentaho_oltp: Error comitting connection pentaho_oltp: Streaming result set com.mysql.jdbc.RowDataDynamic@2fa8d4e2 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. pentaho_oltp: pentaho_oltp: at org.pentaho.di.core.database.Database.commit(Database.java:712) pentaho_oltp: at org.pentaho.di.core.database.Database.commit(Database.java:681) pentaho_oltp: at org.pentaho.di.core.database.Database.disconnect(Database.java:572) pentaho_oltp: at org.pentaho.di.trans.steps.tableinput.TableInput.dispose(TableInput.java:275) pentaho_oltp: at org.pentaho.di.trans.step.RunThread.run(RunThread.java:69) pentaho_oltp: at java.lang.Thread.run(Unknown Source) pentaho_oltp: Caused by: java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@2fa8d4e2 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. pentaho_oltp: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:934) pentaho_oltp: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931) pentaho_oltp: at com.mysql.jdbc.MysqlIO.checkForOutstandingStreamingData(MysqlIO.java:2735) pentaho_oltp: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1899) pentaho_oltp: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151) pentaho_oltp: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2619) pentaho_oltp: at com.mysql.jdbc.ConnectionImpl.commit(ConnectionImpl.java:1655) pentaho_oltp: at org.pentaho.di.core.database.Database.commit(Database.java:701) pentaho_oltp: ... 5 more

    Pentaho BI Platform Tracking | 5 years ago | Jens Bleuel
    org.pentaho.di.core.exception.KettleDatabaseException: Error comitting connection Streaming result set com.mysql.jdbc.RowDataDynamic@2fa8d4e2 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.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    [SQOOP-1400] Failed to import data using mysql-connector-java-5.1.17.jar - ASF JIRA

    apache.org | 1 year ago
    java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@1cfabc3a 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.
  6. 0

    I downloaded the nightly build from 4-24-2008 to test PDI-1057 (which seems to be resolved in this build, as far as I can tell). After awhile working with this build I ran across this: java.lang.reflect.InvocationTargetException: Couldn't find any rows because of an error :org.pentaho.di.core.exception.KettleDatabaseException: An error occurred executing SQL in part [openQuery : get rowinfo]: SELECT * FROM agentdimension LIMIT 100 Error getting row information from database: Streaming result set com.mysql.jdbc.RowDataDynamic@1429cb2 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 org.pentaho.di.ui.core.database.dialog.GetPreviewTableProgressDialog$1.run(GetPreviewTableProgressDialog.java:80) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113) Caused by: org.pentaho.di.core.exception.KettleDatabaseException: An error occurred executing SQL in part [openQuery : get rowinfo]: SELECT * FROM agentdimension LIMIT 100 Error getting row information from database: Streaming result set com.mysql.jdbc.RowDataDynamic@1429cb2 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 org.pentaho.di.core.database.Database.openQuery(Database.java:1784) at org.pentaho.di.core.database.Database.openQuery(Database.java:1702) at org.pentaho.di.core.database.Database.openQuery(Database.java:1697) at org.pentaho.di.core.database.Database.openQuery(Database.java:1684) at org.pentaho.di.core.database.Database.getRows(Database.java:3916) at org.pentaho.di.core.database.Database.getFirstRows(Database.java:3994) at org.pentaho.di.ui.core.database.dialog.GetPreviewTableProgressDialog$1.run(GetPreviewTableProgressDialog.java:72) ... 1 more Caused by: org.pentaho.di.core.exception.KettleDatabaseException: Error getting row information from database: Streaming result set com.mysql.jdbc.RowDataDynamic@1429cb2 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 org.pentaho.di.core.database.Database.getRowInfo(Database.java:2424) at org.pentaho.di.core.database.Database.openQuery(Database.java:1771) ... 7 more Caused by: java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@1429cb2 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.MysqlIO.checkForOutstandingStreamingData(MysqlIO.java:2095) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1510) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695) at com.mysql.jdbc.Connection.execSQL(Connection.java:3020) at com.mysql.jdbc.Connection.execSQL(Connection.java:2949) at com.mysql.jdbc.Statement.executeQuery(Statement.java:959) at com.mysql.jdbc.Connection.getMaxBytesPerChar(Connection.java:3384) at com.mysql.jdbc.Field.getMaxBytesPerCharacter(Field.java:477) at com.mysql.jdbc.ResultSetMetaData.getPrecision(ResultSetMetaData.java:385) at org.pentaho.di.core.database.Database.getValueFromSQLType(Database.java:2599) at org.pentaho.di.core.database.Database.getRowInfo(Database.java:2417) ... 8 more Now I'm completely unable to do anything with this database connection. Unlike the user in the thread: http://forums.pentaho.org/showthread.php?t=49908 ... the transformation I was using when this initially occurred does not have a database output step, so no step exists in-which disabling a 'batch' property would resolve the issue. I've tried exiting/entering spoon repeatedly, closing all transformations/jobs, opening new ones, creating a new connection for that database, and a few other similarly obvious things to try, all to no avail. I did find, however, that the nightly build from 4-23-2008 does not have trouble communicating with the databsae, nor does a 3.0.1 version, and an old 2.x version. I've labeled this as blocker because it is inhibiting further development using _that_ build, however, I can go back to a previous version until this issue is resolved.

    Pentaho BI Platform Tracking | 9 years ago | Brian Vandenberg
    java.lang.reflect.InvocationTargetException: Couldn't find any rows because of an error :org.pentaho.di.core.exception.KettleDatabaseException: An error occurred executing SQL in part [openQuery : get rowinfo]: SELECT * FROM agentdimension LIMIT 100 Error getting row information from database: Streaming result set com.mysql.jdbc.RowDataDynamic@1429cb2 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.

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      Streaming result set com.mysql.jdbc.RowDataDynamic@14fc557 is still active. Only one streaming result set may be open and in use per-connection. Ensure that you have called .close() on any active result sets before attempting more queries.

      at com.mysql.jdbc.MysqlIO.checkForOutstandingStreamingData()
    2. MySQL jdbc
      MysqlIO.checkForOutstandingStreamingData
      1. com.mysql.jdbc.MysqlIO.checkForOutstandingStreamingData(MysqlIO.java:2125)
      1 frame