java.sql.SQLException: Io > exception: Socket read timed out 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:197) > > at > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:261) > > at > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:566) > > at > oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:802) > > at > oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866) > > at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186) > > at > oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387) > > at > oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431) > > at > oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1203) > > at > org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) >

Oracle Community | madhukar_vishal | 4 years ago
  1. 0

    org.hibernate.exception.JDBCConnectionException: could not execute query

    Oracle Community | 4 years ago | madhukar_vishal
    java.sql.SQLException: Io > exception: Socket read timed out 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:197) > > at > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:261) > > at > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:566) > > at > oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:802) > > at > oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866) > > at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186) > > at > oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387) > > at > oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431) > > at > oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1203) > > at > org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) >
  2. 0

    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

    Pentaho BI Platform Tracking | 7 years ago | Wayne Johnson
    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)
  3. 0

    Connection to wordnet with jwnl - Java Programming - KnowCoding.com

    knowcoding.com | 1 year ago
    java.sql.SQLException: Io exception: Connection reset by peer: socket write error at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:112) at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:146) at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:255) at oracle.jdbc.driver.T4CPreparedStatement.executeFor Describe(T4CPreparedStatement.java:826) at oracle.jdbc.driver.OracleStatement.executeMaybeDes cribe(OracleStatement.java:1039) at oracle.jdbc.driver.T4CPreparedStatement.executeMay beDescribe(T4CPreparedStatement.java:850) at oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStatement.java:1134) at oracle.jdbc.driver.OraclePreparedStatement.execute Internal(OraclePreparedStatement.java:3339) at oracle.jdbc.driver.OraclePreparedStatement.execute Query(OraclePreparedStatement.java:3384) at org.hibernate.jdbc.AbstractBatcher.getResultSet(Ab stractBatcher.java:208) at org.hibernate.loader.Loader.getResultSet(Loader.ja va:1808) at org.hibernate.loader.Loader.doQuery(Loader.java:69 7) at org.hibernate.loader.Loader.doQueryAndInitializeNo nLazyCollections(Loader.java:259) at org.hibernate.loader.Loader.doList(Loader.java:222 8) at org.hibernate.loader.Loader.listIgnoreQueryCache(L oader.java:2125)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    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

    Pentaho BI Platform Tracking | 7 years ago | Wayne Johnson
    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)
  6. 0

    Error check not working - Java Programming Help - KnowCoding.com

    knowcoding.com | 7 months ago
    java.sql.SQLException: Io exception: Connection reset by peer: socket write error at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:112) at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:146) at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:255) at oracle.jdbc.driver.T4CPreparedStatement.executeFor Describe(T4CPreparedStatement.java:826) at oracle.jdbc.driver.OracleStatement.executeMaybeDes cribe(OracleStatement.java:1039) at oracle.jdbc.driver.T4CPreparedStatement.executeMay beDescribe(T4CPreparedStatement.java:850) at oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStatement.java:1134) at oracle.jdbc.driver.OraclePreparedStatement.execute Internal(OraclePreparedStatement.java:3339) at oracle.jdbc.driver.OraclePreparedStatement.execute Query(OraclePreparedStatement.java:3384) at org.hibernate.jdbc.AbstractBatcher.getResultSet(Ab stractBatcher.java:208) at org.hibernate.loader.Loader.getResultSet(Loader.ja va:1808) at org.hibernate.loader.Loader.doQuery(Loader.java:69 7) at org.hibernate.loader.Loader.doQueryAndInitializeNo nLazyCollections(Loader.java:259) at org.hibernate.loader.Loader.doList(Loader.java:222 8) at org.hibernate.loader.Loader.listIgnoreQueryCache(L oader.java:2125)

    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

      Io > exception: Socket read timed out 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:197) > > at > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:261) > > at > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:566) > > at > oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:802) > > at > oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866) > > at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186) > > at > oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387) > > at > oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431) > > at > oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1203) > > at > org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) >

      at org.hibernate.loader.Loader.getResultSet()
    2. Hibernate
      Loader.getResultSet
      1. org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
      1 frame