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.

Pentaho BI Platform Tracking | Brian Vandenberg | 9 years ago
  1. 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.
  2. 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.
  3. 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.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    java.sql.SQLException: expection being thrown for SQOOP import

    Stack Overflow | 1 year ago | Hacker
    java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@2d749418 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

    [jira] [Commented] (SQOOP-1400) Failed to import data using mysql-connector-java-5.1.17.jar

    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.

    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@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()
    2. MySQL jdbc
      ResultSetMetaData.getPrecision
      1. com.mysql.jdbc.MysqlIO.checkForOutstandingStreamingData(MysqlIO.java:2095)
      2. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1510)
      3. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
      4. com.mysql.jdbc.Connection.execSQL(Connection.java:3020)
      5. com.mysql.jdbc.Connection.execSQL(Connection.java:2949)
      6. com.mysql.jdbc.Statement.executeQuery(Statement.java:959)
      7. com.mysql.jdbc.Connection.getMaxBytesPerChar(Connection.java:3384)
      8. com.mysql.jdbc.Field.getMaxBytesPerCharacter(Field.java:477)
      9. com.mysql.jdbc.ResultSetMetaData.getPrecision(ResultSetMetaData.java:385)
      9 frames
    3. org.pentaho.di
      GetPreviewTableProgressDialog$1.run
      1. org.pentaho.di.core.database.Database.getValueFromSQLType(Database.java:2599)
      2. org.pentaho.di.core.database.Database.getRowInfo(Database.java:2417)
      3. org.pentaho.di.core.database.Database.openQuery(Database.java:1771)
      4. org.pentaho.di.core.database.Database.openQuery(Database.java:1702)
      5. org.pentaho.di.core.database.Database.openQuery(Database.java:1697)
      6. org.pentaho.di.core.database.Database.openQuery(Database.java:1684)
      7. org.pentaho.di.core.database.Database.getRows(Database.java:3916)
      8. org.pentaho.di.core.database.Database.getFirstRows(Database.java:3994)
      9. org.pentaho.di.ui.core.database.dialog.GetPreviewTableProgressDialog$1.run(GetPreviewTableProgressDialog.java:72)
      9 frames
    4. JFace
      ModalContext$ModalContextThread.run
      1. org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113)
      1 frame