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

    Exception on startup in oracle

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

    Automated exception search integrated into your IDE

  4. 0

    maximum open cursors exceeded

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

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

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

    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