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

Pentaho BI Platform Tracking | Bill Wallace | 7 years ago
  1. 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
  2. 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
  3. 0

    Streaming Data from AccessDatabase

    Oracle Community | 8 years ago | 843859
    java.sql.SQLException: No ResultSet was produced
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    how to insert value in ms access using java

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

    Java SQL update syntax - Software Development | DaniWeb

    daniweb.com | 1 year ago
    java.sql.SQLException: 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(Unknown Source)
      1 frame
    3. org.pentaho.di
      TableInput.run
      1. org.pentaho.di.core.database.Database.openQuery(Database.java:1776)
      2. org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:216)
      3. org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:127)
      4. org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2890)
      5. org.pentaho.di.trans.steps.tableinput.TableInput.run(TableInput.java:350)
      5 frames