DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://nagoya.apache.org/bugzilla/show_bug.cgi?id=15511>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE.
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=15511 nonexistent sequence error with oracle Summary: nonexistent sequence error with oracle Product: Jetspeed Version: 1.4b4-dev /CVS Platform: All OS/Version: Other Status: NEW Severity: Normal Priority: Other Component: Database AssignedTo: [EMAIL PROTECTED] ReportedBy: [EMAIL PROTECTED] 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) -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
