java.sql.SQLException

If you like a tip written by other Samebug users, mark is as helpful! Marks help our algorithm provide you better solutions and also help other users.
tip

This is a bug in version 4.1.9 and it's fixed from version 4.3.0beta and beyond.

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

  • Here is a foodmart example of the problem: SELECT distinct "customer_id" "Customer", "store_id" "Store ID" FROM "sales_fact_1997" The exception I get is the following: java.sql.SQLException: ORA-00904: "LOGICAL_TABLE_1"."CUSTOMER": invalid identifier at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:204) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:780) at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:855) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1377) at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:387) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205) at org.pentaho.platform.plugin.services.connections.sql.SQLConnection.executeQuery(SQLConnection.java:375) at org.pentaho.platform.plugin.services.connections.sql.SQLConnection.executeQuery(SQLConnection.java:332) at org.pentaho.platform.plugin.action.pentahometadata.MetadataQueryComponent.executeSqlPhysicalModel(MetadataQueryComponent.java:407) at org.pentaho.platform.plugin.action.pentahometadata.MetadataQueryComponent.execute(MetadataQueryComponent.java:237) at org.pentaho.platform.plugin.action.pentahometadata.MQLRelationalDataComponent.executeAction(MQLRelationalDataComponent.java:111) This is the sql statement the customer was using... > SELECT OCM.PO_CAMPAIGN_ID "Campaign ID" > > ,OCM.PO_CAMPAIGN_NAME "Campaign" > > ,OCM.CLIENT_NAME "Client" > > ,OCM.HOURS_TO_LIVE "TTL" > > ,PRL.PREQUAL_LINK_ID "Prequal ID" > > ,PRL.NAME "Prequal" > > ,PRL.IS_EVALUATED_BY_ROUTER "Router" > > ,OCM.INITIAL_INCIDENCE "Estimated Incidence" > > ,OCM.INCIDENCE "Calculated Incidence" > > ,PRL.TOT_EXPOSURES "Exposures" > > ,PRL.TOT_EXPOSURES-PRL.TOT_STARTS "Declined" > > ,PRL.TOT_STARTS "Client Passes" > > ,count.ppl_report.GetOutcomeTotal(PRL.PREQUAL_LINK_ID,'survey > terminated') "Terms" > > ,PRL.TOT_STARTS-(PRL.TOT_COMPLETE+PRL.TOT_FRAUD > +count.ppl_report.GetOutcomeTotal(PRL.PREQUAL_LINK_ID,'survey > terminated')) "Drop Offs" > > ,count.ppl_report.GetOutcomeTotal(PRL.PREQUAL_LINK_ID,'client > quota full') "Over Quota" > > ,PRL.TOT_FRAUD "Fraud" > > ,PRL.TOT_COMPLETE "Completes" > > ,PRL.CLIENT_SURVEY_LENGTH "Estimated AIT" > > ,count.ppl_report.GetAIT(PRL.PREQUAL_LINK_ID) "Actual AIT" > > ,CASE WHEN BROKER_ID IS NOT NULL THEN 'Vendor' ELSE 'Portal' > END "Vendor or Portal" > > FROM COUNT.SIR_OPEN_CAMPAIGNS OCM > > ,COUNT.PO_CAMPAIGNS CAM > > ,COUNT.PREQUAL_LINKS PRL > > WHERE PRL.PO_CAMPAIGN_ID = OCM.PO_CAMPAIGN_ID > > AND OCM.PO_CAMPAIGN_ID = CAM.PO_CAMPAIGN_ID Please also see supporting attachments. Wayne
    via by Wayne Johnson,
  • oracle10g hibernate problem
    via Stack Overflow by cometta
    ,
  • Discussion list for users of GeoServer
    via by Unknown author,
    • java.sql.SQLException: ORA-00933: SQL command not properly ended at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping. java:74) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java: 131) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError. java:204) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)

    Users with the same issue

    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    tomthomastomthomas
    1 times, last one,
    tzrlktzrlk
    10 times, last one,
    treefolktreefolk
    6 times, last one,
    46 more bugmates