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

ibatis-user-java | Jasmin Mehta | 7 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  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 | 8 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

    java.sql.SQLException: ORA-00917: missing comma

    Stack Overflow | 3 years ago | Jeff Levine
    java.sql.SQLException: ORA-00917: missing comma

  1. treefolk 6 times, last 3 months 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