java.sql.SQLException: No ResultSet was produced

Oracle Community | 807549 | 1 decade ago
  1. 0

    help needed - about change password page

    Oracle Community | 1 decade ago | 807549
    java.sql.SQLException: No ResultSet was produced
  2. 0

    how to insert value in ms access using java

    Stack Overflow | 3 years ago | user3584769
    java.sql.SQLException: No ResultSet was produced
  3. 0

    Java SQL update syntax - Software Development | DaniWeb

    daniweb.com | 1 year ago
    java.sql.SQLException: No ResultSet was produced
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Java SQL update syntax - Software Development | DaniWeb

    daniweb.com | 1 year ago
    java.sql.SQLException: No ResultSet was produced
  6. 0

    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.

    Pentaho BI Platform Tracking | 7 years ago | Bill Wallace
    org.pentaho.di.core.exception.KettleDatabaseException: An error occurred executing SQL: 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'; No ResultSet was produced

    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

      No ResultSet was produced

      at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery()
    2. sun.jdbc.odbc
      JdbcOdbcStatement.executeQuery
      1. sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:255)
      1 frame
    3. logintry
      DataMiningFrame$1.actionPerformed
      1. logintry.DataMiningFrame.jButton1_actionPerformed(DataMiningFrame.java:239)
      2. logintry.DataMiningFrame$1.actionPerformed(DataMiningFrame.java:77)
      2 frames
    4. Java RT
      EventDispatchThread.run
      1. javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1450)
      2. javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1504)
      3. javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:378)
      4. javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:250)
      5. javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:216)
      6. java.awt.Component.processMouseEvent(Component.java:3715)
      7. java.awt.Component.processEvent(Component.java:3544)
      8. java.awt.Container.processEvent(Container.java:1164)
      9. java.awt.Component.dispatchEventImpl(Component.java:2593)
      10. java.awt.Container.dispatchEventImpl(Container.java:1213)
      11. java.awt.Component.dispatchEvent(Component.java:2497)
      12. java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:2451)
      13. java.awt.LightweightDispatcher.processMouseEvent(Container.java:2216)
      14. java.awt.LightweightDispatcher.dispatchEvent(Container.java:2125)
      15. java.awt.Container.dispatchEventImpl(Container.java:1200)
      16. java.awt.Window.dispatchEventImpl(Window.java:914)
      17. java.awt.Component.dispatchEvent(Component.java:2497)
      18. java.awt.EventQueue.dispatchEvent(EventQueue.java:339)
      19. java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:131)
      20. java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:98)
      21. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
      22. java.awt.EventDispatchThread.run(EventDispatchThread.java:85)
      22 frames