seek answer on your Q. in this mail-list - my Jetspeed1.5 & Oracle 9.2.xx - work excellent
Hampton, Thomas wrote:
I'm getting the following error when trying to create a new user account when running jetspeed 1.5 with Oracle.
org.apache.jetspeed.services.security.UserException: Failed to create account 'a': ORA-04016: sequence TURBINE_USER no longer exists
I created a database and ran the C:\jetspeed-1.5\src\sql\external\turbine-oracle.sql
and
C:\jetspeed-1.5\src\sql\external\populate-oracle.sql
Sql scripts.
Copied the oracle JDBC driver into lib directory.
Made the following modifications to the Torque.properties file torque.database.default.adapter=oracle torque.dsfactory.default.connection.driver = oracle.jdbc.driver.OracleDriver torque.dsfactory.default.connection.url = jdbc:oracle:thin:@localhost:1521:orcl torque.dsfactory.default.connection.user = jetspeed torque.dsfactory.default.connection.password = jetspeed
What else do I need to do? I'm working with a Jetspeed 1.5 source distribution, not pulled from the CVS tree.
Seems like the code is somehow expecting a sequence called TURBINE_USER but it's called TURBINE_USER_SEQ in the sql file. Is there something that needs to be changed in the security-schema.xml file ?
Thanks, Tom
The stack trace :
java.sql.SQLException: ORA-04016: sequence TURBINE_USER no longer exists at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:12 5) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112) at oracle.jdbc.driver.T4CStatement.execute_for_describe(T4CStatement.java:3 51) at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatemen t.java:896) at oracle.jdbc.driver.T4CStatement.execute_maybe_describe(T4CStatement.java :383) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement. java:986) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:112 5) at com.workingdogs.village.QueryDataSet.(Unknown Source) at org.apache.torque.oid.SequenceIdGenerator.getIdAsVillageValue(SequenceId Generator.java:199) at org.apache.torque.oid.SequenceIdGenerator.getIdAsBigDecimal(SequenceIdGe nerator.java:133) at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:720) at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:639) at org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doInsert(Bas eTurbineUserPeer.java:241) at org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doInsert(Bas eTurbineUserPeer.java:214) at org.apache.jetspeed.services.security.turbine.TurbineUserManagement.addU ser(TurbineUserManagement.java:283) at org.apache.jetspeed.services.JetspeedUserManagement.addUser(JetspeedUser Management.java:95) at org.apache.jetspeed.services.JetspeedSecurity.addUser(JetspeedSecurity.j ava:213) at org.apache.jetspeed.modules.actions.CreateNewUserAndConfirm.doPerform(Cr eateNewUserAndConfirm.java:171) 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:14 3) 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:760) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica tionFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv e.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nvokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4 80) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv e.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nvokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4 80) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:242 2) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java :180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nvokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherVa lve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nvokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java :163) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nvokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4 80) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve. java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nvokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4 80) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:199) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:82 8) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC onnection(Http11Protocol.java:700) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:58 4) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool .java:683) at java.lang.Thread.run(Thread.java:534)
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
