org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (ORA-00923: FROM keyword not found where expected )

ibatis-user-java | Jasmin Mehta | 7 years ago
  1. 0

    Re: Database Connection reset on Oracle 10g AS using Oracle 11g database

    ibatis-user-java | 7 years ago | Jasmin Mehta
    org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (ORA-00923: FROM keyword not found where expected )
  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
  3. 0

    Exception on startup in oracle

    GitHub | 3 years ago | bryanboza
    com.dotmarketing.exception.DotDataException: ORA-00936: missing expression
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    maximum open cursors exceeded

    GitHub | 3 years ago | kvishal
    java.sql.SQLException: ORA-01000: maximum open cursors exceeded

  1. treefolk 6 times, last 2 weeks ago
1 unregistered visitors
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

    ORA-00923: FROM keyword not found where expected

    at oracle.jdbc.driver.SQLStateMapping.newSQLException()
  2. Oracle jdbc
    OracleStatementWrapper.executeQuery
    1. oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
    2. oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
    3. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:204)
    4. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
    5. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
    6. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
    7. oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
    8. oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:780)
    9. oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:855)
    10. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
    11. oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1377)
    12. oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:387)
    12 frames
  3. Commons DBCP
    BasicDataSource.getConnection
    1. org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
    2. org.apache.commons.dbcp.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:332)
    3. org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1249)
    4. org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)
    5. org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
    5 frames
  4. Spring Framework
    TransactionAwareDataSourceProxy.getConnection
    1. org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)
    2. org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy.getConnection(TransactionAwareDataSourceProxy.java:109)
    2 frames
  5. Spring ORM
    SqlMapClientTemplate.queryForObject
    1. org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:190)
    2. org.springframework.orm.ibatis.SqlMapClientTemplate.queryForObject(SqlMapClientTemplate.java:271)
    2 frames
  6. org.nexweb.qol
    WelcomeAction.execute
    1. org.nexweb.qol.gcc.ibatis.dao.sqlmaps.UserSqlMapDAO.getUserByUserNameAndRealmName(UserSqlMapDAO.java:26)
    2. org.nexweb.qol.gcc.ibatis.services.UserService.getUserByUserNameAndRealmName(UserService.java:30)
    3. org.nexweb.qol.gcc.actions.WelcomeAction.execute(WelcomeAction.java:76)
    3 frames
  7. Struts Core
    ActionCommandBase.execute
    1. org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
    2. org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
    3. org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
    3 frames
  8. Commons Chain
    ChainBase.execute
    1. org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
    2. org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304)
    3. org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
    3 frames
  9. Struts Core
    ComposableRequestProcessor.process
    1. org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
    1 frame
  10. struts
    ActionServlet.doGet
    1. org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
    2. org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
    2 frames
  11. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
    2. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    2 frames
  12. com.evermind.server
    ServletRequestDispatcher$2.oc4jRun
    1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)
    2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
    3. com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:259)
    4. com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:51)
    5. com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:193)
    5 frames
  13. oracle.oc4j.security
    OC4JSecurity.doPrivileged
    1. oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:283)
    1 frame
  14. com.evermind.server
    EvermindPageContext.forward
    1. com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:198)
    2. com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:392)
    2 frames
  15. _jsp
    _forward._jspService
    1. _jsp._forward._jspService(_forward.java:48)
    1 frame
  16. com.orionserver.http
    OrionHttpJspPage.service
    1. com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
    1 frame
  17. oracle.jsp.runtimev2
    JspServlet.service
    1. oracle.jsp.runtimev2.JspPageTable.compileAndServe(JspPageTable.java:724)
    2. oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:414)
    3. oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
    4. oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
    4 frames
  18. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    1 frame
  19. com.evermind.server
    HttpRequestHandler.run
    1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)
    2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
    3. com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
    4. com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
    5. com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:221)
    6. com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:122)
    7. com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:111)
    7 frames
  20. oracle.oc4j.network
    ServerSocketReadHandler$SafeRunnable.run
    1. oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
    1 frame
  21. com.evermind.util
    ReleasableResourcePooledExecutor$MyWorker.run
    1. com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
    1 frame
  22. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:595)
    1 frame