Uploaded image for project: 'Jetspeed (Retired)'
  1. Jetspeed (Retired)
  2. JS1-183

nonexistent sequence error with oracle

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Reopened
    • Resolution: Unresolved
    • 1.4b2-dev / CVS
    • None
    • Database
    • None
    • Operating System: Other
      Platform: All
    • 15511

    Description

      I have checked out the latest jetspeed from cvs. The oracle schema and
      population scripts ran fine, and I checked to make sure that all of the
      database objects were created correctly. I selected from the sequences myself
      to make sure they're working. When adding a new user, however, I get the
      exception at the bottom of this description. Basically, it's selecting from
      some non-existent sequence. I spent over an hour digging around the jetspeed
      and torque code and was unable to even figure out where the sequence name was
      being generated. The latest torque code depends on a jar that maven can't
      find, so I wasn't able to test whether it was a problem in torque or jetspeed.
      The torque configuration is right out of the installation docs and the oracle
      jdbc drivers are being used, so I believe that that is all correct. I checked
      Torque bugzilla and didn't see any related bugs reported for 3.0, so I'm
      guessing this is a problem in jetspeed. Hopefully I'm not wasting anyone's
      time.

      java.sql.SQLException: ORA-02289: sequence does not exist
      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
      at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
      at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
      at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
      at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe
      (TTC7Protocol.java:830)
      at oracle.jdbc.driver.OracleStatement.doExecuteQuery
      (OracleStatement.java:2391)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout
      (OracleStatement.java:2672)
      at oracle.jdbc.driver.OracleStatement.executeQuery
      (OracleStatement.java:572)
      at com.workingdogs.village.QueryDataSet.(Unknown Source)
      at org.apache.torque.oid.SequenceIdGenerator.getIdAsVillageValue
      (SequenceIdGenerator.java:195)
      at org.apache.torque.oid.SequenceIdGenerator.getIdAsBigDecimal
      (SequenceIdGenerator.java:132)
      at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:702)
      at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:615)
      at org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doInsert
      (BaseTurbineUserPeer.java:242)
      at org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doInsert
      (BaseTurbineUserPeer.java:215)
      at
      org.apache.jetspeed.services.security.turbine.TurbineUserManagement.addUser
      (TurbineUserManagement.java:309)
      at org.apache.jetspeed.services.JetspeedUserManagement.addUser
      (JetspeedUserManagement.java:134)
      at org.apache.jetspeed.services.JetspeedSecurity.addUser
      (JetspeedSecurity.java:238)
      at org.apache.jetspeed.modules.actions.CreateNewUserAndConfirm.doPerform
      (CreateNewUserAndConfirm.java:206)
      at org.apache.turbine.modules.Action.perform(Action.java:87)
      at org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122)
      at org.apache.turbine.modules.pages.DefaultPage.doBuild
      (DefaultPage.java:143)
      at org.apache.turbine.modules.Page.build(Page.java:90)
      at org.apache.turbine.modules.PageLoader.exec(PageLoader.java:123)
      at org.apache.turbine.Turbine.doGet(Turbine.java:563)
      at org.apache.turbine.Turbine.doPost(Turbine.java:658)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
      (Unknown Source)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown
      Source)
      at org.apache.catalina.core.StandardWrapperValve.invoke(Unknown Source)
      at
      org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex
      t(Unknown Source)
      at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
      at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
      at org.apache.catalina.core.StandardContextValve.invoke(Unknown Source)
      at
      org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex
      t(Unknown Source)
      at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
      at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
      at org.apache.catalina.core.StandardContext.invoke(Unknown Source)
      at org.apache.catalina.core.StandardHostValve.invoke(Unknown Source)
      at
      org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex
      t(Unknown Source)
      at org.apache.catalina.valves.ErrorDispatcherValve.invoke(Unknown
      Source)
      at
      org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex
      t(Unknown Source)
      at org.apache.catalina.valves.ErrorReportValve.invoke(Unknown Source)
      at
      org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex
      t(Unknown Source)
      at org.apache.catalina.valves.AccessLogValve.invoke(Unknown Source)
      at
      org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex
      t(Unknown Source)
      at org.apache.catalina.authenticator.SingleSignOn.invoke(Unknown Source)
      at
      org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex
      t(Unknown Source)
      at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
      at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
      at org.apache.catalina.core.StandardEngineValve.invoke(Unknown Source)
      at
      org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex
      t(Unknown Source)
      at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
      at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
      at org.apache.coyote.tomcat4.CoyoteAdapter.service
      (CoyoteAdapter.java:223)
      at org.apache.coyote.http11.Http11Processor.process
      (Http11Processor.java:405)
      at
      org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnectio
      n(Http11Protocol.java:380)
      at org.apache.tomcat.util.net.TcpWorkerThread.runIt
      (PoolTcpEndpoint.java:508)
      at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run
      (ThreadPool.java:533)
      at java.lang.Thread.run(Thread.java:536)

      java.sql.SQLException: ORA-02289: sequence does not exist
      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
      at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
      at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
      at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
      at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe
      (TTC7Protocol.java:830)
      at oracle.jdbc.driver.OracleStatement.doExecuteQuery
      (OracleStatement.java:2391)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout
      (OracleStatement.java:2672)
      at oracle.jdbc.driver.OracleStatement.executeQuery
      (OracleStatement.java:572)
      at com.workingdogs.village.QueryDataSet.(Unknown Source)
      at org.apache.torque.oid.SequenceIdGenerator.getIdAsVillageValue
      (SequenceIdGenerator.java:195)
      at org.apache.torque.oid.SequenceIdGenerator.getIdAsBigDecimal
      (SequenceIdGenerator.java:132)
      at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:702)
      at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:615)
      at org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doInsert
      (BaseTurbineUserPeer.java:242)
      at org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doInsert
      (BaseTurbineUserPeer.java:215)
      at
      org.apache.jetspeed.services.security.turbine.TurbineUserManagement.addUser
      (TurbineUserManagement.java:309)
      at org.apache.jetspeed.services.JetspeedUserManagement.addUser
      (JetspeedUserManagement.java:134)
      at org.apache.jetspeed.services.JetspeedSecurity.addUser
      (JetspeedSecurity.java:238)
      at org.apache.jetspeed.modules.actions.CreateNewUserAndConfirm.doPerform
      (CreateNewUserAndConfirm.java:206)
      at org.apache.turbine.modules.Action.perform(Action.java:87)
      at org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122)
      at org.apache.turbine.modules.pages.DefaultPage.doBuild
      (DefaultPage.java:143)
      at org.apache.turbine.modules.Page.build(Page.java:90)
      at org.apache.turbine.modules.PageLoader.exec(PageLoader.java:123)
      at org.apache.turbine.Turbine.doGet(Turbine.java:563)
      at org.apache.turbine.Turbine.doPost(Turbine.java:658)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
      (Unknown Source)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown
      Source)
      at org.apache.catalina.core.StandardWrapperValve.invoke(Unknown Source)
      at
      org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex
      t(Unknown Source)
      at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
      at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
      at org.apache.catalina.core.StandardContextValve.invoke(Unknown Source)
      at
      org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex
      t(Unknown Source)
      at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
      at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
      at org.apache.catalina.core.StandardContext.invoke(Unknown Source)
      at org.apache.catalina.core.StandardHostValve.invoke(Unknown Source)
      at
      org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex
      t(Unknown Source)
      at org.apache.catalina.valves.ErrorDispatcherValve.invoke(Unknown
      Source)
      at
      org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex
      t(Unknown Source)
      at org.apache.catalina.valves.ErrorReportValve.invoke(Unknown Source)
      at
      org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex
      t(Unknown Source)
      at org.apache.catalina.valves.AccessLogValve.invoke(Unknown Source)
      at
      org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex
      t(Unknown Source)
      at org.apache.catalina.authenticator.SingleSignOn.invoke(Unknown Source)
      at
      org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex
      t(Unknown Source)
      at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
      at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
      at org.apache.catalina.core.StandardEngineValve.invoke(Unknown Source)
      at
      org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex
      t(Unknown Source)
      at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
      at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
      at org.apache.coyote.tomcat4.CoyoteAdapter.service
      (CoyoteAdapter.java:223)
      at org.apache.coyote.http11.Http11Processor.process
      (Http11Processor.java:405)
      at
      org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnectio
      n(Http11Protocol.java:380)
      at org.apache.tomcat.util.net.TcpWorkerThread.runIt
      (PoolTcpEndpoint.java:508)
      at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run
      (ThreadPool.java:533)
      at java.lang.Thread.run(Thread.java:536)

      Attachments

        Activity

          People

            Unassigned Unassigned
            petro@christopherpetro.com Christopher A. Petro
            Votes:
            1 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: