java.sql.SQLException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • db:: 3.27::Cant load object using JasperReports 1k
    via by Unknown author,
  • 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.
    via by Brian Vandenberg,
  • 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.
    via by Brian Vandenberg,
    • 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(MysqlIO.java:2125)
    No Bugmate found.