java.sql.SQLException: No ResultSet was produced

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.

  • help needed - about change password page
    via by 807549,
  • The following SQL works fine for Table Input Step in 3.2.4 but not in 3.2.5. DECLARE @ret VARCHAR(8000) SELECT @ret = COALESCE(@ret, '') + attributename + ',' FROM attributes WHERE objectname = '${TABLENAME}' and persistent = 1; SET @ret = LEFT(@ret, LEN(@ret) - 1) SELECT @ret as 'attributes'; The error received is: 2010/05/10 13:51:09 - Get attributes for the table.0 - ERROR (version 3.2.5, build 1 from 2010-04-15 15.51.05 by bill.wallace) : Unexpected error : 2010/05/10 13:51:09 - Get attributes for the table.0 - ERROR (version 3.2.5, build 1 from 2010-04-15 15.51.05 by bill.wallace) : org.pentaho.di.core.exception.KettleDatabaseException: 2010/05/10 13:51:09 - Get attributes for the table.0 - ERROR (version 3.2.5, build 1 from 2010-04-15 15.51.05 by bill.wallace) : An error occurred executing SQL: 2010/05/10 13:51:09 - Get attributes for the table.0 - ERROR (version 3.2.5, build 1 from 2010-04-15 15.51.05 by bill.wallace) : DECLARE @ret VARCHAR(8000) SELECT @ret = COALESCE(@ret, '') + attributename + ',' FROM attributes WHERE objectname = '' and persistent = 1; SET @ret = LEFT(@ret, LEN(@ret) - 1) SELECT @ret as 'attributes'; 2010/05/10 13:51:09 - Get attributes for the table.0 - ERROR (version 3.2.5, build 1 from 2010-04-15 15.51.05 by bill.wallace) : No ResultSet was produced 2010/05/10 13:51:09 - Get attributes for the table.0 - ERROR (version 3.2.5, build 1 from 2010-04-15 15.51.05 by bill.wallace) : 2010/05/10 13:51:09 - Get attributes for the table.0 - ERROR (version 3.2.5, build 1 from 2010-04-15 15.51.05 by bill.wallace) : at org.pentaho.di.core.database.Database.openQuery(Database.java:1790) 2010/05/10 13:51:09 - Get attributes for the table.0 - ERROR (version 3.2.5, build 1 from 2010-04-15 15.51.05 by bill.wallace) : at org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:216) 2010/05/10 13:51:09 - Get attributes for the table.0 - ERROR (version 3.2.5, build 1 from 2010-04-15 15.51.05 by bill.wallace) : at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:127) 2010/05/10 13:51:09 - Get attributes for the table.0 - ERROR (version 3.2.5, build 1 from 2010-04-15 15.51.05 by bill.wallace) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2890) 2010/05/10 13:51:09 - Get attributes for the table.0 - ERROR (version 3.2.5, build 1 from 2010-04-15 15.51.05 by bill.wallace) : at org.pentaho.di.trans.steps.tableinput.TableInput.run(TableInput.java:350) 2010/05/10 13:51:09 - Get attributes for the table.0 - ERROR (version 3.2.5, build 1 from 2010-04-15 15.51.05 by bill.wallace) : Caused by: java.sql.SQLException: No ResultSet was produced 2010/05/10 13:51:09 - Get attributes for the table.0 - ERROR (version 3.2.5, build 1 from 2010-04-15 15.51.05 by bill.wallace) : at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(Unknown Source) 2010/05/10 13:51:09 - Get attributes for the table.0 - ERROR (version 3.2.5, build 1 from 2010-04-15 15.51.05 by bill.wallace) : at org.pentaho.di.core.database.Database.openQuery(Database.java:1776) 2010/05/10 13:51:09 - Get attributes for the table.0 - ERROR (version 3.2.5, build 1 from 2010-04-15 15.51.05 by bill.wallace) : ... 4 more 2010/05/10 13:51:09 - Get attributes for the table.0 - Finished reading query, closing connection.
    via by Bill Wallace,
  • Streaming Data from AccessDatabase
    via by 843859,
  • help me !!
    via by 843835,
  • Need help to delete data
    via by 843854,
  • JDBC SQL entry No ResultSet run time error
    via by 807593,
    • java.sql.SQLException: No ResultSet was produced at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:255) at logintry.DataMiningFrame.jButton1_actionPerformed(DataMiningFrame.java:239) at logintry.DataMiningFrame$1.actionPerformed(DataMiningFrame.java:77) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1450) at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1504) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:378) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:250) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:216) at java.awt.Component.processMouseEvent(Component.java:3715) at java.awt.Component.processEvent(Component.java:3544) at java.awt.Container.processEvent(Container.java:1164) at java.awt.Component.dispatchEventImpl(Component.java:2593) at java.awt.Container.dispatchEventImpl(Container.java:1213) at java.awt.Component.dispatchEvent(Component.java:2497) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:2451) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:2216) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:2125) at java.awt.Container.dispatchEventImpl(Container.java:1200) at java.awt.Window.dispatchEventImpl(Window.java:914) at java.awt.Component.dispatchEvent(Component.java:2497) at java.awt.EventQueue.dispatchEvent(EventQueue.java:339) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:131) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:98) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93) at java.awt.EventDispatchThread.run(EventDispatchThread.java:85)
    No Bugmate found.