java.sql.SQLException

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.

  • oracle10g hibernate problem
    via Stack Overflow by cometta
    ,
  • Discussion list for users of GeoServer
    via by Unknown author,
  • 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,
    • java.sql.SQLException: ORA-00936: missing expression at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:113)

    Users with the same issue

    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    76 more bugmates