java.sql.SQLException: Could not execute the query

Oracle Community | 807594 | 1 decade ago
  1. 0

    SQL Problem?

    Oracle Community | 1 decade ago | 807594
    java.sql.SQLException: Could not execute the query
  2. 0

    SQL Problem?

    Oracle Community | 1 decade ago | 807594
    java.sql.SQLException: Could not execute the query
  3. 0

    Maze solver method

    Coderanch | 4 years ago | Wendy Gibbons
    java.sql.SQLException: Could not set SQL query
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Here is the simple query created with the Query Designer which fails to execute. {code} SELECT "Kettle"."344DataService"."PRODUCTLINE", sum("Kettle"."344DataService"."SALES") FROM "Kettle"."344DataService" GROUP BY "344DataService"."PRODUCTLINE" {code} {noformat} org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: SELECT "Kettle"."344DataService"."PRODUCTLINE", sum(Kettle"."344DataService"."SALES") FROM "Kettle"."344DataService" GROUP BY "344DataService"."PRODUCTLINE" at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:183) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory.queryData(SQLReportDataFactory.java:139) at org.pentaho.reporting.ui.datasources.jdbc.ui.JdbcPreviewWorker.run(JdbcPreviewWorker.java:95) at java.lang.Thread.run(Thread.java:722) Caused by: java.sql.SQLException: Unable to execute query: at org.pentaho.di.trans.dataservice.jdbc.ThinStatement.executeQuery(ThinStatement.java:123) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.parametrizeAndQuery(SimpleSQLReportDataFactory.java:308) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:178) ... 3 more Caused by: java.sql.SQLException: Unable to get open query for SQL: SELECT "Kettle"."344DataService"."PRODUCTLINE", sum(Kettle"."344DataService"."SALES") FROM "Kettle"."344DataService" GROUP BY "344DataService"."PRODUCTLINE" org.pentaho.di.core.exception.KettleException: No closing " found, starting at location 175 in : [SELECT "KETTLE"."344DATASERVICE"."PRODUCTLINE", SUM(KETTLE"."344DATASERVICE"."SALES") FROM "KETTLE"."344DATASERVICE" GROUP BY "344DATASERVICE"."PRODUCTLINE"] at org.pentaho.di.cluster.HttpUtil.execMethod(HttpUtil.java:138) at org.pentaho.di.cluster.HttpUtil.execService(HttpUtil.java:95) at org.pentaho.di.trans.dataservice.jdbc.ThinResultSet.remoteQuery(ThinResultSet.java:144) at org.pentaho.di.trans.dataservice.jdbc.ThinResultSet.<init>(ThinResultSet.java:107) at org.pentaho.di.trans.dataservice.jdbc.ThinStatement.executeQuery(ThinStatement.java:120) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.parametrizeAndQuery(SimpleSQLReportDataFactory.java:308) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:178) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory.queryData(SQLReportDataFactory.java:139) at org.pentaho.reporting.ui.datasources.jdbc.ui.JdbcPreviewWorker.run(JdbcPreviewWorker.java:95) at java.lang.Thread.run(Thread.java:722) at org.pentaho.di.trans.dataservice.jdbc.ThinResultSet.<init>(ThinResultSet.java:127) at org.pentaho.di.trans.dataservice.jdbc.ThinStatement.executeQuery(ThinStatement.java:120) ... 5 more Caused by: org.pentaho.di.core.exception.KettleException: No closing " found, starting at location 175 in : [SELECT "KETTLE"."344DATASERVICE"."PRODUCTLINE", SUM(KETTLE"."344DATASERVICE"."SALES") FROM "KETTLE"."344DATASERVICE" GROUP BY "344DATASERVICE"."PRODUCTLINE"] at org.pentaho.di.cluster.HttpUtil.execMethod(HttpUtil.java:138) at org.pentaho.di.cluster.HttpUtil.execService(HttpUtil.java:95) at org.pentaho.di.trans.dataservice.jdbc.ThinResultSet.remoteQuery(ThinResultSet.java:144) at org.pentaho.di.trans.dataservice.jdbc.ThinResultSet.<init>(ThinResultSet.java:107) ... 6 more {noformat} Removing "Kettle." from the column name in the SELECT, the query will run. {code} SELECT "344DataService"."PRODUCTLINE", sum("344DataService"."SALES") FROM "Kettle"."344DataService" GROUP BY "344DataService"."PRODUCTLINE" {code}

    Pentaho BI Platform Tracking | 1 year ago | Kurtis Cruzada
    org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: SELECT "Kettle"."344DataService"."PRODUCTLINE", sum(Kettle"."344DataService"."SALES") FROM "Kettle"."344DataService" GROUP BY "344DataService"."PRODUCTLINE"
  6. 0

    Here is the simple query created with the Query Designer which fails to execute. {code} SELECT "Kettle"."344DataService"."PRODUCTLINE", sum("Kettle"."344DataService"."SALES") FROM "Kettle"."344DataService" GROUP BY "344DataService"."PRODUCTLINE" {code} {noformat} org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: SELECT "Kettle"."344DataService"."PRODUCTLINE", sum(Kettle"."344DataService"."SALES") FROM "Kettle"."344DataService" GROUP BY "344DataService"."PRODUCTLINE" at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:183) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory.queryData(SQLReportDataFactory.java:139) at org.pentaho.reporting.ui.datasources.jdbc.ui.JdbcPreviewWorker.run(JdbcPreviewWorker.java:95) at java.lang.Thread.run(Thread.java:722) Caused by: java.sql.SQLException: Unable to execute query: at org.pentaho.di.trans.dataservice.jdbc.ThinStatement.executeQuery(ThinStatement.java:123) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.parametrizeAndQuery(SimpleSQLReportDataFactory.java:308) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:178) ... 3 more Caused by: java.sql.SQLException: Unable to get open query for SQL: SELECT "Kettle"."344DataService"."PRODUCTLINE", sum(Kettle"."344DataService"."SALES") FROM "Kettle"."344DataService" GROUP BY "344DataService"."PRODUCTLINE" org.pentaho.di.core.exception.KettleException: No closing " found, starting at location 175 in : [SELECT "KETTLE"."344DATASERVICE"."PRODUCTLINE", SUM(KETTLE"."344DATASERVICE"."SALES") FROM "KETTLE"."344DATASERVICE" GROUP BY "344DATASERVICE"."PRODUCTLINE"] at org.pentaho.di.cluster.HttpUtil.execMethod(HttpUtil.java:138) at org.pentaho.di.cluster.HttpUtil.execService(HttpUtil.java:95) at org.pentaho.di.trans.dataservice.jdbc.ThinResultSet.remoteQuery(ThinResultSet.java:144) at org.pentaho.di.trans.dataservice.jdbc.ThinResultSet.<init>(ThinResultSet.java:107) at org.pentaho.di.trans.dataservice.jdbc.ThinStatement.executeQuery(ThinStatement.java:120) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.parametrizeAndQuery(SimpleSQLReportDataFactory.java:308) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:178) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory.queryData(SQLReportDataFactory.java:139) at org.pentaho.reporting.ui.datasources.jdbc.ui.JdbcPreviewWorker.run(JdbcPreviewWorker.java:95) at java.lang.Thread.run(Thread.java:722) at org.pentaho.di.trans.dataservice.jdbc.ThinResultSet.<init>(ThinResultSet.java:127) at org.pentaho.di.trans.dataservice.jdbc.ThinStatement.executeQuery(ThinStatement.java:120) ... 5 more Caused by: org.pentaho.di.core.exception.KettleException: No closing " found, starting at location 175 in : [SELECT "KETTLE"."344DATASERVICE"."PRODUCTLINE", SUM(KETTLE"."344DATASERVICE"."SALES") FROM "KETTLE"."344DATASERVICE" GROUP BY "344DATASERVICE"."PRODUCTLINE"] at org.pentaho.di.cluster.HttpUtil.execMethod(HttpUtil.java:138) at org.pentaho.di.cluster.HttpUtil.execService(HttpUtil.java:95) at org.pentaho.di.trans.dataservice.jdbc.ThinResultSet.remoteQuery(ThinResultSet.java:144) at org.pentaho.di.trans.dataservice.jdbc.ThinResultSet.<init>(ThinResultSet.java:107) ... 6 more {noformat} Removing "Kettle." from the column name in the SELECT, the query will run. {code} SELECT "344DataService"."PRODUCTLINE", sum("344DataService"."SALES") FROM "Kettle"."344DataService" GROUP BY "344DataService"."PRODUCTLINE" {code}

    Pentaho BI Platform Tracking | 1 year ago | Kurtis Cruzada
    org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: SELECT "Kettle"."344DataService"."PRODUCTLINE", sum(Kettle"."344DataService"."SALES") FROM "Kettle"."344DataService" GROUP BY "344DataService"."PRODUCTLINE"

    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

      Could not execute the query

      at com.ISAS.common.Person.<init>()
    2. com.ISAS.common
      test.main
      1. com.ISAS.common.Person.<init>(Person.java:101)
      2. com.ISAS.common.test.main(test.java:25)
      2 frames